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.CSM_SYSTEM_ITEM_EVENT_PKG dependencies on CSM_MTL_ONHAND_QTY_ACC

Line 626: SELECT csm_mtl_onhand_qty_acc_s.NEXTVAL

622: l_sqlerrno varchar2(20);
623: l_sqlerrmsg varchar2(2000);
624:
625: CURSOR l_onhand_acc_seq IS
626: SELECT csm_mtl_onhand_qty_acc_s.NEXTVAL
627: FROM dual;
628:
629: -- post deletes to onhand
630: CURSOR l_onhand_delete_csr IS

Line 631: SELECT /+ index(ohqacc CSM_MTL_ONHAND_QTY_ACC_U2) / ohqacc.user_id

627: FROM dual;
628:
629: -- post deletes to onhand
630: CURSOR l_onhand_delete_csr IS
631: SELECT /*+ index(ohqacc CSM_MTL_ONHAND_QTY_ACC_U2) */ ohqacc.user_id
632: , ohqacc.inventory_item_id
633: , ohqacc.organization_id
634: , ohqacc.ACCESS_ID
635: FROM csm_mtl_onhand_qty_acc ohqacc

Line 635: FROM csm_mtl_onhand_qty_acc ohqacc

631: SELECT /*+ index(ohqacc CSM_MTL_ONHAND_QTY_ACC_U2) */ ohqacc.user_id
632: , ohqacc.inventory_item_id
633: , ohqacc.organization_id
634: , ohqacc.ACCESS_ID
635: FROM csm_mtl_onhand_qty_acc ohqacc
636: WHERE NOT EXISTS
637: (
638: SELECT 1
639: FROM mtl_onhand_quantities_detail ohqmv

Line 660: SELECT /+ index(ohqacc CSM_MTL_ONHAND_QTY_ACC_U2) index(ohqmv MTL_ONHAND_QUANTITIES_N4)/ DISTINCT ohqacc.user_id

656: );
657:
658: -- get the updates to onhands for all mobile users
659: CURSOR l_onhand_update_csr IS
660: SELECT /*+ index(ohqacc CSM_MTL_ONHAND_QTY_ACC_U2) index(ohqmv MTL_ONHAND_QUANTITIES_N4)*/ DISTINCT ohqacc.user_id
661: , ohqmv.INVENTORY_ITEM_ID
662: , ohqmv.ORGANIZATION_ID
663: , ohqmv.SUBINVENTORY_CODE
664: , ohqmv.LOCATOR_ID

Line 669: FROM csm_mtl_onhand_qty_acc ohqacc,

665: , ohqmv.REVISION
666: , ohqmv.LOT_NUMBER
667: , ohqacc.quantity
668: , SUM(ohqmv.transaction_quantity) tot_qty
669: FROM csm_mtl_onhand_qty_acc ohqacc,
670: mtl_onhand_quantities_detail ohqmv
671: WHERE ohqacc.inventory_item_id = ohqmv.inventory_item_id
672: AND ohqacc.organization_id = ohqmv.organization_id
673: AND ohqacc.subinventory_code = ohqmv.subinventory_code

Line 729: (SELECT /index (ohqacc CSM_MTL_ONHAND_QTY_ACC_U2)/ 1

725: -- AND csi.organization_id = ila1.organization_id
726: -- AND csi.condition_type IN('G','B') --R12-4681995
727: )
728: AND NOT EXISTS
729: (SELECT /*index (ohqacc CSM_MTL_ONHAND_QTY_ACC_U2)*/ 1
730: FROM csm_mtl_onhand_qty_acc ohqacc
731: WHERE ohqacc.user_id = au.user_id
732: AND (ohqacc.inventory_item_id = ohqmv.inventory_item_id )
733: AND (ohqacc.organization_id = ohqmv.organization_id )

Line 730: FROM csm_mtl_onhand_qty_acc ohqacc

726: -- AND csi.condition_type IN('G','B') --R12-4681995
727: )
728: AND NOT EXISTS
729: (SELECT /*index (ohqacc CSM_MTL_ONHAND_QTY_ACC_U2)*/ 1
730: FROM csm_mtl_onhand_qty_acc ohqacc
731: WHERE ohqacc.user_id = au.user_id
732: AND (ohqacc.inventory_item_id = ohqmv.inventory_item_id )
733: AND (ohqacc.organization_id = ohqmv.organization_id )
734: AND (ohqacc.subinventory_code = ohqmv.subinventory_code )

Line 741: TYPE inv_idTab IS TABLE OF csm_mtl_onhand_qty_acc.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;

737: AND ((ohqacc.revision IS NULL AND ohqmv.revision IS NULL) OR (ohqacc.revision = ohqmv.revision))
738: );
739:
740:
741: TYPE inv_idTab IS TABLE OF csm_mtl_onhand_qty_acc.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
742: TYPE org_idTab IS TABLE OF csm_mtl_onhand_qty_acc.organization_id%TYPE INDEX BY BINARY_INTEGER;
743: TYPE sub_codeTab IS TABLE OF csm_mtl_onhand_qty_acc.subinventory_code%TYPE INDEX BY BINARY_INTEGER;
744: TYPE rvsionTab IS TABLE OF csm_mtl_onhand_qty_acc.revision%TYPE INDEX BY BINARY_INTEGER;
745: TYPE loc_idTab IS TABLE OF csm_mtl_onhand_qty_acc.locator_id%TYPE INDEX BY BINARY_INTEGER;

Line 742: TYPE org_idTab IS TABLE OF csm_mtl_onhand_qty_acc.organization_id%TYPE INDEX BY BINARY_INTEGER;

738: );
739:
740:
741: TYPE inv_idTab IS TABLE OF csm_mtl_onhand_qty_acc.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
742: TYPE org_idTab IS TABLE OF csm_mtl_onhand_qty_acc.organization_id%TYPE INDEX BY BINARY_INTEGER;
743: TYPE sub_codeTab IS TABLE OF csm_mtl_onhand_qty_acc.subinventory_code%TYPE INDEX BY BINARY_INTEGER;
744: TYPE rvsionTab IS TABLE OF csm_mtl_onhand_qty_acc.revision%TYPE INDEX BY BINARY_INTEGER;
745: TYPE loc_idTab IS TABLE OF csm_mtl_onhand_qty_acc.locator_id%TYPE INDEX BY BINARY_INTEGER;
746: TYPE lot_numTab IS TABLE OF csm_mtl_onhand_qty_acc.lot_number%TYPE INDEX BY BINARY_INTEGER;

Line 743: TYPE sub_codeTab IS TABLE OF csm_mtl_onhand_qty_acc.subinventory_code%TYPE INDEX BY BINARY_INTEGER;

739:
740:
741: TYPE inv_idTab IS TABLE OF csm_mtl_onhand_qty_acc.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
742: TYPE org_idTab IS TABLE OF csm_mtl_onhand_qty_acc.organization_id%TYPE INDEX BY BINARY_INTEGER;
743: TYPE sub_codeTab IS TABLE OF csm_mtl_onhand_qty_acc.subinventory_code%TYPE INDEX BY BINARY_INTEGER;
744: TYPE rvsionTab IS TABLE OF csm_mtl_onhand_qty_acc.revision%TYPE INDEX BY BINARY_INTEGER;
745: TYPE loc_idTab IS TABLE OF csm_mtl_onhand_qty_acc.locator_id%TYPE INDEX BY BINARY_INTEGER;
746: TYPE lot_numTab IS TABLE OF csm_mtl_onhand_qty_acc.lot_number%TYPE INDEX BY BINARY_INTEGER;
747: TYPE tran_qtyTab IS TABLE OF mtl_onhand_quantities_detail.transaction_quantity%TYPE INDEX BY BINARY_INTEGER;

Line 744: TYPE rvsionTab IS TABLE OF csm_mtl_onhand_qty_acc.revision%TYPE INDEX BY BINARY_INTEGER;

740:
741: TYPE inv_idTab IS TABLE OF csm_mtl_onhand_qty_acc.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
742: TYPE org_idTab IS TABLE OF csm_mtl_onhand_qty_acc.organization_id%TYPE INDEX BY BINARY_INTEGER;
743: TYPE sub_codeTab IS TABLE OF csm_mtl_onhand_qty_acc.subinventory_code%TYPE INDEX BY BINARY_INTEGER;
744: TYPE rvsionTab IS TABLE OF csm_mtl_onhand_qty_acc.revision%TYPE INDEX BY BINARY_INTEGER;
745: TYPE loc_idTab IS TABLE OF csm_mtl_onhand_qty_acc.locator_id%TYPE INDEX BY BINARY_INTEGER;
746: TYPE lot_numTab IS TABLE OF csm_mtl_onhand_qty_acc.lot_number%TYPE INDEX BY BINARY_INTEGER;
747: TYPE tran_qtyTab IS TABLE OF mtl_onhand_quantities_detail.transaction_quantity%TYPE INDEX BY BINARY_INTEGER;
748: TYPE user_idTab IS TABLE OF asg_user.user_id%TYPE INDEX BY BINARY_INTEGER;

Line 745: TYPE loc_idTab IS TABLE OF csm_mtl_onhand_qty_acc.locator_id%TYPE INDEX BY BINARY_INTEGER;

741: TYPE inv_idTab IS TABLE OF csm_mtl_onhand_qty_acc.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
742: TYPE org_idTab IS TABLE OF csm_mtl_onhand_qty_acc.organization_id%TYPE INDEX BY BINARY_INTEGER;
743: TYPE sub_codeTab IS TABLE OF csm_mtl_onhand_qty_acc.subinventory_code%TYPE INDEX BY BINARY_INTEGER;
744: TYPE rvsionTab IS TABLE OF csm_mtl_onhand_qty_acc.revision%TYPE INDEX BY BINARY_INTEGER;
745: TYPE loc_idTab IS TABLE OF csm_mtl_onhand_qty_acc.locator_id%TYPE INDEX BY BINARY_INTEGER;
746: TYPE lot_numTab IS TABLE OF csm_mtl_onhand_qty_acc.lot_number%TYPE INDEX BY BINARY_INTEGER;
747: TYPE tran_qtyTab IS TABLE OF mtl_onhand_quantities_detail.transaction_quantity%TYPE INDEX BY BINARY_INTEGER;
748: TYPE user_idTab IS TABLE OF asg_user.user_id%TYPE INDEX BY BINARY_INTEGER;
749: TYPE access_idTab IS TABLE OF csm_mtl_onhand_qty_acc.access_id%TYPE INDEX BY BINARY_INTEGER;

Line 746: TYPE lot_numTab IS TABLE OF csm_mtl_onhand_qty_acc.lot_number%TYPE INDEX BY BINARY_INTEGER;

742: TYPE org_idTab IS TABLE OF csm_mtl_onhand_qty_acc.organization_id%TYPE INDEX BY BINARY_INTEGER;
743: TYPE sub_codeTab IS TABLE OF csm_mtl_onhand_qty_acc.subinventory_code%TYPE INDEX BY BINARY_INTEGER;
744: TYPE rvsionTab IS TABLE OF csm_mtl_onhand_qty_acc.revision%TYPE INDEX BY BINARY_INTEGER;
745: TYPE loc_idTab IS TABLE OF csm_mtl_onhand_qty_acc.locator_id%TYPE INDEX BY BINARY_INTEGER;
746: TYPE lot_numTab IS TABLE OF csm_mtl_onhand_qty_acc.lot_number%TYPE INDEX BY BINARY_INTEGER;
747: TYPE tran_qtyTab IS TABLE OF mtl_onhand_quantities_detail.transaction_quantity%TYPE INDEX BY BINARY_INTEGER;
748: TYPE user_idTab IS TABLE OF asg_user.user_id%TYPE INDEX BY BINARY_INTEGER;
749: TYPE access_idTab IS TABLE OF csm_mtl_onhand_qty_acc.access_id%TYPE INDEX BY BINARY_INTEGER;
750:

Line 749: TYPE access_idTab IS TABLE OF csm_mtl_onhand_qty_acc.access_id%TYPE INDEX BY BINARY_INTEGER;

745: TYPE loc_idTab IS TABLE OF csm_mtl_onhand_qty_acc.locator_id%TYPE INDEX BY BINARY_INTEGER;
746: TYPE lot_numTab IS TABLE OF csm_mtl_onhand_qty_acc.lot_number%TYPE INDEX BY BINARY_INTEGER;
747: TYPE tran_qtyTab IS TABLE OF mtl_onhand_quantities_detail.transaction_quantity%TYPE INDEX BY BINARY_INTEGER;
748: TYPE user_idTab IS TABLE OF asg_user.user_id%TYPE INDEX BY BINARY_INTEGER;
749: TYPE access_idTab IS TABLE OF csm_mtl_onhand_qty_acc.access_id%TYPE INDEX BY BINARY_INTEGER;
750:
751: inv_id inv_idTab;
752: org_id org_idTab;
753: sub_code sub_codeTab;

Line 824: -- DELETE CSM_MTL_ONHAND_QTY_ACC WHERE ACCESS_ID = acc_id_lst(i);

820: , P_TIMESTAMP => l_current_run_date
821: );
822:
823: -- FORALL i IN acc_id_lst.FIRST..acc_id_lst.LAST
824: -- DELETE CSM_MTL_ONHAND_QTY_ACC WHERE ACCESS_ID = acc_id_lst(i);
825:
826: FOR i IN 1..acc_id_lst.COUNT LOOP
827: DELETE CSM_MTL_ONHAND_QTY_ACC WHERE ACCESS_ID = acc_id_lst(i);
828: CSM_ITEM_INSTANCE_EVENT_PKG.DELETE_IB_NOTIN_INV(inv_id(i),org_id(i),user_id_lst(i));

Line 827: DELETE CSM_MTL_ONHAND_QTY_ACC WHERE ACCESS_ID = acc_id_lst(i);

823: -- FORALL i IN acc_id_lst.FIRST..acc_id_lst.LAST
824: -- DELETE CSM_MTL_ONHAND_QTY_ACC WHERE ACCESS_ID = acc_id_lst(i);
825:
826: FOR i IN 1..acc_id_lst.COUNT LOOP
827: DELETE CSM_MTL_ONHAND_QTY_ACC WHERE ACCESS_ID = acc_id_lst(i);
828: CSM_ITEM_INSTANCE_EVENT_PKG.DELETE_IB_NOTIN_INV(inv_id(i),org_id(i),user_id_lst(i));
829: END LOOP;
830:
831: END IF; -- end of deletes

Line 880: UPDATE CSM_MTL_ONHAND_QTY_ACC

876: CSM_UTIL_PKG.LOG('Pushing ' || user_id_lst.COUNT || 'updated records',
877: 'CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY',FND_LOG.LEVEL_STATEMENT);
878:
879: FORALL i IN user_id_lst.FIRST..user_id_lst.LAST
880: UPDATE CSM_MTL_ONHAND_QTY_ACC
881: SET LAST_UPDATE_DATE = l_current_run_date,
882: QUANTITY = qty(i)
883: WHERE user_id = user_id_lst(i)
884: AND inventory_item_id = inv_id(i)

Line 950: SELECT csm_mtl_onhand_qty_acc_s.NEXTVAL INTO acc_id_lst(i) FROM dual;

946: CSM_UTIL_PKG.LOG('Pushing ' || inv_id.COUNT || 'inserted records',
947: 'CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY',FND_LOG.LEVEL_STATEMENT);
948:
949: FOR i IN inv_id.FIRST..inv_id.LAST LOOP
950: SELECT csm_mtl_onhand_qty_acc_s.NEXTVAL INTO acc_id_lst(i) FROM dual;
951: END LOOP;
952:
953: FORALL i IN inv_id.FIRST..inv_id.LAST
954: INSERT INTO CSM_MTL_ONHAND_QTY_ACC (ACCESS_ID, user_id, INVENTORY_ITEM_ID,ORGANIZATION_ID,

Line 954: INSERT INTO CSM_MTL_ONHAND_QTY_ACC (ACCESS_ID, user_id, INVENTORY_ITEM_ID,ORGANIZATION_ID,

950: SELECT csm_mtl_onhand_qty_acc_s.NEXTVAL INTO acc_id_lst(i) FROM dual;
951: END LOOP;
952:
953: FORALL i IN inv_id.FIRST..inv_id.LAST
954: INSERT INTO CSM_MTL_ONHAND_QTY_ACC (ACCESS_ID, user_id, INVENTORY_ITEM_ID,ORGANIZATION_ID,
955: SUBINVENTORY_CODE,LOCATOR_ID,REVISION,LOT_NUMBER, LAST_UPDATE_DATE,LAST_UPDATED_BY,
956: CREATION_DATE,CREATED_BY, LAST_UPDATE_LOGIN, QUANTITY, GEN_PK) VALUES (acc_id_lst(i), user_id_lst(i), inv_id(i), org_id(i), sub_code(i),
957: loc_id(i), rvsion(i), lot_num(i), l_current_run_date,1,l_current_run_date,1, 1, qty(i), acc_id_lst(i));
958: