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_SEC_LOCATORS_EVENT_PKG dependencies on MTL_SECONDARY_LOCATORS

Line 14: g_table_name1 CONSTANT VARCHAR2(30) := 'CSM_MTL_SECONDARY_LOCATORS';

10: -- Person Date Comments
11: -- --------- ------ ------------------------------------------
12: -- Enter procedure, function bodies as shown below
13:
14: g_table_name1 CONSTANT VARCHAR2(30) := 'CSM_MTL_SECONDARY_LOCATORS';
15: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_MTL_SECONDARY_LOCATORS_ACC';
16: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_MTL_SEC_LOCATORS_ACC_S';
17: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
18: CSM_ACC_PKG.t_publication_item_list('CSM_MTL_SECONDARY_LOCATORS');

Line 15: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_MTL_SECONDARY_LOCATORS_ACC';

11: -- --------- ------ ------------------------------------------
12: -- Enter procedure, function bodies as shown below
13:
14: g_table_name1 CONSTANT VARCHAR2(30) := 'CSM_MTL_SECONDARY_LOCATORS';
15: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_MTL_SECONDARY_LOCATORS_ACC';
16: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_MTL_SEC_LOCATORS_ACC_S';
17: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
18: CSM_ACC_PKG.t_publication_item_list('CSM_MTL_SECONDARY_LOCATORS');
19: g_pk1_name1 CONSTANT VARCHAR2(30) := 'INVENTORY_ITEM_ID';

Line 18: CSM_ACC_PKG.t_publication_item_list('CSM_MTL_SECONDARY_LOCATORS');

14: g_table_name1 CONSTANT VARCHAR2(30) := 'CSM_MTL_SECONDARY_LOCATORS';
15: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_MTL_SECONDARY_LOCATORS_ACC';
16: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_MTL_SEC_LOCATORS_ACC_S';
17: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
18: CSM_ACC_PKG.t_publication_item_list('CSM_MTL_SECONDARY_LOCATORS');
19: g_pk1_name1 CONSTANT VARCHAR2(30) := 'INVENTORY_ITEM_ID';
20: g_pk2_name1 CONSTANT VARCHAR2(30) := 'SECONDARY_LOCATOR';
21: g_pk3_name1 CONSTANT VARCHAR2(30) := 'ORGANIZATION_ID';
22: g_pub_item CONSTANT VARCHAR2(30) := 'CSM_MTL_SECONDARY_LOCATORS';

Line 22: g_pub_item CONSTANT VARCHAR2(30) := 'CSM_MTL_SECONDARY_LOCATORS';

18: CSM_ACC_PKG.t_publication_item_list('CSM_MTL_SECONDARY_LOCATORS');
19: g_pk1_name1 CONSTANT VARCHAR2(30) := 'INVENTORY_ITEM_ID';
20: g_pk2_name1 CONSTANT VARCHAR2(30) := 'SECONDARY_LOCATOR';
21: g_pk3_name1 CONSTANT VARCHAR2(30) := 'ORGANIZATION_ID';
22: g_pub_item CONSTANT VARCHAR2(30) := 'CSM_MTL_SECONDARY_LOCATORS';
23:
24: PROCEDURE Refresh_Acc (p_status OUT NOCOPY VARCHAR2,
25: p_message OUT NOCOPY VARCHAR2)
26: IS

Line 31: l_pub_item VARCHAR2(30) := 'CSM_MTL_SECONDARY_LOCATORS';

27: PRAGMA AUTONOMOUS_TRANSACTION;
28: l_updates_cur CSM_UTIL_PKG.Changed_Records_Cur_Type;
29: l_inserts_cur CSM_UTIL_PKG.Changed_Records_Cur_Type;
30: l_dsql varchar2(2048);
31: l_pub_item VARCHAR2(30) := 'CSM_MTL_SECONDARY_LOCATORS';
32: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
33: l_access_id jtm_fnd_lookups_acc.access_id%TYPE;
34: l_mark_dirty boolean;
35: l_all_omfs_palm_resource_list asg_download.user_list;

Line 58: mtl_secondary_locators msl

54: SELECT msi_acc.user_id, msl.inventory_item_id,
55: msl.organization_id, msl.secondary_locator
56: FROM csm_mtl_system_items_acc msi_acc,
57: csm_mtl_item_locations_acc mil_acc,
58: mtl_secondary_locators msl
59: WHERE msl.inventory_item_id = msi_acc.inventory_item_id
60: AND msl.organization_id = msi_acc.organization_id
61: AND msl.secondary_locator = mil_acc.inventory_location_id
62: AND msl.organization_id = mil_acc.organization_id

Line 66: FROM csm_mtl_secondary_locators_acc acc

62: AND msl.organization_id = mil_acc.organization_id
63: AND msi_acc.user_id = mil_acc.user_id
64: AND NOT EXISTS
65: (SELECT 1
66: FROM csm_mtl_secondary_locators_acc acc
67: WHERE acc.user_id = msi_acc.user_id
68: AND acc.inventory_item_id = msi_acc.inventory_item_id
69: AND acc.organization_id = msi_acc.organization_id
70: AND acc.secondary_locator = msl.secondary_locator

Line 77: mtl_secondary_locators msl,

73: SELECT mil_acc.user_id, msl.inventory_item_id,
74: msl.organization_id, msl.secondary_locator
75: FROM csm_mtl_system_items_acc msi_acc,
76: csm_mtl_item_locations_acc mil_acc,
77: mtl_secondary_locators msl,
78: csm_user_inventory_org uorg
79: WHERE msl.inventory_item_id = msi_acc.inventory_item_id
80: AND msl.organization_id = msi_acc.organization_id
81: AND msl.secondary_locator = mil_acc.inventory_location_id

Line 87: FROM csm_mtl_secondary_locators_acc acc

83: AND msi_acc.user_id = -1
84: AND mil_acc.user_id = uorg.user_id
85: AND msi_acc.organization_id=uorg.organization_id
86: AND NOT EXISTS(SELECT 1
87: FROM csm_mtl_secondary_locators_acc acc
88: WHERE acc.user_id = mil_acc.user_id
89: AND acc.inventory_item_id = msl.inventory_item_id
90: AND acc.organization_id = msl.organization_id
91: AND acc.secondary_locator = msl.secondary_locator

Line 99: FROM csm_mtl_secondary_locators_acc acc,

95: CURSOR l_mtl_sec_loc_upd_csr(p_last_upd_date DATE)
96: IS
97: SELECT acc.access_id, acc.secondary_locator, acc.organization_id,
98: acc.inventory_item_id, acc.user_id
99: FROM csm_mtl_secondary_locators_acc acc,
100: mtl_secondary_locators msl
101: WHERE msl.secondary_locator = acc.secondary_locator
102: AND msl.organization_id = acc.organization_id
103: AND msl.inventory_item_id = acc.inventory_item_id

Line 100: mtl_secondary_locators msl

96: IS
97: SELECT acc.access_id, acc.secondary_locator, acc.organization_id,
98: acc.inventory_item_id, acc.user_id
99: FROM csm_mtl_secondary_locators_acc acc,
100: mtl_secondary_locators msl
101: WHERE msl.secondary_locator = acc.secondary_locator
102: AND msl.organization_id = acc.organization_id
103: AND msl.inventory_item_id = acc.inventory_item_id
104: AND msl.last_update_date >= p_last_upd_date;

Line 110: FROM csm_mtl_secondary_locators_acc acc

106: -- process deletes
107: CURSOR l_mtl_sec_loc_del_csr
108: IS
109: SELECT acc.user_id, acc.secondary_locator, acc.organization_id, acc.inventory_item_id
110: FROM csm_mtl_secondary_locators_acc acc
111: WHERE NOT EXISTS
112: ((SELECT 1
113: FROM csm_mtl_system_items_acc msi_acc,
114: csm_mtl_item_locations_acc mil_acc,

Line 115: mtl_secondary_locators msl

111: WHERE NOT EXISTS
112: ((SELECT 1
113: FROM csm_mtl_system_items_acc msi_acc,
114: csm_mtl_item_locations_acc mil_acc,
115: mtl_secondary_locators msl
116: WHERE msl.inventory_item_id = msi_acc.inventory_item_id
117: AND msl.organization_id = msi_acc.organization_id
118: AND msl.secondary_locator = mil_acc.inventory_location_id
119: AND msl.organization_id = mil_acc.organization_id

Line 130: mtl_secondary_locators msl,

126: UNION ALL
127: (SELECT 1
128: FROM csm_mtl_system_items_acc msi_acc,
129: csm_mtl_item_locations_acc mil_acc,
130: mtl_secondary_locators msl,
131: csm_user_inventory_org uorg
132: WHERE msl.inventory_item_id = msi_acc.inventory_item_id
133: AND msl.organization_id = msi_acc.organization_id
134: AND msl.secondary_locator = mil_acc.inventory_location_id