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_OPEN_INTERFACE_UTL dependencies on BOM_STRUCTURES_B

Line 68: FROM bom_structures_b BBM1

64:
65: UPDATE BOM_BILL_OF_MTLS_INTERFACE BBMI
66: SET(assembly_item_id, organization_id, alternate_bom_designator)
67: = (SELECT assembly_item_id, organization_id , alternate_bom_designator
68: FROM bom_structures_b BBM1
69: WHERE BBM1.bill_sequence_id = BBMI.bill_sequence_id)
70: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
71: AND upper(transaction_type) in (G_Delete, G_Update)
72: AND bill_sequence_id is not null

Line 79: FROM bom_structures_b BBM2

75: ( (p_batch_id IS NULL) AND (BBMI.batch_id IS NULL) )
76: OR ( p_batch_id = BBMI.batch_id )
77: )
78: AND exists (SELECT 'x'
79: FROM bom_structures_b BBM2
80: WHERE BBM2.bill_sequence_id = BBMI.bill_sequence_id);
81:
82:
83:

Line 192: FROM bom_structures_b BBM1

188:
189: UPDATE BOM_BILL_OF_MTLS_INTERFACE BBMI
190: SET(common_assembly_item_id, common_organization_id)
191: = (SELECT assembly_item_id, organization_id
192: FROM bom_structures_b BBM1
193: WHERE BBM1.bill_sequence_id = BBMI.common_bill_sequence_id)
194: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
195: AND upper(transaction_type) in (G_Create, G_Delete, G_Update,G_NoOp)
196: AND common_bill_sequence_id is not null

Line 203: FROM bom_structures_b BBM2

199: ( (p_batch_id IS NULL) AND (BBMI.batch_id IS NULL) )
200: OR ( p_batch_id = BBMI.batch_id )
201: )
202: AND exists (SELECT 'x'
203: FROM bom_structures_b BBM2
204: WHERE BBM2.bill_sequence_id = BBMI.common_bill_sequence_id);
205:
206:
207:

Line 296: FROM bom_structures_b bom

292: /* Update Bill Sequence Id when there are IDs available */
293:
294: UPDATE BOM_BILL_OF_MTLS_INTERFACE BBMI
295: SET bill_sequence_id = (SELECT bill_sequence_id
296: FROM bom_structures_b bom
297: WHERE bom.assembly_item_id = BBMI.assembly_item_id
298: AND bom.organization_id = BBMI.organization_id
299: AND NVL(bom.alternate_bom_designator,FND_API.G_MISS_CHAR) = NVL(BBMI.alternate_bom_designator,FND_API.G_MISS_CHAR))
300: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import

Line 310: FROM bom_structures_b bom1

306: ( (p_batch_id IS NULL) AND (BBMI.batch_id IS NULL) )
307: OR ( p_batch_id = BBMI.batch_id )
308: )
309: AND exists (SELECT 1
310: FROM bom_structures_b bom1
311: WHERE bom1.assembly_item_id = BBMI.assembly_item_id
312: AND bom1.organization_id = BBMI.organization_id
313: AND NVL(bom1.alternate_bom_designator,FND_API.G_MISS_CHAR) = NVL(BBMI.alternate_bom_designator,FND_API.G_MISS_CHAR));
314:

Line 568: FROM bom_structures_b BBM1

564:
565: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
566: SET(assembly_item_id, organization_id, alternate_bom_designator)
567: = (SELECT assembly_item_id, organization_id , alternate_bom_designator
568: FROM bom_structures_b BBM1
569: WHERE BBM1.bill_sequence_id = BICI.bill_sequence_id)
570: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
571: AND upper(transaction_type) in (G_Delete, G_Update, G_Create)
572: AND bill_sequence_id is not null

Line 579: FROM bom_structures_b BBM2

575: ( (p_batch_id IS NULL) AND (BICI.batch_id IS NULL) )
576: OR ( p_batch_id = BICI.batch_id )
577: )
578: AND exists (SELECT 'x'
579: FROM bom_structures_b BBM2
580: WHERE BBM2.bill_sequence_id =BICI.bill_sequence_id);
581:
582:
583: stmt_num := 3;

Line 776: FROM bom_structures_b bom

772: stmt_num := 8.6;
773: /* Update the bill_sequence_id */
774: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
775: SET bill_sequence_id = (SELECT bill_sequence_id
776: FROM bom_structures_b bom
777: WHERE bom.assembly_item_id = BICI.assembly_item_id
778: AND bom.organization_id = BICI.organization_id
779: AND NVL(bom.alternate_bom_designator,FND_API.G_MISS_CHAR) = NVL(BICI.alternate_bom_designator,FND_API.G_MISS_CHAR))
780: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import

Line 790: FROM bom_structures_b bsb

786: ( (p_batch_id IS NULL) AND (BICI.batch_id IS NULL) )
787: OR ( p_batch_id = BICI.batch_id )
788: )
789: AND exists (SELECT 'x'
790: FROM bom_structures_b bsb
791: WHERE bsb.assembly_item_id = BICI.assembly_item_id
792: AND bsb.organization_id = BICI.organization_id
793: AND NVL(BSB.alternate_bom_designator,FND_API.G_MISS_CHAR) = NVL(BICI.alternate_bom_designator,FND_API.G_MISS_CHAR)
794: );

Line 1130: FROM bom_structures_b BBM1

1126:
1127: UPDATE BOM_REF_DESGS_INTERFACE BRDI
1128: SET(assembly_item_id, organization_id, ALTERNATE_BOM_DESIGNATOR)
1129: = (SELECT assembly_item_id, organization_id , alternate_bom_designator
1130: FROM bom_structures_b BBM1
1131: WHERE BBM1.bill_sequence_id = BRDI.bill_sequence_id)
1132: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
1133: AND upper(transaction_type) in (G_Delete, G_Update, G_Create)
1134: AND bill_sequence_id is not null

Line 1141: FROM bom_structures_b BBM2

1137: ( (p_batch_id IS NULL) AND (BRDI.batch_id IS NULL) )
1138: OR ( p_batch_id = BRDI.batch_id )
1139: )
1140: AND exists (SELECT 'x'
1141: FROM bom_structures_b BBM2
1142: WHERE BBM2.bill_sequence_id = BRDI.bill_sequence_id);
1143:
1144:
1145: stmt_num := 3;

Line 1400: FROM bom_structures_b BBM1

1396:
1397: UPDATE BOM_SUB_COMPS_INTERFACE BSCI
1398: SET(assembly_item_id, organization_id, alternate_bom_designator)
1399: = (SELECT assembly_item_id, organization_id , alternate_bom_designator
1400: FROM bom_structures_b BBM1
1401: WHERE BBM1.bill_sequence_id = BSCI.bill_sequence_id)
1402: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
1403: AND upper(transaction_type) in (G_Delete, G_Update, G_Create)
1404: AND bill_sequence_id is not null

Line 1411: FROM bom_structures_b BBM2

1407: ( (p_batch_id IS NULL) AND (BSCI.batch_id IS NULL) )
1408: OR ( p_batch_id = BSCI.batch_id )
1409: )
1410: AND exists (SELECT 'x'
1411: FROM bom_structures_b BBM2
1412: WHERE BBM2.bill_sequence_id = BSCI.bill_sequence_id);
1413:
1414:
1415: stmt_num := 3;

Line 1717: FROM bom_structures_b BBM1

1713:
1714: UPDATE BOM_COMPONENT_OPS_INTERFACE BCOI
1715: SET(assembly_item_id, organization_id, alternate_bom_designator)
1716: = (SELECT assembly_item_id, organization_id , alternate_bom_designator
1717: FROM bom_structures_b BBM1
1718: WHERE BBM1.bill_sequence_id = BCOI.bill_sequence_id)
1719: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
1720: AND upper(transaction_type) in (G_Delete, G_Update, G_Create)
1721: AND bill_sequence_id is not null

Line 1728: FROM bom_structures_b BBM2

1724: ( (p_batch_id IS NULL) AND (BCOI.batch_id IS NULL) )
1725: OR ( p_batch_id = BCOI.batch_id )
1726: )
1727: AND exists (SELECT 'x'
1728: FROM bom_structures_b BBM2
1729: WHERE BBM2.bill_sequence_id = BCOI.bill_sequence_id);
1730:
1731:
1732: stmt_num := 3;

Line 2319: FROM bom_structures_b bom

2315:
2316: /* Update the bill_sequence_id */
2317: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
2318: SET bill_sequence_id = (SELECT bill_sequence_id
2319: FROM bom_structures_b bom
2320: WHERE bom.assembly_item_id = BICI.assembly_item_id
2321: AND bom.organization_id = BICI.organization_id
2322: AND NVL(bom.alternate_bom_designator,FND_API.G_MISS_CHAR) = NVL(BICI.alternate_bom_designator,FND_API.G_MISS_CHAR))
2323: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import

Line 2333: FROM bom_structures_b bom2

2329: ( (p_batch_id IS NULL) AND (BICI.batch_id IS NULL) )
2330: OR ( p_batch_id = BICI.batch_id )
2331: )
2332: AND exists (SELECT 'x'
2333: FROM bom_structures_b bom2
2334: WHERE bom2.assembly_item_id = BICI.assembly_item_id
2335: AND bom2.organization_id = BICI.organization_id
2336: AND NVL(bom2.alternate_bom_designator,FND_API.G_MISS_CHAR) = NVL(BICI.alternate_bom_designator,FND_API.G_MISS_CHAR));
2337:

Line 2715: FROM bom_structures_b bom

2711:
2712: /* Set the Bill Seqeunce Ids */
2713: UPDATE BOM_REF_DESGS_INTERFACE BRDI
2714: SET bill_sequence_id = (SELECT bill_sequence_id
2715: FROM bom_structures_b bom
2716: WHERE bom.assembly_item_id = BRDI.assembly_item_id
2717: AND bom.organization_id = BRDI.organization_id
2718: AND NVL(bom.alternate_bom_designator,FND_API.G_MISS_CHAR) = NVL(BRDI.alternate_bom_designator,FND_API.G_MISS_CHAR))
2719: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import