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_INV_LOC_ASS_EVENT_PKG dependencies on MTL_ITEM_LOCATIONS

Line 33: g_pub_item3 CONSTANT VARCHAR2(30) := 'CSM_MTL_ITEM_LOCATIONS';

29: CSM_ACC_PKG.t_publication_item_list('CSM_MTL_SEC_INVENTORIES');
30: g_pk1_name2 CONSTANT VARCHAR2(30) := 'SECONDARY_INVENTORY_NAME';
31: g_pk2_name2 CONSTANT VARCHAR2(30) := 'ORGANIZATION_ID';
32:
33: g_pub_item3 CONSTANT VARCHAR2(30) := 'CSM_MTL_ITEM_LOCATIONS';
34: g_table_name3 CONSTANT VARCHAR2(30) := 'MTL_ITEM_LOCATIONS';
35: g_acc_table_name3 CONSTANT VARCHAR2(30) := 'CSM_MTL_ITEM_LOCATIONS_ACC';
36: g_acc_sequence_name3 CONSTANT VARCHAR2(30) := 'CSM_MTL_ITEM_LOCATIONS_ACC_S';
37: g_publication_item_name3 CONSTANT CSM_ACC_PKG.t_publication_item_list :=

Line 34: g_table_name3 CONSTANT VARCHAR2(30) := 'MTL_ITEM_LOCATIONS';

30: g_pk1_name2 CONSTANT VARCHAR2(30) := 'SECONDARY_INVENTORY_NAME';
31: g_pk2_name2 CONSTANT VARCHAR2(30) := 'ORGANIZATION_ID';
32:
33: g_pub_item3 CONSTANT VARCHAR2(30) := 'CSM_MTL_ITEM_LOCATIONS';
34: g_table_name3 CONSTANT VARCHAR2(30) := 'MTL_ITEM_LOCATIONS';
35: g_acc_table_name3 CONSTANT VARCHAR2(30) := 'CSM_MTL_ITEM_LOCATIONS_ACC';
36: g_acc_sequence_name3 CONSTANT VARCHAR2(30) := 'CSM_MTL_ITEM_LOCATIONS_ACC_S';
37: g_publication_item_name3 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
38: CSM_ACC_PKG.t_publication_item_list('CSM_MTL_ITEM_LOCATIONS');

Line 35: g_acc_table_name3 CONSTANT VARCHAR2(30) := 'CSM_MTL_ITEM_LOCATIONS_ACC';

31: g_pk2_name2 CONSTANT VARCHAR2(30) := 'ORGANIZATION_ID';
32:
33: g_pub_item3 CONSTANT VARCHAR2(30) := 'CSM_MTL_ITEM_LOCATIONS';
34: g_table_name3 CONSTANT VARCHAR2(30) := 'MTL_ITEM_LOCATIONS';
35: g_acc_table_name3 CONSTANT VARCHAR2(30) := 'CSM_MTL_ITEM_LOCATIONS_ACC';
36: g_acc_sequence_name3 CONSTANT VARCHAR2(30) := 'CSM_MTL_ITEM_LOCATIONS_ACC_S';
37: g_publication_item_name3 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
38: CSM_ACC_PKG.t_publication_item_list('CSM_MTL_ITEM_LOCATIONS');
39: g_pk1_name3 CONSTANT VARCHAR2(30) := 'INVENTORY_LOCATION_ID';

Line 36: g_acc_sequence_name3 CONSTANT VARCHAR2(30) := 'CSM_MTL_ITEM_LOCATIONS_ACC_S';

32:
33: g_pub_item3 CONSTANT VARCHAR2(30) := 'CSM_MTL_ITEM_LOCATIONS';
34: g_table_name3 CONSTANT VARCHAR2(30) := 'MTL_ITEM_LOCATIONS';
35: g_acc_table_name3 CONSTANT VARCHAR2(30) := 'CSM_MTL_ITEM_LOCATIONS_ACC';
36: g_acc_sequence_name3 CONSTANT VARCHAR2(30) := 'CSM_MTL_ITEM_LOCATIONS_ACC_S';
37: g_publication_item_name3 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
38: CSM_ACC_PKG.t_publication_item_list('CSM_MTL_ITEM_LOCATIONS');
39: g_pk1_name3 CONSTANT VARCHAR2(30) := 'INVENTORY_LOCATION_ID';
40: g_pk2_name3 CONSTANT VARCHAR2(30) := 'ORGANIZATION_ID';

Line 38: CSM_ACC_PKG.t_publication_item_list('CSM_MTL_ITEM_LOCATIONS');

34: g_table_name3 CONSTANT VARCHAR2(30) := 'MTL_ITEM_LOCATIONS';
35: g_acc_table_name3 CONSTANT VARCHAR2(30) := 'CSM_MTL_ITEM_LOCATIONS_ACC';
36: g_acc_sequence_name3 CONSTANT VARCHAR2(30) := 'CSM_MTL_ITEM_LOCATIONS_ACC_S';
37: g_publication_item_name3 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
38: CSM_ACC_PKG.t_publication_item_list('CSM_MTL_ITEM_LOCATIONS');
39: g_pk1_name3 CONSTANT VARCHAR2(30) := 'INVENTORY_LOCATION_ID';
40: g_pk2_name3 CONSTANT VARCHAR2(30) := 'ORGANIZATION_ID';
41:
42: PROCEDURE INV_LOC_ASSIGNMENT_INS_INIT (p_csp_inv_loc_assignment_id IN NUMBER)

Line 98: l_inv_location_id mtl_item_locations.inventory_location_id%TYPE;

94: l_error_msg VARCHAR2(4000);
95: l_return_status VARCHAR2(2000);
96: l_subinventory_code csp_inv_loc_assignments.subinventory_code%TYPE;
97: l_organization_id csp_inv_loc_assignments.organization_id%TYPE;
98: l_inv_location_id mtl_item_locations.inventory_location_id%TYPE;
99: l_locator_org_id mtl_item_locations.organization_id%TYPE;
100:
101: -- get subinventory/organization to insert into csm_mtl_sec_inv
102: CURSOR l_inv_loc_ass_csr(p_inv_loc_ass_id IN NUMBER)

Line 99: l_locator_org_id mtl_item_locations.organization_id%TYPE;

95: l_return_status VARCHAR2(2000);
96: l_subinventory_code csp_inv_loc_assignments.subinventory_code%TYPE;
97: l_organization_id csp_inv_loc_assignments.organization_id%TYPE;
98: l_inv_location_id mtl_item_locations.inventory_location_id%TYPE;
99: l_locator_org_id mtl_item_locations.organization_id%TYPE;
100:
101: -- get subinventory/organization to insert into csm_mtl_sec_inv
102: CURSOR l_inv_loc_ass_csr(p_inv_loc_ass_id IN NUMBER)
103: IS

Line 109: -- get inventory_location_id/organization_id to insert into csm_mtl_item_locations

105: organization_id
106: FROM csp_inv_loc_assignments
107: WHERE csp_inv_loc_assignment_id = p_inv_loc_ass_id;
108:
109: -- get inventory_location_id/organization_id to insert into csm_mtl_item_locations
110: CURSOR l_inv_location_csr(p_subinv_code IN VARCHAR2, p_organization_id IN NUMBER)
111: IS
112: SELECT mil.inventory_location_id, mil.organization_id
113: FROM mtl_item_locations mil

Line 113: FROM mtl_item_locations mil

109: -- get inventory_location_id/organization_id to insert into csm_mtl_item_locations
110: CURSOR l_inv_location_csr(p_subinv_code IN VARCHAR2, p_organization_id IN NUMBER)
111: IS
112: SELECT mil.inventory_location_id, mil.organization_id
113: FROM mtl_item_locations mil
114: WHERE mil.subinventory_code = p_subinv_code
115: AND mil.organization_id = p_organization_id;
116:
117: BEGIN

Line 153: -- insert into csm_mtl_item_locations_acc

149: FETCH l_inv_location_csr INTO l_inv_location_id, l_locator_org_id;
150: IF l_inv_location_csr%NOTFOUND THEN
151: EXIT;
152: END IF;
153: -- insert into csm_mtl_item_locations_acc
154: CSM_ACC_PKG.Insert_Acc
155: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name3
156: ,P_ACC_TABLE_NAME => g_acc_table_name3
157: ,P_SEQ_NAME => g_acc_sequence_name3

Line 237: l_inv_location_id mtl_item_locations.inventory_location_id%TYPE;

233: l_error_msg VARCHAR2(4000);
234: l_return_status VARCHAR2(2000);
235: l_subinventory_code csp_inv_loc_assignments.subinventory_code%TYPE;
236: l_organization_id csp_inv_loc_assignments.organization_id%TYPE;
237: l_inv_location_id mtl_item_locations.inventory_location_id%TYPE;
238: l_locator_org_id mtl_item_locations.organization_id%TYPE;
239:
240: -- get subinventory/organization to delete from csm_mtl_sec_inv
241: CURSOR l_inv_loc_ass_csr(p_inv_loc_ass_id IN NUMBER)

Line 238: l_locator_org_id mtl_item_locations.organization_id%TYPE;

234: l_return_status VARCHAR2(2000);
235: l_subinventory_code csp_inv_loc_assignments.subinventory_code%TYPE;
236: l_organization_id csp_inv_loc_assignments.organization_id%TYPE;
237: l_inv_location_id mtl_item_locations.inventory_location_id%TYPE;
238: l_locator_org_id mtl_item_locations.organization_id%TYPE;
239:
240: -- get subinventory/organization to delete from csm_mtl_sec_inv
241: CURSOR l_inv_loc_ass_csr(p_inv_loc_ass_id IN NUMBER)
242: IS

Line 248: -- get inventory_location_id/organization_id to delete from csm_mtl_item_locations

244: organization_id
245: FROM csp_inv_loc_assignments
246: WHERE csp_inv_loc_assignment_id = p_inv_loc_ass_id;
247:
248: -- get inventory_location_id/organization_id to delete from csm_mtl_item_locations
249: CURSOR l_inv_location_csr(p_subinv_code IN VARCHAR2, p_organization_id IN NUMBER)
250: IS
251: SELECT mil.inventory_location_id, mil.organization_id
252: FROM mtl_item_locations mil

Line 252: FROM mtl_item_locations mil

248: -- get inventory_location_id/organization_id to delete from csm_mtl_item_locations
249: CURSOR l_inv_location_csr(p_subinv_code IN VARCHAR2, p_organization_id IN NUMBER)
250: IS
251: SELECT mil.inventory_location_id, mil.organization_id
252: FROM mtl_item_locations mil
253: WHERE mil.subinventory_code = p_subinv_code
254: AND mil.organization_id = p_organization_id;
255:
256: BEGIN

Line 293: -- delete from csm_mtl_item_locations_acc

289: IF l_inv_location_csr%NOTFOUND THEN
290: EXIT;
291: END IF;
292:
293: -- delete from csm_mtl_item_locations_acc
294: CSM_ACC_PKG.Delete_Acc
295: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name3
296: ,P_ACC_TABLE_NAME => g_acc_table_name3
297: ,P_PK1_NAME => g_pk1_name3