DBA Data[Home] [Help]

APPS.INV_INVARUIR_XMLP_PKG dependencies on BOM_CALENDAR_DATES

Line 110: BOM_CALENDAR_DATES BC1,

106: SELECT
107: BC1.NEXT_SEQ_NUM - BC2.NEXT_SEQ_NUM + 1
108: INTO NWORKDAYS
109: FROM
110: BOM_CALENDAR_DATES BC1,
111: BOM_CALENDAR_DATES BC2
112: WHERE TO_CHAR(BC2.CALENDAR_DATE
113: ,'DD-MON-RRRR') = YEARBEGINDATE
114: AND TO_CHAR(BC1.CALENDAR_DATE

Line 111: BOM_CALENDAR_DATES BC2

107: BC1.NEXT_SEQ_NUM - BC2.NEXT_SEQ_NUM + 1
108: INTO NWORKDAYS
109: FROM
110: BOM_CALENDAR_DATES BC1,
111: BOM_CALENDAR_DATES BC2
112: WHERE TO_CHAR(BC2.CALENDAR_DATE
113: ,'DD-MON-RRRR') = YEARBEGINDATE
114: AND TO_CHAR(BC1.CALENDAR_DATE
115: ,'DD-MON-RRRR') = YEARENDDATE