DBA Data[Home] [Help]

APPS.MRP_SOURCING_API_PK dependencies on MTL_SYSTEM_ITEMS

Line 24: FROM mtl_system_items

20: mrdebug := FND_PROFILE.VALUE('MRP_DEBUG') = 'Y';
21: SELECT stock_enabled_flag, restrict_subinventories_code
22: INTO var_stk,
23: var_restrict
24: FROM mtl_system_items
25: WHERE organization_id = arg_org_id
26: AND inventory_item_id = arg_item_id;
27:
28: if var_stk <> 'Y'

Line 224: FROM mtl_system_items msi,

220: SELECT msi.source_organization_id,
221: msi.source_subinventory
222: INTO var_source_org,
223: var_source_sub
224: FROM mtl_system_items msi,
225: org_organization_definitions ood,
226: financials_system_parameters fsp
227: WHERE msi.organization_id = arg_dest_organization_id
228: AND msi.inventory_item_id = arg_item_id