DBA Data[Home] [Help]

APPS.MSC_POST_PRO dependencies on MSC_ATP_REQ

Line 1673: MSC_ATP_REQ.G_PURCHASE_ORDER_PREFERENCE := NVL(FND_PROFILE.VALUE('MSC_PO_DOCK_DATE_CALC_PREF'), 2);

1669: l_sysdate := sysdate;
1670: l_user_id := FND_GLOBAL.USER_ID;
1671:
1672: ---profile option for including purchase order
1673: MSC_ATP_REQ.G_PURCHASE_ORDER_PREFERENCE := NVL(FND_PROFILE.VALUE('MSC_PO_DOCK_DATE_CALC_PREF'), 2);
1674:
1675: IF p_full_refresh = 1 THEN -- Full refresh - for summary enhancement
1676:
1677: -- Data for share_partition='N' has already been deleted

Line 7887: OR (MSC_ATP_REQ.G_PURCHASE_ORDER_PREFERENCE = MSC_ATP_REQ.G_PROMISE_DATE

7883: msc_system_items I
7884: WHERE I.plan_id = p_plan_id
7885: AND I.atp_components_flag in ( 'Y', 'C')
7886: AND (p.order_type IN (5, 2)
7887: OR (MSC_ATP_REQ.G_PURCHASE_ORDER_PREFERENCE = MSC_ATP_REQ.G_PROMISE_DATE
7888: AND p.order_type = 1 AND p.promised_date IS NULL))
7889: AND p.plan_id = I.plan_id
7890: AND p.sr_instance_id = I.sr_instance_id
7891: AND p.inventory_item_id = I.inventory_item_id

Line 7972: OR (MSC_ATP_REQ.G_PURCHASE_ORDER_PREFERENCE = MSC_ATP_REQ.G_PROMISE_DATE

7968: msc_system_items I
7969: WHERE I.plan_id = p_plan_id
7970: AND I.atp_components_flag in ( 'Y', 'C')
7971: AND (p.order_type IN (5, 2)
7972: OR (MSC_ATP_REQ.G_PURCHASE_ORDER_PREFERENCE = MSC_ATP_REQ.G_PROMISE_DATE
7973: AND p.order_type = 1 AND p.promised_date IS NULL))
7974: AND p.plan_id = I.plan_id
7975: AND p.sr_instance_id = I.sr_instance_id
7976: AND p.inventory_item_id = I.inventory_item_id