DBA Data[Home] [Help]

APPS.OE_VALIDATE_LINE dependencies on MTL_PARAMETERS

Line 1586: -- If project control level in MTL_PARAMETERS for the warehouse

1582: IF l_debug_level > 0 then
1583: oe_debug_pub.add('Entering Validate_task_reqd',1);
1584: END IF;
1585:
1586: -- If project control level in MTL_PARAMETERS for the warehouse
1587: -- is set to 'Task', then project references on the order must
1588: -- consist of both Project and Task.
1589:
1590: SELECT NVL(PROJECT_CONTROL_LEVEL,0)

Line 1592: FROM MTL_PARAMETERS

1588: -- consist of both Project and Task.
1589:
1590: SELECT NVL(PROJECT_CONTROL_LEVEL,0)
1591: INTO l_project_control_level
1592: FROM MTL_PARAMETERS
1593: WHERE ORGANIZATION_ID = p_ship_from_org_id;
1594:
1595: IF l_project_control_level = 2 -- control level is 'Task'
1596: THEN

Line 1807: ,mtl_parameters mp -- 4402603

1803: INTO l_dummy
1804: FROM mtl_customer_items citems
1805: ,mtl_customer_item_xrefs cxref
1806: ,mtl_system_items_vl sitems
1807: ,mtl_parameters mp -- 4402603
1808: WHERE citems.customer_item_id = cxref.customer_item_id
1809: AND cxref.inventory_item_id = sitems.inventory_item_id
1810: AND sitems.inventory_item_id = p_inventory_item_id
1811: AND sitems.organization_id =

Line 1828: ,mtl_parameters mp -- 4402603

1824: INTO l_dummy
1825: FROM mtl_customer_items citems
1826: ,mtl_customer_item_xrefs cxref
1827: ,mtl_system_items_vl sitems
1828: ,mtl_parameters mp -- 4402603
1829: WHERE citems.customer_item_id = cxref.customer_item_id
1830: AND cxref.inventory_item_id = sitems.inventory_item_id
1831: AND sitems.inventory_item_id = p_inventory_item_id
1832: AND sitems.organization_id =