DBA Data[Home] [Help]

APPS.MRP_REL_PLAN_PUB dependencies on BOM_CALENDAR_DATES

Line 906: FROM bom_calendar_dates cal1,

902: BEGIN
903:
904: SELECT cal2.calendar_date
905: INTO source_date
906: FROM bom_calendar_dates cal1,
907: bom_calendar_dates cal2
908: WHERE cal1.calendar_code = arg_calendar_code
909: AND cal1.exception_set_id = arg_calendar_exception_set_id
910: AND cal1.calendar_date = arg_implement_date

Line 907: bom_calendar_dates cal2

903:
904: SELECT cal2.calendar_date
905: INTO source_date
906: FROM bom_calendar_dates cal1,
907: bom_calendar_dates cal2
908: WHERE cal1.calendar_code = arg_calendar_code
909: AND cal1.exception_set_id = arg_calendar_exception_set_id
910: AND cal1.calendar_date = arg_implement_date
911: AND cal2.calendar_code = cal1.calendar_code

Line 919: FROM bom_calendar_dates cal1,

915:
916: BEGIN
917: SELECT cal2.calendar_date
918: INTO dock_date
919: FROM bom_calendar_dates cal1,
920: bom_calendar_dates cal2,
921: mrp_item_suppliers mis
922: WHERE mis.organization_id = arg_plan_owning_org /*2448572*/
923: AND mis.compile_designator = arg_compile_desig

Line 920: bom_calendar_dates cal2,

916: BEGIN
917: SELECT cal2.calendar_date
918: INTO dock_date
919: FROM bom_calendar_dates cal1,
920: bom_calendar_dates cal2,
921: mrp_item_suppliers mis
922: WHERE mis.organization_id = arg_plan_owning_org /*2448572*/
923: AND mis.compile_designator = arg_compile_desig
924: AND mis.supplier_id = arg_vendor_id