salam,
saya ngak tau yg kamu mau itu seperti apa, soalnya di Oracle itu ada
BOM working day, HR working day, etc..
ini adalah contoh BOM working day (tgl produksi)
select Count(CALENDAR_DATE)
from BOM_CALENDAR_DATES
where SEQ_NUM is not null
and NEXT_SEQ_NUM is not null
and PRIOR_SEQ_NUM is not null
and prior_date=next_date
and to_char(CALENDAR_DATE,'MON-YYYY')=to_char(:P_DATE,'MON-YYYY')
and calendar_code=(Select calendar_code
From BOM_CALENDARS
Where calendar_code=(Select CALENDAR_CODE
From MTL_PARAMETERS
Where
ORGANIZATION_ID=:P_ORGANIZATION_ID));
--- In [email protected], "daniel_d" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> saya sedang mencari sql statement untuk mencari working day dalam satu
> bulan.
> ada yang ide?
>
> Daniel
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.blogspot.com
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.vze.com
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indo-oracle/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
