APPS.INVPULI3 dependencies on MTL_PARAMETERS

Line 75: FROM mtl_system_items_interface msii, mtl_parameters mp

71:
72: /* Resolving Copy Item Numbers if any to Item Ids */
73: BEGIN
74: SELECT DISTINCT msii.copy_item_number BULK COLLECT INTO base_item_num_table
75: FROM mtl_system_items_interface msii, mtl_parameters mp
76: WHERE msii.process_flag = 1
77: AND msii.set_process_id = xset_id
78: AND msii.transaction_type = 'CREATE'
79: AND ((msii.organization_id = org_id) or (all_org = 1))

Line 106: FROM mtl_system_items_interface msii, mtl_parameters mp

102:
103: /* Resolving Copy Org Codes if any to Org Ids */
104: BEGIN
105: SELECT DISTINCT msii.copy_organization_code BULK COLLECT INTO base_org_code_table
106: FROM mtl_system_items_interface msii, mtl_parameters mp
107: WHERE msii.process_flag = 1
108: AND msii.set_process_id = xset_id
109: AND msii.transaction_type = 'CREATE'
110: AND ((msii.organization_id = org_id) or (all_org = 1))

Line 124: FROM mtl_parameters mp

120: FOR I IN base_org_code_table.FIRST .. base_org_code_table.LAST LOOP
121: UPDATE mtl_system_items_interface msii
122: SET msii.copy_organization_id =
123: ( SELECT mp.organization_id
124: FROM mtl_parameters mp
125: WHERE mp.organization_code = base_org_code_table(i))
126: WHERE msii.copy_organization_code = base_org_code_table(i)
127: AND msii.copy_item_id IS NOT NULL
128: AND msii.set_process_id = xset_id

Line 165: FROM mtl_system_items_interface msii, mtl_parameters mp

161:
162: BEGIN
163: SELECT DISTINCT msii.copy_item_id, msii.copy_organization_id
164: BULK COLLECT INTO base_item_table, base_org_table
165: FROM mtl_system_items_interface msii, mtl_parameters mp
166: WHERE msii.process_flag = 1
167: AND msii.set_process_id = xset_id
168: AND msii.transaction_type = 'CREATE'
169: AND ((msii.organization_id = org_id) or (all_org = 1))