DBA Data[Home] [Help]

APPS.OE_VALIDATE_LINE dependencies on MTL_PARAMETERS

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

1606: IF l_debug_level > 0 then
1607: oe_debug_pub.add('Entering Validate_task_reqd',1);
1608: END IF;
1609:
1610: -- If project control level in MTL_PARAMETERS for the warehouse
1611: -- is set to 'Task', then project references on the order must
1612: -- consist of both Project and Task.
1613:
1614: SELECT NVL(PROJECT_CONTROL_LEVEL,0)

Line 1616: FROM MTL_PARAMETERS

1612: -- consist of both Project and Task.
1613:
1614: SELECT NVL(PROJECT_CONTROL_LEVEL,0)
1615: INTO l_project_control_level
1616: FROM MTL_PARAMETERS
1617: WHERE ORGANIZATION_ID = p_ship_from_org_id;
1618:
1619: IF l_project_control_level = 2 -- control level is 'Task'
1620: THEN

Line 1831: ,mtl_parameters mp -- 4402603

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

Line 1852: ,mtl_parameters mp -- 4402603

1848: INTO l_dummy
1849: FROM mtl_customer_items citems
1850: ,mtl_customer_item_xrefs cxref
1851: ,mtl_system_items_vl sitems
1852: ,mtl_parameters mp -- 4402603
1853: WHERE citems.customer_item_id = cxref.customer_item_id
1854: AND cxref.inventory_item_id = sitems.inventory_item_id
1855: AND sitems.inventory_item_id = p_inventory_item_id
1856: AND sitems.organization_id =