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 FND_API

Line 299: AND NVL(bom.alternate_bom_designator,FND_API.G_MISS_CHAR) = NVL(BBMI.alternate_bom_designator,FND_API.G_MISS_CHAR))

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
301: AND upper(transaction_type) in (G_Delete, G_Update)
302: AND assembly_item_id is not null
303: AND organization_id is not null

Line 313: AND NVL(bom1.alternate_bom_designator,FND_API.G_MISS_CHAR) = NVL(BBMI.alternate_bom_designator,FND_API.G_MISS_CHAR));

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:
315: /* Commented for Performance Fix . We will have the ids before reaching this point
316: So we dont need to resolve bill_seq_id using UUs
317:

Line 326: AND NVL(bom.alternate_bom_designator,FND_API.G_MISS_CHAR) = NVL(BBMI.alternate_bom_designator,FND_API.G_MISS_CHAR))

322: WHERE mvll.concatenated_segments = BBMI.item_number
323: AND mvll.organization_id = BBMI.organization_id
324: AND bom.assembly_item_id = mvll.inventory_item_id
325: AND bom.organization_id = mvll.organization_id
326: AND NVL(bom.alternate_bom_designator,FND_API.G_MISS_CHAR) = NVL(BBMI.alternate_bom_designator,FND_API.G_MISS_CHAR))
327: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
328: AND upper(transaction_type) in (G_Delete, G_Update)
329: AND item_number is not null
330: AND organization_id is not null

Line 779: AND NVL(bom.alternate_bom_designator,FND_API.G_MISS_CHAR) = NVL(BICI.alternate_bom_designator,FND_API.G_MISS_CHAR))

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
781: AND upper(transaction_type) in (G_Delete, G_Update)
782: AND assembly_item_id is not null
783: AND organization_id is not null

Line 793: AND NVL(BSB.alternate_bom_designator,FND_API.G_MISS_CHAR) = NVL(BICI.alternate_bom_designator,FND_API.G_MISS_CHAR)

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: );
795:
796:
797:

Line 2322: AND NVL(bom.alternate_bom_designator,FND_API.G_MISS_CHAR) = NVL(BICI.alternate_bom_designator,FND_API.G_MISS_CHAR))

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
2324: AND upper(transaction_type) in (G_Delete, G_Update)
2325: AND assembly_item_number is not null
2326: AND organization_id is not null

Line 2336: AND NVL(bom2.alternate_bom_designator,FND_API.G_MISS_CHAR) = NVL(BICI.alternate_bom_designator,FND_API.G_MISS_CHAR));

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:
2338: /*
2339:
2340: l_return_status := Process_Comps_Info

Line 2718: AND NVL(bom.alternate_bom_designator,FND_API.G_MISS_CHAR) = NVL(BRDI.alternate_bom_designator,FND_API.G_MISS_CHAR))

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
2720: AND upper(transaction_type) in (G_Delete, G_Update, 'SYNC', G_Create)
2721: AND assembly_item_id is not null
2722: AND organization_id is not null

Line 2984: AND NVL(bom.alternate_bom_designator,FND_API.G_MISS_CHAR) = NVL(BSCI.alternate_bom_designator,FND_API.G_MISS_CHAR))

2980: SET bill_sequence_id = (SELECT bill_sequence_id
2981: FROM bom_bill_of_materials bom
2982: WHERE bom.assembly_item_id = BSCI.assembly_item_id
2983: AND bom.organization_id = BSCI.organization_id
2984: AND NVL(bom.alternate_bom_designator,FND_API.G_MISS_CHAR) = NVL(BSCI.alternate_bom_designator,FND_API.G_MISS_CHAR))
2985: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
2986: AND upper(transaction_type) in (G_Delete, G_Update, 'SYNC', G_Create)
2987: AND assembly_item_id is not null
2988: AND organization_id is not null