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 569: FROM bom_structures_b BBM1

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

Line 581: FROM bom_structures_b BBM2

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

Line 787: FROM bom_structures_b bom

783: stmt_num := 8.6;
784: /* Update the bill_sequence_id */
785: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
786: SET bill_sequence_id = (SELECT bill_sequence_id
787: FROM bom_structures_b bom
788: WHERE bom.assembly_item_id = BICI.assembly_item_id
789: AND bom.organization_id = BICI.organization_id
790: AND NVL(bom.alternate_bom_designator,FND_API.G_MISS_CHAR) = NVL(BICI.alternate_bom_designator,FND_API.G_MISS_CHAR))
791: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import

Line 802: FROM bom_structures_b bsb

798: ( (p_batch_id IS NULL) AND (BICI.batch_id IS NULL) )
799: OR ( p_batch_id = BICI.batch_id )
800: )
801: AND exists (SELECT 'x'
802: FROM bom_structures_b bsb
803: WHERE bsb.assembly_item_id = BICI.assembly_item_id
804: AND bsb.organization_id = BICI.organization_id
805: AND NVL(BSB.alternate_bom_designator,FND_API.G_MISS_CHAR) = NVL(BICI.alternate_bom_designator,FND_API.G_MISS_CHAR)
806: );

Line 1149: FROM bom_structures_b BBM1

1145:
1146: UPDATE BOM_REF_DESGS_INTERFACE BRDI
1147: SET(assembly_item_id, organization_id, ALTERNATE_BOM_DESIGNATOR)
1148: = (SELECT assembly_item_id, organization_id , alternate_bom_designator
1149: FROM bom_structures_b BBM1
1150: WHERE BBM1.bill_sequence_id = BRDI.bill_sequence_id)
1151: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
1152: AND change_notice is null --added for bug 9673701
1153: AND upper(transaction_type) in (G_Delete, G_Update, G_Create)

Line 1161: FROM bom_structures_b BBM2

1157: ( (p_batch_id IS NULL) AND (BRDI.batch_id IS NULL) )
1158: OR ( p_batch_id = BRDI.batch_id )
1159: )
1160: AND exists (SELECT 'x'
1161: FROM bom_structures_b BBM2
1162: WHERE BBM2.bill_sequence_id = BRDI.bill_sequence_id);
1163:
1164:
1165: stmt_num := 3;

Line 1428: FROM bom_structures_b BBM1

1424:
1425: UPDATE BOM_SUB_COMPS_INTERFACE BSCI
1426: SET(assembly_item_id, organization_id, alternate_bom_designator)
1427: = (SELECT assembly_item_id, organization_id , alternate_bom_designator
1428: FROM bom_structures_b BBM1
1429: WHERE BBM1.bill_sequence_id = BSCI.bill_sequence_id)
1430: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
1431: AND change_notice is null --added for bug 9673701
1432: AND upper(transaction_type) in (G_Delete, G_Update, G_Create)

Line 1440: FROM bom_structures_b BBM2

1436: ( (p_batch_id IS NULL) AND (BSCI.batch_id IS NULL) )
1437: OR ( p_batch_id = BSCI.batch_id )
1438: )
1439: AND exists (SELECT 'x'
1440: FROM bom_structures_b BBM2
1441: WHERE BBM2.bill_sequence_id = BSCI.bill_sequence_id);
1442:
1443:
1444: stmt_num := 3;

Line 1755: FROM bom_structures_b BBM1

1751:
1752: UPDATE BOM_COMPONENT_OPS_INTERFACE BCOI
1753: SET(assembly_item_id, organization_id, alternate_bom_designator)
1754: = (SELECT assembly_item_id, organization_id , alternate_bom_designator
1755: FROM bom_structures_b BBM1
1756: WHERE BBM1.bill_sequence_id = BCOI.bill_sequence_id)
1757: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
1758: AND upper(transaction_type) in (G_Delete, G_Update, G_Create)
1759: AND bill_sequence_id is not null

Line 1766: FROM bom_structures_b BBM2

1762: ( (p_batch_id IS NULL) AND (BCOI.batch_id IS NULL) )
1763: OR ( p_batch_id = BCOI.batch_id )
1764: )
1765: AND exists (SELECT 'x'
1766: FROM bom_structures_b BBM2
1767: WHERE BBM2.bill_sequence_id = BCOI.bill_sequence_id);
1768:
1769:
1770: stmt_num := 3;

Line 2363: FROM bom_structures_b bom

2359:
2360: /* Update the bill_sequence_id */
2361: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
2362: SET bill_sequence_id = (SELECT bill_sequence_id
2363: FROM bom_structures_b bom
2364: WHERE bom.assembly_item_id = BICI.assembly_item_id
2365: AND bom.organization_id = BICI.organization_id
2366: AND NVL(bom.alternate_bom_designator,FND_API.G_MISS_CHAR) = NVL(BICI.alternate_bom_designator,FND_API.G_MISS_CHAR))
2367: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import

Line 2377: FROM bom_structures_b bom2

2373: ( (p_batch_id IS NULL) AND (BICI.batch_id IS NULL) )
2374: OR ( p_batch_id = BICI.batch_id )
2375: )
2376: AND exists (SELECT 'x'
2377: FROM bom_structures_b bom2
2378: WHERE bom2.assembly_item_id = BICI.assembly_item_id
2379: AND bom2.organization_id = BICI.organization_id
2380: AND NVL(bom2.alternate_bom_designator,FND_API.G_MISS_CHAR) = NVL(BICI.alternate_bom_designator,FND_API.G_MISS_CHAR));
2381:

Line 2759: FROM bom_structures_b bom

2755:
2756: /* Set the Bill Seqeunce Ids */
2757: UPDATE BOM_REF_DESGS_INTERFACE BRDI
2758: SET bill_sequence_id = (SELECT bill_sequence_id
2759: FROM bom_structures_b bom
2760: WHERE bom.assembly_item_id = BRDI.assembly_item_id
2761: AND bom.organization_id = BRDI.organization_id
2762: AND NVL(bom.alternate_bom_designator,FND_API.G_MISS_CHAR) = NVL(BRDI.alternate_bom_designator,FND_API.G_MISS_CHAR))
2763: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import