APPS.INV_MINMAX_PVT dependencies on BOM_CALENDAR_DATES

Line 1042: , bom_calendar_dates c

1038:
1039: l_stmt VARCHAR2(4000) :=
1040: ' SELECT NVL(sum(to_org_primary_quantity), 0)
1041: FROM mtl_supply sup
1042: , bom_calendar_dates c
1043: , bom_calendar_dates c1
1044: WHERE sup.supply_type_code IN (''PO'',''REQ'',''SHIPMENT'',''RECEIVING'')
1045: AND sup.destination_type_code = ''INVENTORY''
1046: AND sup.to_organization_id = :l_org_id

Line 1043: , bom_calendar_dates c1

1039: l_stmt VARCHAR2(4000) :=
1040: ' SELECT NVL(sum(to_org_primary_quantity), 0)
1041: FROM mtl_supply sup
1042: , bom_calendar_dates c
1043: , bom_calendar_dates c1
1044: WHERE sup.supply_type_code IN (''PO'',''REQ'',''SHIPMENT'',''RECEIVING'')
1045: AND sup.destination_type_code = ''INVENTORY''
1046: AND sup.to_organization_id = :l_org_id
1047: AND sup.item_id = :l_item_id

Line 2875: FROM bom_calendar_dates c1,

2871: WHERE p.organization_id = l_src_org;
2872:
2873: SELECT c1.calendar_date
2874: INTO x_scheduled_ship_date
2875: FROM bom_calendar_dates c1,
2876: bom_calendar_dates c
2877: WHERE c1.calendar_code = c.calendar_code
2878: AND c1.exception_set_id = c.exception_set_id
2879: AND c1.seq_num = c.next_seq_num

Line 2876: bom_calendar_dates c

2872:
2873: SELECT c1.calendar_date
2874: INTO x_scheduled_ship_date
2875: FROM bom_calendar_dates c1,
2876: bom_calendar_dates c
2877: WHERE c1.calendar_code = c.calendar_code
2878: AND c1.exception_set_id = c.exception_set_id
2879: AND c1.seq_num = c.next_seq_num
2880: AND c.calendar_code = l_so_cal_code

Line 3339: FROM bom_calendar_dates c1,

3335: -- Here, total lead time is the total buying Lead time
3336: --
3337: SELECT c1.calendar_date
3338: INTO l_sourcing_date
3339: FROM bom_calendar_dates c1,
3340: bom_calendar_dates c
3341: WHERE c1.calendar_code = c.calendar_code
3342: AND c1.exception_set_id = c.exception_set_id
3343: AND c1.seq_num = (c.next_seq_num + trunc(p_buying_lead_time))

Line 3340: bom_calendar_dates c

3336: --
3337: SELECT c1.calendar_date
3338: INTO l_sourcing_date
3339: FROM bom_calendar_dates c1,
3340: bom_calendar_dates c
3341: WHERE c1.calendar_code = c.calendar_code
3342: AND c1.exception_set_id = c.exception_set_id
3343: AND c1.seq_num = (c.next_seq_num + trunc(p_buying_lead_time))
3344: AND c.calendar_code = p_cal_code

Line 3420: FROM bom_calendar_dates c1,

3416: --
3417: BEGIN
3418: SELECT c1.calendar_date
3419: INTO l_need_by_date
3420: FROM bom_calendar_dates c1,
3421: bom_calendar_dates c
3422: WHERE c1.calendar_code = c.calendar_code
3423: AND c1.exception_set_id = c.exception_set_id
3424: AND c1.seq_num = (c.next_seq_num)

Line 3421: bom_calendar_dates c

3417: BEGIN
3418: SELECT c1.calendar_date
3419: INTO l_need_by_date
3420: FROM bom_calendar_dates c1,
3421: bom_calendar_dates c
3422: WHERE c1.calendar_code = c.calendar_code
3423: AND c1.exception_set_id = c.exception_set_id
3424: AND c1.seq_num = (c.next_seq_num)
3425: AND c.calendar_code = p_cal_code