APPS.CSP_MINMAX_PVT dependencies on BOM_CALENDAR_DATES

Line 1140: FROM mtl_supply sup, bom_calendar_dates c1, bom_calendar_dates c

1136:
1137:
1138: l_stmt VARCHAR2(4000) :=
1139: ' SELECT NVL(sum(to_org_primary_quantity), 0)
1140: FROM mtl_supply sup, bom_calendar_dates c1, bom_calendar_dates c
1141: WHERE sup.supply_type_code IN (''PO'',''REQ'',''SHIPMENT'',''RECEIVING'')
1142: AND sup.destination_type_code = ''INVENTORY''
1143: AND sup.to_organization_id = :l_org_id
1144: AND sup.item_id = :l_item_id

Line 2536: FROM bom_calendar_dates c1,

2532: --
2533:
2534: SELECT c1.calendar_date
2535: INTO l_need_by_date
2536: FROM bom_calendar_dates c1,
2537: bom_calendar_dates c
2538: WHERE c1.calendar_code = c.calendar_code
2539: AND c1.exception_set_id = c.exception_set_id
2540: AND c1.seq_num = (c.next_seq_num + trunc(p_buying_lead_time))

Line 2537: bom_calendar_dates c

2533:
2534: SELECT c1.calendar_date
2535: INTO l_need_by_date
2536: FROM bom_calendar_dates c1,
2537: bom_calendar_dates c
2538: WHERE c1.calendar_code = c.calendar_code
2539: AND c1.exception_set_id = c.exception_set_id
2540: AND c1.seq_num = (c.next_seq_num + trunc(p_buying_lead_time))
2541: AND c.calendar_code = p_cal_code