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.

[Home] [Help]

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 790: AND NVL(bom.alternate_bom_designator,FND_API.G_MISS_CHAR) = NVL(BICI.alternate_bom_designator,FND_API.G_MISS_CHAR))

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
792: AND change_notice is null --added for bug 9673701
793: AND upper(transaction_type) in (G_Delete, G_Update)
794: AND assembly_item_id is not null

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

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: );
807:
808:
809:

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

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
2368: AND upper(transaction_type) in (G_Delete, G_Update)
2369: AND assembly_item_number is not null
2370: AND organization_id is not null

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

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:
2382: /*
2383:
2384: l_return_status := Process_Comps_Info

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

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

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

3024: SET bill_sequence_id = (SELECT bill_sequence_id
3025: FROM bom_bill_of_materials bom
3026: WHERE bom.assembly_item_id = BSCI.assembly_item_id
3027: AND bom.organization_id = BSCI.organization_id
3028: AND NVL(bom.alternate_bom_designator,FND_API.G_MISS_CHAR) = NVL(BSCI.alternate_bom_designator,FND_API.G_MISS_CHAR))
3029: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
3030: AND upper(transaction_type) in (G_Delete, G_Update, 'SYNC', G_Create)
3031: AND assembly_item_id is not null
3032: AND organization_id is not null