APPS.CSL_MTL_ONHAND_QTY_ACC_PKG dependencies on MTL_SYSTEM_ITEMS_B

Line 219: FROM MTL_SYSTEM_ITEMS_B

215: CURSOR c_trackable_flag(b_inventory_item_id IN NUMBER
216: ,b_organization_id IN NUMBER
217: ) IS
218: SELECT COMMS_NL_TRACKABLE_FLAG
219: FROM MTL_SYSTEM_ITEMS_B
220: WHERE INVENTORY_ITEM_ID = b_inventory_item_id
221: AND ORGANIZATION_ID = b_organization_id;
222:
223: r_trackable_flag c_trackable_flag%ROWTYPE;

Line 233: TYPE track_flagTab IS TABLE OF mtl_system_items_b.comms_nl_trackable_flag%TYPE INDEX BY BINARY_INTEGER;

229: TYPE rvsionTab IS TABLE OF csl_mtl_onhand_qty_acc.revision%TYPE INDEX BY BINARY_INTEGER;
230: TYPE loc_idTab IS TABLE OF csl_mtl_onhand_qty_acc.locator_id%TYPE INDEX BY BINARY_INTEGER;
231: TYPE lot_numTab IS TABLE OF csl_mtl_onhand_qty_acc.lot_number%TYPE INDEX BY BINARY_INTEGER;
232: TYPE res_idTab IS TABLE OF csl_mtl_onhand_qty_acc.resource_id%TYPE INDEX BY BINARY_INTEGER;
233: TYPE track_flagTab IS TABLE OF mtl_system_items_b.comms_nl_trackable_flag%TYPE INDEX BY BINARY_INTEGER;
234: acc_id access_idTab;
235: inv_id inv_idTab;
236: org_id org_idTab;
237: sub_code sub_codeTab;