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 2885: FROM bom_calendar_dates c1,

2881: WHERE p.organization_id = l_src_org;
2882:
2883: SELECT c1.calendar_date
2884: INTO x_scheduled_ship_date
2885: FROM bom_calendar_dates c1,
2886: bom_calendar_dates c
2887: WHERE c1.calendar_code = c.calendar_code
2888: AND c1.exception_set_id = c.exception_set_id
2889: AND c1.seq_num = c.next_seq_num

Line 2886: bom_calendar_dates c

2882:
2883: SELECT c1.calendar_date
2884: INTO x_scheduled_ship_date
2885: FROM bom_calendar_dates c1,
2886: bom_calendar_dates c
2887: WHERE c1.calendar_code = c.calendar_code
2888: AND c1.exception_set_id = c.exception_set_id
2889: AND c1.seq_num = c.next_seq_num
2890: AND c.calendar_code = l_so_cal_code

Line 3349: FROM bom_calendar_dates c1,

3345: -- Here, total lead time is the total buying Lead time
3346: --
3347: SELECT c1.calendar_date
3348: INTO l_sourcing_date
3349: FROM bom_calendar_dates c1,
3350: bom_calendar_dates c
3351: WHERE c1.calendar_code = c.calendar_code
3352: AND c1.exception_set_id = c.exception_set_id
3353: AND c1.seq_num = (c.next_seq_num + trunc(p_buying_lead_time))

Line 3350: bom_calendar_dates c

3346: --
3347: SELECT c1.calendar_date
3348: INTO l_sourcing_date
3349: FROM bom_calendar_dates c1,
3350: bom_calendar_dates c
3351: WHERE c1.calendar_code = c.calendar_code
3352: AND c1.exception_set_id = c.exception_set_id
3353: AND c1.seq_num = (c.next_seq_num + trunc(p_buying_lead_time))
3354: AND c.calendar_code = p_cal_code

Line 3430: FROM bom_calendar_dates c1,

3426: --
3427: BEGIN
3428: SELECT c1.calendar_date
3429: INTO l_need_by_date
3430: FROM bom_calendar_dates c1,
3431: bom_calendar_dates c
3432: WHERE c1.calendar_code = c.calendar_code
3433: AND c1.exception_set_id = c.exception_set_id
3434: AND c1.seq_num = (c.next_seq_num)

Line 3431: bom_calendar_dates c

3427: BEGIN
3428: SELECT c1.calendar_date
3429: INTO l_need_by_date
3430: FROM bom_calendar_dates c1,
3431: bom_calendar_dates c
3432: WHERE c1.calendar_code = c.calendar_code
3433: AND c1.exception_set_id = c.exception_set_id
3434: AND c1.seq_num = (c.next_seq_num)
3435: AND c.calendar_code = p_cal_code