DBA Data[Home] [Help]

APPS.WSMPUTIL dependencies on BOM_CALENDAR_DATES

Line 509: FROM BOM_CALENDAR_DATES BCD1,

505:
506:
507: CURSOR forward_cur(p_lead_time NUMBER) IS
508: SELECT BCD1.CALENDAR_DATE
509: FROM BOM_CALENDAR_DATES BCD1,
510: BOM_CALENDAR_DATES BCD2,
511: MTL_PARAMETERS MP
512: WHERE MP.ORGANIZATION_ID = p_organization_id
513: AND BCD1.CALENDAR_CODE = MP.CALENDAR_CODE

Line 510: BOM_CALENDAR_DATES BCD2,

506:
507: CURSOR forward_cur(p_lead_time NUMBER) IS
508: SELECT BCD1.CALENDAR_DATE
509: FROM BOM_CALENDAR_DATES BCD1,
510: BOM_CALENDAR_DATES BCD2,
511: MTL_PARAMETERS MP
512: WHERE MP.ORGANIZATION_ID = p_organization_id
513: AND BCD1.CALENDAR_CODE = MP.CALENDAR_CODE
514: AND BCD2.CALENDAR_CODE = MP.CALENDAR_CODE

Line 523: FROM BOM_CALENDAR_DATES BCD1,

519: CEIL(p_lead_time);
520:
521: CURSOR backward_cur(p_lead_time NUMBER) IS
522: SELECT BCD1.CALENDAR_DATE
523: FROM BOM_CALENDAR_DATES BCD1,
524: BOM_CALENDAR_DATES BCD2,
525: MTL_PARAMETERS MP
526: WHERE MP.ORGANIZATION_ID = p_organization_id
527: AND BCD1.CALENDAR_CODE = MP.CALENDAR_CODE

Line 524: BOM_CALENDAR_DATES BCD2,

520:
521: CURSOR backward_cur(p_lead_time NUMBER) IS
522: SELECT BCD1.CALENDAR_DATE
523: FROM BOM_CALENDAR_DATES BCD1,
524: BOM_CALENDAR_DATES BCD2,
525: MTL_PARAMETERS MP
526: WHERE MP.ORGANIZATION_ID = p_organization_id
527: AND BCD1.CALENDAR_CODE = MP.CALENDAR_CODE
528: AND BCD2.CALENDAR_CODE = MP.CALENDAR_CODE