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_MTL_SYSTEM_ITEMS_EVENT_PKG dependencies on MTL_SYSTEM_ITEMS_B

Line 43: TYPE inventory_item_id_tbl_typ IS TABLE OF mtl_system_items_b.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;

39: l_stmt1 VARCHAR2(4000);
40: l_markdirty BOOLEAN;
41:
42:
43: TYPE inventory_item_id_tbl_typ IS TABLE OF mtl_system_items_b.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
44: TYPE organization_id_tbl_typ IS TABLE OF mtl_system_items_b.organization_id%TYPE INDEX BY BINARY_INTEGER;
45:
46: l_inventory_item_id_tbl inventory_item_id_tbl_typ;
47: l_organization_id_tbl organization_id_tbl_typ;

Line 44: TYPE organization_id_tbl_typ IS TABLE OF mtl_system_items_b.organization_id%TYPE INDEX BY BINARY_INTEGER;

40: l_markdirty BOOLEAN;
41:
42:
43: TYPE inventory_item_id_tbl_typ IS TABLE OF mtl_system_items_b.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
44: TYPE organization_id_tbl_typ IS TABLE OF mtl_system_items_b.organization_id%TYPE INDEX BY BINARY_INTEGER;
45:
46: l_inventory_item_id_tbl inventory_item_id_tbl_typ;
47: l_organization_id_tbl organization_id_tbl_typ;
48: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;

Line 56: FROM MTL_SYSTEM_ITEMS_B msi

52: CURSOR c_items (b_user_id NUMBER, b_organization_id NUMBER,
53: b_changed VARCHAR2, b_last_run_date DATE)
54: IS
55: SELECT csm_mtl_system_items_acc_s.NEXTVAL, inventory_item_id, organization_id, b_user_id
56: FROM MTL_SYSTEM_ITEMS_B msi
57: WHERE msi.organization_id = b_organization_id
58: AND NOT EXISTS
59: ( SELECT 1
60: FROM csm_mtl_system_items_acc acc

Line 141: FROM MTL_SYSTEM_ITEMS_B msi

137: ---items to download for insert
138: CURSOR c_all_items_for_org (b_organization_id NUMBER)
139: IS
140: SELECT csm_mtl_system_items_acc_s.NEXTVAL,inventory_item_id, organization_id
141: FROM MTL_SYSTEM_ITEMS_B msi
142: WHERE msi.organization_id = b_organization_id;
143:
144:
145: --csm_mtl_system_items_acc_s.NEXTVAL,

Line 193: FROM MTL_SYSTEM_ITEMS_B b

189: INSERT INTO csm_mtl_system_items_acc(access_id, user_id, inventory_item_id, organization_id, counter,
190: created_by, creation_date, last_updated_by, last_update_date, last_update_login)
191: SELECT csm_mtl_system_items_acc_s.NEXTVAL,l_number, b.inventory_item_id, b.organization_id, 1,
192: fnd_global.user_id, l_run_date, fnd_global.user_id, l_run_date, fnd_global.login_id
193: FROM MTL_SYSTEM_ITEMS_B b
194: WHERE b.ORGANIZATION_ID = p_organization_id
195: AND b.enabled_flag = 'Y'
196: AND SYSDATE BETWEEN nvl(b.start_date_active, SYSDATE)
197: AND nvl(b.end_date_active, SYSDATE);

Line 547: FROM csm_mtl_system_items_acc acc, mtl_system_items_b msi,asg_user au

543:
544: CURSOR c_changed( b_last_date DATE)
545: IS
546: SELECT acc.access_id, acc.user_id
547: FROM csm_mtl_system_items_acc acc, mtl_system_items_b msi,asg_user au
548: WHERE msi.inventory_item_id = acc.inventory_item_id
549: AND msi.organization_id = acc.organization_id
550: AND acc.USER_ID > 0
551: AND au.user_id=acc.user_id

Line 565: AND EXISTS ( SELECT 1 FROM mtl_system_items_b msi

561: WHERE acc.organization_id = uorg.organization_id
562: AND uorg.category_set_id IS NULL
563: AND uorg.category_id IS NULL
564: AND acc.USER_ID = -1
565: AND EXISTS ( SELECT 1 FROM mtl_system_items_b msi
566: WHERE msi.inventory_item_id = acc.inventory_item_id
567: AND msi.organization_id = acc.organization_id
568: AND (msi.last_update_date >= b_last_date))
569: UNION

Line 605: AND EXISTS ( SELECT 1 FROM mtl_system_items_b msi

601: WHERE acc.organization_id = uorg.organization_id
602: AND uorg.category_set_id IS NULL
603: AND uorg.category_id IS NULL
604: AND acc.USER_ID = -1
605: AND EXISTS ( SELECT 1 FROM mtl_system_items_b msi
606: WHERE msi.inventory_item_id = acc.inventory_item_id
607: AND msi.organization_id = acc.organization_id
608: AND (msi.enabled_flag = 'N' OR msi.end_date_active < b_last_date));
609:

Line 616: /* This portion of code assumes indexes on last_update_date on MTL_SYSTEM_ITEMS_B */

612: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.UPDATE_MTL_SYSTEM_ITEMS',FND_LOG.LEVEL_PROCEDURE);
613:
614: l_run_date := SYSDATE;
615:
616: /* This portion of code assumes indexes on last_update_date on MTL_SYSTEM_ITEMS_B */
617: /* , MTL_SYSTEM_ITEMS_TL which were custom created */
618: SELECT MAX(last_update_date) INTO l_max_last_update_date_b
619: FROM mtl_system_items_b;
620: IF( l_max_last_update_date_b < p_last_run_date) THEN

Line 619: FROM mtl_system_items_b;

615:
616: /* This portion of code assumes indexes on last_update_date on MTL_SYSTEM_ITEMS_B */
617: /* , MTL_SYSTEM_ITEMS_TL which were custom created */
618: SELECT MAX(last_update_date) INTO l_max_last_update_date_b
619: FROM mtl_system_items_b;
620: IF( l_max_last_update_date_b < p_last_run_date) THEN
621: SELECT MAX(last_update_date) INTO l_max_last_update_date_tl
622: FROM mtl_system_items_tl;
623: IF(l_max_last_update_date_tl < p_last_run_date) THEN

Line 667: AND EXISTS ( SELECT 1 FROM mtl_system_items_b msi

663: l_transaction_flag := 'N';
664: --DELETE the items from the acc table
665: DELETE FROM csm_mtl_system_items_acc acc
666: WHERE USER_ID = -1
667: AND EXISTS ( SELECT 1 FROM mtl_system_items_b msi
668: WHERE msi.inventory_item_id = acc.inventory_item_id
669: AND msi.organization_id = acc.organization_id
670: AND msi.enabled_flag = 'N' OR msi.end_date_active < l_run_date);
671: COMMIT;

Line 706: FROM MTL_SYSTEM_ITEMS_B msi

702: INSERT INTO csm_mtl_system_items_acc(access_id, user_id, inventory_item_id, organization_id, counter,
703: created_by, creation_date, last_updated_by, last_update_date, last_update_login)
704: SELECT csm_mtl_system_items_acc_s.NEXTVAL, -2, msi.inventory_item_id, msi.organization_id, 1,
705: fnd_global.user_id, l_run_date, fnd_global.user_id, l_run_date, fnd_global.login_id
706: FROM MTL_SYSTEM_ITEMS_B msi
707: WHERE msi.enabled_flag = 'Y'
708: AND SYSDATE BETWEEN nvl(msi.start_date_active, SYSDATE) AND nvl(msi.end_date_active, SYSDATE)
709: AND msi.ORGANIZATION_ID
710: IN(SELECT DISTINCT uorg.ORGANIZATION_ID

Line 1112: TYPE inventory_item_id_tbl_typ IS TABLE OF mtl_system_items_b.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;

1108: and acc.organization_id=d.org_id
1109: and acc.user_id=d.user_id);
1110:
1111:
1112: TYPE inventory_item_id_tbl_typ IS TABLE OF mtl_system_items_b.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
1113: TYPE organization_id_tbl_typ IS TABLE OF mtl_system_items_b.organization_id%TYPE INDEX BY BINARY_INTEGER;
1114: l_inventory_item_id_tbl inventory_item_id_tbl_typ;
1115: l_organization_id_tbl organization_id_tbl_typ;
1116: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;

Line 1113: TYPE organization_id_tbl_typ IS TABLE OF mtl_system_items_b.organization_id%TYPE INDEX BY BINARY_INTEGER;

1109: and acc.user_id=d.user_id);
1110:
1111:
1112: TYPE inventory_item_id_tbl_typ IS TABLE OF mtl_system_items_b.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
1113: TYPE organization_id_tbl_typ IS TABLE OF mtl_system_items_b.organization_id%TYPE INDEX BY BINARY_INTEGER;
1114: l_inventory_item_id_tbl inventory_item_id_tbl_typ;
1115: l_organization_id_tbl organization_id_tbl_typ;
1116: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
1117: l_tab_user_id ASG_DOWNLOAD.USER_LIST;

Line 1215: FROM csm_mtl_system_items_acc acc, mtl_system_items_b msi

1211: AND user_id =au.user_id);
1212:
1213: CURSOR c_get_upd_items IS
1214: SELECT acc.access_id, acc.user_id
1215: FROM csm_mtl_system_items_acc acc, mtl_system_items_b msi
1216: WHERE msi.inventory_item_id = acc.inventory_item_id
1217: AND msi.organization_id = acc.organization_id
1218: AND EXISTS(SELECT 1 FROM ASG_USER au WHERE AU.USER_ID=acc.USER_ID and NVL(MULTI_PLATFORM,'N')='Y')
1219: AND acc.CREATION_DATE <=p_run_date

Line 1222: TYPE inventory_item_id_tbl_typ IS TABLE OF mtl_system_items_b.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;

1218: AND EXISTS(SELECT 1 FROM ASG_USER au WHERE AU.USER_ID=acc.USER_ID and NVL(MULTI_PLATFORM,'N')='Y')
1219: AND acc.CREATION_DATE <=p_run_date
1220: AND msi.last_update_date > p_run_date;
1221:
1222: TYPE inventory_item_id_tbl_typ IS TABLE OF mtl_system_items_b.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
1223: TYPE organization_id_tbl_typ IS TABLE OF mtl_system_items_b.organization_id%TYPE INDEX BY BINARY_INTEGER;
1224: l_inventory_item_id_tbl inventory_item_id_tbl_typ;
1225: l_organization_id_tbl organization_id_tbl_typ;
1226: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;

Line 1223: TYPE organization_id_tbl_typ IS TABLE OF mtl_system_items_b.organization_id%TYPE INDEX BY BINARY_INTEGER;

1219: AND acc.CREATION_DATE <=p_run_date
1220: AND msi.last_update_date > p_run_date;
1221:
1222: TYPE inventory_item_id_tbl_typ IS TABLE OF mtl_system_items_b.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
1223: TYPE organization_id_tbl_typ IS TABLE OF mtl_system_items_b.organization_id%TYPE INDEX BY BINARY_INTEGER;
1224: l_inventory_item_id_tbl inventory_item_id_tbl_typ;
1225: l_organization_id_tbl organization_id_tbl_typ;
1226: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
1227: l_tab_user_id ASG_DOWNLOAD.USER_LIST;