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.BOM_RTG_OI_UTIL dependencies on BOM_OP_ROUTINGS_INTERFACE

Line 28: G_RtgDelEntity constant varchar2(30) := 'BOM_OP_ROUTINGS_INTERFACE';

24:
25: G_Create constant varchar2(10) := 'CREATE'; -- transaction type
26: G_Update constant varchar2(10) := 'UPDATE'; -- transaction type
27: G_Delete constant varchar2(10) := 'DELETE'; -- transaction type
28: G_RtgDelEntity constant varchar2(30) := 'BOM_OP_ROUTINGS_INTERFACE';
29: G_OprDelEntity constant varchar2(30) := 'BOM_OP_SEQUENCES_INTERFACE';
30:
31: /*--------------------------Process_Header_Info------------------------------
32:

Line 40: BOM_OP_ROUTINGS_INTERFACE

36: Populate the user-friendly columns to routing record in the interface table
37: REQUIRES
38:
39: MODIFIES
40: BOM_OP_ROUTINGS_INTERFACE
41: MTL_INTERFACE_ERRORS
42: RETURNS
43: 0 if successful
44: SQLCODE if unsuccessful

Line 71: UPDATE BOM_OP_ROUTINGS_INTERFACE BORI

67: BEGIN
68: stmt_num := 1;
69: /* Resolve the routing sequence ids for updates and deletes */
70:
71: UPDATE BOM_OP_ROUTINGS_INTERFACE BORI
72: SET(assembly_item_id, organization_id, alternate_routing_designator)
73: = (SELECT assembly_item_id, organization_id , alternate_routing_designator
74: FROM BOM_OPERATIONAL_ROUTINGS BOR1
75: WHERE BOR1.routing_sequence_id = BORI.routing_sequence_id)

Line 93: UPDATE BOM_OP_ROUTINGS_INTERFACE BORI

89:
90: /* Update Organization Code using Organization_id
91: this also needed if Organization_id is given and code is not given*/
92:
93: UPDATE BOM_OP_ROUTINGS_INTERFACE BORI
94: SET organization_code = (SELECT organization_code
95: FROM MTL_PARAMETERS MP1
96: WHERE mp1.organization_id = BORI.organization_id)
97: WHERE process_flag = 1

Line 114: UPDATE BOM_OP_ROUTINGS_INTERFACE BORI

110: stmt_num := 3;
111: /* Update Organization_ids if organization code is given org id is null.
112: Orgnaization_id information is needed in the next steps */
113:
114: UPDATE BOM_OP_ROUTINGS_INTERFACE BORI
115: SET organization_id = (SELECT organization_id
116: FROM MTL_PARAMETERS mp1
117: WHERE mp1.organization_code = BORI.organization_code)
118: WHERE process_flag = 1

Line 131: UPDATE BOM_OP_ROUTINGS_INTERFACE BORI

127:
128: stmt_num := 4;
129: /* Update Assembly Item name */
130:
131: UPDATE BOM_OP_ROUTINGS_INTERFACE BORI
132: SET assembly_item_number = (SELECT concatenated_segments
133: FROM MTL_SYSTEM_ITEMS_KFV mvl1
134: WHERE mvl1.inventory_item_id = BORI.assembly_item_id
135: and mvl1.organization_id = BORI.organization_id)

Line 155: UPDATE BOM_OP_ROUTINGS_INTERFACE BORI

151:
152: stmt_num := 5;
153: /* Assign transaction ids */
154:
155: UPDATE BOM_OP_ROUTINGS_INTERFACE BORI
156: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval
157: WHERE transaction_id is null
158: --Bug 3411601 AND upper(transaction_type) in (G_Create, G_Update, G_Delete)
159: AND upper(transaction_type) in (G_Create, G_Update, G_Delete, 'NO_OP')

Line 170: UPDATE BOM_OP_ROUTINGS_INTERFACE BORI

166: AND (all_org = 1
167: OR
168: (all_org = 2 AND organization_id = org_id));
169:
170: UPDATE BOM_OP_ROUTINGS_INTERFACE BORI
171: SET transaction_type = upper(transaction_type)
172: WHERE upper(transaction_type) in (G_Create, G_Update, G_Delete)
173: AND process_flag = 1
174: AND

Line 188: UPDATE BOM_OP_ROUTINGS_INTERFACE BORI

184: stmt_num := 6;
185: /* Assign Common Assembly Item id if common_routing_sequence_id is given
186: and a routing exists with that routing_sequence_id */
187:
188: UPDATE BOM_OP_ROUTINGS_INTERFACE BORI
189: SET(common_assembly_item_id)
190: = (SELECT assembly_item_id
191: FROM BOM_OPERATIONAL_ROUTINGS BOR1
192: WHERE BOR1.routing_sequence_id = BORI.common_routing_sequence_id)

Line 209: UPDATE BOM_OP_ROUTINGS_INTERFACE BORI

205: stmt_num :=7;
206:
207: /* Update Assembly Item name */
208:
209: UPDATE BOM_OP_ROUTINGS_INTERFACE BORI
210: SET common_item_number = (SELECT concatenated_segments
211: FROM MTL_SYSTEM_ITEMS_KFV mvl1
212: WHERE mvl1.inventory_item_id = BORI.common_assembly_item_id
213: and mvl1.organization_id = BORI.organization_id)

Line 231: UPDATE BOM_OP_ROUTINGS_INTERFACE BORI

227:
228:
229: stmt_num := 8 ;
230: /* Update the line code from line_id */
231: UPDATE BOM_OP_ROUTINGS_INTERFACE BORI
232: SET line_code = (SELECT line_code
233: FROM WIP_LINES wl1
234: WHERE wl1.LINE_ID = BORI.LINE_ID -- Bug Fix 3782414
235: AND wl1.organization_id = BORI.organization_id)

Line 252: UPDATE BOM_OP_ROUTINGS_INTERFACE BORI

248: AND nvl(wl2.disable_date, trunc(sysdate) + 1) > trunc(sysdate));
249:
250: stmt_num := 9;
251: /* Update the delete_group_name from bom_interface_delete_groups */
252: UPDATE BOM_OP_ROUTINGS_INTERFACE BORI
253: SET (DELETE_GROUP_NAME, DG_DESCRIPTION)
254: = (SELECT DELETE_GROUP_NAME, DESCRIPTION
255: FROM bom_interface_delete_groups
256: Where upper(entity_name) = G_RtgDelEntity

Line 275: UPDATE BOM_OP_ROUTINGS_INTERFACE BORI

271:
272: stmt_num := 10;
273: /* Update Supply_locator_name */
274:
275: UPDATE BOM_OP_ROUTINGS_INTERFACE BORI
276: SET location_name = (SELECT concatenated_segments
277: FROM MTL_ITEM_LOCATIONS_KFV MIL1
278: WHERE MIL1.inventory_location_id = BORI.COMPLETION_LOCATOR_ID
279: and MIL1.organization_id = BORI.organization_id)

Line 336: FROM BOM_OP_ROUTINGS_INTERFACE

332: NVL(PROGRAM_APPLICATION_ID, prog_appid),
333: NVL(PROGRAM_ID, prog_id),
334: NVL(PROGRAM_UPDATE_DATE, sysdate),
335: BATCH_ID
336: FROM BOM_OP_ROUTINGS_INTERFACE
337: WHERE process_flag = 1
338: AND transaction_type = G_Create
339: AND
340: (

Line 386: 'BOM_OP_ROUTINGS_INTERFACE',

382: BORI.transaction_id,
383: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
384: Null,
385: null,
386: 'BOM_OP_ROUTINGS_INTERFACE',
387: decode ( BORI.Organization_code, null, msg_name1,msg_name2),
388: decode ( BORI.Organization_code, null, msg_text1,msg_text2),
389: NVL(LAST_UPDATE_DATE, SYSDATE),
390: NVL(LAST_UPDATED_BY, user_id),

Line 398: from BOM_OP_ROUTINGS_INTERFACE BORI

394: req_id,
395: NVL(PROGRAM_APPLICATION_ID, prog_appid),
396: NVL(PROGRAM_ID, prog_id),
397: NVL(PROGRAM_UPDATE_DATE, sysdate)
398: from BOM_OP_ROUTINGS_INTERFACE BORI
399: where (organization_code is null or assembly_item_number is null)
400: and transaction_id is not null
401: and upper(transaction_type) <> 'NO_OP' -- Added for bug 13555685
402: and process_flag =1

Line 410: Update BOM_OP_ROUTINGS_INTERFACE BORI

406: OR ( p_batch_id = batch_id )
407: )
408: and (all_org = 1 OR (all_org = 2 AND organization_id = org_id)) ;
409:
410: Update BOM_OP_ROUTINGS_INTERFACE BORI
411: set process_flag = 3
412: where (assembly_item_number is null or Organization_code is null)
413: and transaction_id is not null
414: and upper(transaction_type) <> 'NO_OP' -- Added for bug 13555685