DBA Data[Home] [Help]

APPS.MRP_SOURCING_GRP dependencies on MTL_SYSTEM_ITEMS

Line 19: FROM mtl_system_items

15:
16: SELECT stock_enabled_flag, restrict_subinventories_code
17: INTO var_stk,
18: var_restrict
19: FROM mtl_system_items
20: WHERE organization_id = arg_org_id
21: AND inventory_item_id = arg_item_id;
22:
23: if var_stk <> 'Y'

Line 239: FROM mtl_system_items msi,

235: SELECT msi.source_organization_id,
236: msi.source_subinventory
237: INTO var_source_org,
238: var_source_sub
239: FROM mtl_system_items msi,
240: org_organization_definitions ood,
241: financials_system_parameters fsp
242: WHERE msi.organization_id = p_dest_organization_id
243: AND msi.inventory_item_id = p_item_id