DBA Data[Home] [Help]

APPS.WIP_MTI_PUB dependencies on MTL_PARAMETERS

Line 653: from mtl_parameters p,

649: p.stock_locator_control_code),
650: nvl(project_reference_enabled, 2)
651: into l_locatorCntlCode,
652: l_projRefEnabled
653: from mtl_parameters p,
654: mtl_secondary_inventories s,
655: mtl_system_items i
656: where i.inventory_item_id = pt_rec.inventory_item_id
657: and i.organization_id = pt_rec.organization_id

Line 1952: from mtl_parameters

1948: unless the CCSI is validate. */
1949: for nonCfm_rec in nonCfm_c loop
1950: select primary_cost_method
1951: into l_primaryCostMethod
1952: from mtl_parameters
1953: where organization_id = nonCfm_rec.organization_id;
1954:
1955: if ( l_primaryCostMethod in (2, 5, 6) ) then
1956: select primary_uom_code

Line 2451: from mtl_parameters mp,

2447: 5, it.location_control_code,
2448: sub.locator_type),
2449: mp.stock_locator_control_code)
2450: into l_locctrl
2451: from mtl_parameters mp,
2452: mtl_secondary_inventories sub,
2453: mtl_system_items it
2454: where it.inventory_item_id = l_itemIDTbl(i)
2455: and sub.secondary_inventory_name = l_subCodeTbl(i)