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 78: FROM csm_mtl_secondary_locators_acc acc,

74: CURSOR l_mtl_sec_loc_upd_csr(p_last_upd_date DATE)
75: IS
76: SELECT acc.access_id, acc.secondary_locator, acc.organization_id,
77: acc.inventory_item_id, acc.user_id
78: FROM csm_mtl_secondary_locators_acc acc,
79: mtl_secondary_locators msl
80: WHERE msl.secondary_locator = acc.secondary_locator
81: AND msl.organization_id = acc.organization_id
82: AND msl.inventory_item_id = acc.inventory_item_id

Line 79: mtl_secondary_locators msl

75: IS
76: SELECT acc.access_id, acc.secondary_locator, acc.organization_id,
77: acc.inventory_item_id, acc.user_id
78: FROM csm_mtl_secondary_locators_acc acc,
79: mtl_secondary_locators msl
80: WHERE msl.secondary_locator = acc.secondary_locator
81: AND msl.organization_id = acc.organization_id
82: AND msl.inventory_item_id = acc.inventory_item_id
83: AND msl.last_update_date >= p_last_upd_date;

Line 89: FROM csm_mtl_secondary_locators_acc acc

85: -- process deletes
86: CURSOR l_mtl_sec_loc_del_csr
87: IS
88: SELECT acc.user_id, acc.secondary_locator, acc.organization_id, acc.inventory_item_id
89: FROM csm_mtl_secondary_locators_acc acc
90: WHERE NOT EXISTS
91: (SELECT 1
92: FROM csm_mtl_system_items_acc msi_acc,
93: csm_mtl_item_locations_acc mil_acc,

Line 94: mtl_secondary_locators msl

90: WHERE NOT EXISTS
91: (SELECT 1
92: FROM csm_mtl_system_items_acc msi_acc,
93: csm_mtl_item_locations_acc mil_acc,
94: mtl_secondary_locators msl
95: WHERE msl.inventory_item_id = msi_acc.inventory_item_id
96: AND msl.organization_id = msi_acc.organization_id
97: AND msl.secondary_locator = mil_acc.inventory_location_id
98: AND msl.organization_id = mil_acc.organization_id