DBA Data[Home] [Help]

APPS.WIP_MTI_PUB dependencies on MTL_PARAMETERS

Line 646: from mtl_parameters p,

642: p.stock_locator_control_code),
643: nvl(project_reference_enabled, 2)
644: into l_locatorCntlCode,
645: l_projRefEnabled
646: from mtl_parameters p,
647: mtl_secondary_inventories s,
648: mtl_system_items i
649: where i.inventory_item_id = pt_rec.inventory_item_id
650: and i.organization_id = pt_rec.organization_id

Line 1902: from mtl_parameters

1898: -- do the snapshot moves for non-CFM WIP completions,returns, scraps
1899: for nonCfm_rec in nonCfm_c loop
1900: select primary_cost_method
1901: into l_primaryCostMethod
1902: from mtl_parameters
1903: where organization_id = nonCfm_rec.organization_id;
1904:
1905: if ( l_primaryCostMethod in (2, 5, 6) ) then
1906: select primary_uom_code

Line 2402: from mtl_parameters mp,

2398: 5, it.location_control_code,
2399: sub.locator_type),
2400: mp.stock_locator_control_code)
2401: into l_locctrl
2402: from mtl_parameters mp,
2403: mtl_secondary_inventories sub,
2404: mtl_system_items it
2405: where it.inventory_item_id = l_itemIDTbl(i)
2406: and sub.secondary_inventory_name = l_subCodeTbl(i)