eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSL_MTL_ONHAND_QTY_ACC_PKG dependencies on MTL_ONHAND_QUANTITIES

Line 9: g_table_name CONSTANT VARCHAR2(30) := 'MTL_ONHAND_QUANTITIES';

5: /*** Globals for notifications ***/
6: g_acc_table_name CONSTANT VARCHAR2(30) := 'CSL_MTL_ONHAND_QTY_ACC';
7: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
8: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_MTL_ONHAND_QTY');
9: g_table_name CONSTANT VARCHAR2(30) := 'MTL_ONHAND_QUANTITIES';
10: g_pk1_name CONSTANT VARCHAR2(30) := 'INVENTORY_ITEM_ID';
11: g_pk2_name CONSTANT VARCHAR2(30) := 'ORGANIZATION_ID';
12: g_pk3_name CONSTANT VARCHAR2(30) := 'SUBINVENTORY_CODE';
13: g_debug_level NUMBER;

Line 20: TYPE sub_codeTab IS TABLE OF mtl_onhand_quantities.subinventory_code%TYPE INDEX BY BINARY_INTEGER;

16: IS
17:
18: PRAGMA AUTONOMOUS_TRANSACTION;
19:
20: TYPE sub_codeTab IS TABLE OF mtl_onhand_quantities.subinventory_code%TYPE INDEX BY BINARY_INTEGER;
21: TYPE inv_idTab IS TABLE OF mtl_onhand_quantities.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
22: TYPE org_idTab IS TABLE OF mtl_onhand_quantities.organization_id%TYPE INDEX BY BINARY_INTEGER;
23: TYPE revisionTab IS TABLE OF mtl_onhand_quantities.revision%TYPE INDEX BY BINARY_INTEGER;
24: TYPE locatorTab IS TABLE OF mtl_onhand_quantities.locator_id%TYPE INDEX BY BINARY_INTEGER;

Line 21: TYPE inv_idTab IS TABLE OF mtl_onhand_quantities.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;

17:
18: PRAGMA AUTONOMOUS_TRANSACTION;
19:
20: TYPE sub_codeTab IS TABLE OF mtl_onhand_quantities.subinventory_code%TYPE INDEX BY BINARY_INTEGER;
21: TYPE inv_idTab IS TABLE OF mtl_onhand_quantities.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
22: TYPE org_idTab IS TABLE OF mtl_onhand_quantities.organization_id%TYPE INDEX BY BINARY_INTEGER;
23: TYPE revisionTab IS TABLE OF mtl_onhand_quantities.revision%TYPE INDEX BY BINARY_INTEGER;
24: TYPE locatorTab IS TABLE OF mtl_onhand_quantities.locator_id%TYPE INDEX BY BINARY_INTEGER;
25: TYPE tran_qtyTab IS TABLE OF mtl_onhand_quantities.transaction_quantity%TYPE INDEX BY BINARY_INTEGER;

Line 22: TYPE org_idTab IS TABLE OF mtl_onhand_quantities.organization_id%TYPE INDEX BY BINARY_INTEGER;

18: PRAGMA AUTONOMOUS_TRANSACTION;
19:
20: TYPE sub_codeTab IS TABLE OF mtl_onhand_quantities.subinventory_code%TYPE INDEX BY BINARY_INTEGER;
21: TYPE inv_idTab IS TABLE OF mtl_onhand_quantities.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
22: TYPE org_idTab IS TABLE OF mtl_onhand_quantities.organization_id%TYPE INDEX BY BINARY_INTEGER;
23: TYPE revisionTab IS TABLE OF mtl_onhand_quantities.revision%TYPE INDEX BY BINARY_INTEGER;
24: TYPE locatorTab IS TABLE OF mtl_onhand_quantities.locator_id%TYPE INDEX BY BINARY_INTEGER;
25: TYPE tran_qtyTab IS TABLE OF mtl_onhand_quantities.transaction_quantity%TYPE INDEX BY BINARY_INTEGER;
26: TYPE lot_numTab IS TABLE OF mtl_onhand_quantities.lot_number%TYPE INDEX BY BINARY_INTEGER;

Line 23: TYPE revisionTab IS TABLE OF mtl_onhand_quantities.revision%TYPE INDEX BY BINARY_INTEGER;

19:
20: TYPE sub_codeTab IS TABLE OF mtl_onhand_quantities.subinventory_code%TYPE INDEX BY BINARY_INTEGER;
21: TYPE inv_idTab IS TABLE OF mtl_onhand_quantities.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
22: TYPE org_idTab IS TABLE OF mtl_onhand_quantities.organization_id%TYPE INDEX BY BINARY_INTEGER;
23: TYPE revisionTab IS TABLE OF mtl_onhand_quantities.revision%TYPE INDEX BY BINARY_INTEGER;
24: TYPE locatorTab IS TABLE OF mtl_onhand_quantities.locator_id%TYPE INDEX BY BINARY_INTEGER;
25: TYPE tran_qtyTab IS TABLE OF mtl_onhand_quantities.transaction_quantity%TYPE INDEX BY BINARY_INTEGER;
26: TYPE lot_numTab IS TABLE OF mtl_onhand_quantities.lot_number%TYPE INDEX BY BINARY_INTEGER;
27: sub_code sub_codeTab;

Line 24: TYPE locatorTab IS TABLE OF mtl_onhand_quantities.locator_id%TYPE INDEX BY BINARY_INTEGER;

20: TYPE sub_codeTab IS TABLE OF mtl_onhand_quantities.subinventory_code%TYPE INDEX BY BINARY_INTEGER;
21: TYPE inv_idTab IS TABLE OF mtl_onhand_quantities.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
22: TYPE org_idTab IS TABLE OF mtl_onhand_quantities.organization_id%TYPE INDEX BY BINARY_INTEGER;
23: TYPE revisionTab IS TABLE OF mtl_onhand_quantities.revision%TYPE INDEX BY BINARY_INTEGER;
24: TYPE locatorTab IS TABLE OF mtl_onhand_quantities.locator_id%TYPE INDEX BY BINARY_INTEGER;
25: TYPE tran_qtyTab IS TABLE OF mtl_onhand_quantities.transaction_quantity%TYPE INDEX BY BINARY_INTEGER;
26: TYPE lot_numTab IS TABLE OF mtl_onhand_quantities.lot_number%TYPE INDEX BY BINARY_INTEGER;
27: sub_code sub_codeTab;
28: inv_id inv_idTab;

Line 25: TYPE tran_qtyTab IS TABLE OF mtl_onhand_quantities.transaction_quantity%TYPE INDEX BY BINARY_INTEGER;

21: TYPE inv_idTab IS TABLE OF mtl_onhand_quantities.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
22: TYPE org_idTab IS TABLE OF mtl_onhand_quantities.organization_id%TYPE INDEX BY BINARY_INTEGER;
23: TYPE revisionTab IS TABLE OF mtl_onhand_quantities.revision%TYPE INDEX BY BINARY_INTEGER;
24: TYPE locatorTab IS TABLE OF mtl_onhand_quantities.locator_id%TYPE INDEX BY BINARY_INTEGER;
25: TYPE tran_qtyTab IS TABLE OF mtl_onhand_quantities.transaction_quantity%TYPE INDEX BY BINARY_INTEGER;
26: TYPE lot_numTab IS TABLE OF mtl_onhand_quantities.lot_number%TYPE INDEX BY BINARY_INTEGER;
27: sub_code sub_codeTab;
28: inv_id inv_idTab;
29: org_id org_idTab;

Line 26: TYPE lot_numTab IS TABLE OF mtl_onhand_quantities.lot_number%TYPE INDEX BY BINARY_INTEGER;

22: TYPE org_idTab IS TABLE OF mtl_onhand_quantities.organization_id%TYPE INDEX BY BINARY_INTEGER;
23: TYPE revisionTab IS TABLE OF mtl_onhand_quantities.revision%TYPE INDEX BY BINARY_INTEGER;
24: TYPE locatorTab IS TABLE OF mtl_onhand_quantities.locator_id%TYPE INDEX BY BINARY_INTEGER;
25: TYPE tran_qtyTab IS TABLE OF mtl_onhand_quantities.transaction_quantity%TYPE INDEX BY BINARY_INTEGER;
26: TYPE lot_numTab IS TABLE OF mtl_onhand_quantities.lot_number%TYPE INDEX BY BINARY_INTEGER;
27: sub_code sub_codeTab;
28: inv_id inv_idTab;
29: org_id org_idTab;
30: rvision revisionTab;

Line 67: FROM mtl_onhand_quantities ohq

63: , ohq.locator_id
64: , ohq.lot_number
65: , SUM(ohq.transaction_quantity)
66: BULK COLLECT INTO sub_code, inv_id, org_id,rvision, loc_id,lot_num, qty
67: FROM mtl_onhand_quantities ohq
68: WHERE (ohq.subinventory_code, ohq.organization_id) IN
69: ( SELECT secinv.secondary_inventory_name
70: , secinv.organization_id
71: FROM jtm_csp_sec_inv_acc secacc

Line 123: FROM mtl_onhand_quantities ohq

119: SELECT ohq.subinventory_code, ohq.inventory_item_id
120: , ohq.organization_id, ohq.revision, ohq.locator_id
121: , ohq.lot_number, l_current_run_date
122: , SUM(ohq.transaction_quantity) tot_txn_quantity
123: FROM mtl_onhand_quantities ohq
124: WHERE (subinventory_code, organization_id) IN
125: ( SELECT csi.secondary_inventory_name
126: , csi.organization_id
127: FROM jtm_csp_sec_inv_acc secacc

Line 167: FROM mtl_onhand_quantities

163: , lot_number) NOT IN (
164: SELECT subinventory_code, inventory_item_id
165: , organization_id, revision, locator_id
166: , lot_number
167: FROM mtl_onhand_quantities
168: WHERE (subinventory_code, organization_id) IN (
169: SELECT csi.secondary_inventory_name
170: , csi.organization_id
171: FROM jtm_csp_sec_inv_acc secacc