DBA Data[Home] [Help]

APPS.INV_SHORTCHECKEXEC_PUB dependencies on MTL_SYSTEM_ITEMS

Line 60: FROM mtl_system_items

56: --
57: CURSOR L_Item_crs ( p_organization_id IN NUMBER,
58: p_inventory_item_id IN NUMBER ) IS
59: SELECT 'X'
60: FROM mtl_system_items
61: WHERE inventory_item_id = p_inventory_item_id
62: AND organization_id = p_organization_id;
63: --
64: BEGIN

Line 196: FROM mtl_system_items

192: --
193: CURSOR L_Item_crs ( p_organization_id IN NUMBER,
194: p_inventory_item_id IN NUMBER ) IS
195: SELECT 'X'
196: FROM mtl_system_items
197: WHERE inventory_item_id = p_inventory_item_id
198: AND organization_id = p_organization_id;
199: --
200: CURSOR L_TransType_crs ( p_transaction_type_id IN NUMBER ) IS