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_IMPORT_PUB dependencies on BOM_BILL_OF_MTLS_INTERFACE

Line 284: FROM bom_bill_of_mtls_interface BBMI,mtl_system_items_vl MSIVL,mtl_parameters MP,bom_structures_b BSB

280: BEGIN
281:
282: SELECT item_number
283: INTO l_temp
284: FROM bom_bill_of_mtls_interface BBMI,mtl_system_items_vl MSIVL,mtl_parameters MP,bom_structures_b BSB
285: WHERE BBMI.batch_id = p_batch_id
286: AND BSB.bill_sequence_id = p_bill_seq_id
287: AND (BBMI.process_flag = 1 OR BBMI.process_flag = 5 )
288: AND (( BBMI.request_id IS NOT NULL AND BBMI.request_id = p_request_id ) OR (BBMI.bundle_id IS NOT NULL AND BBMI.bundle_id = p_bundle_id))

Line 329: BOM_BILL_OF_MTLS_INTERFACE

325: )
326: is
327: BEGIN
328: update
329: BOM_BILL_OF_MTLS_INTERFACE
330: set
331: transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
332: where
333: transaction_id is null

Line 402: UPDATE bom_bill_of_mtls_interface

398: --Update Structure Name:Start
399: IF (pg_batch_options.structure_name IS NOT NULL
400: AND pg_batch_options.structure_name <> bom_globals.get_primary_ui)
401: THEN
402: UPDATE bom_bill_of_mtls_interface
403: SET alternate_bom_designator = pg_batch_options.structure_name
404: WHERE batch_id = p_batch_id
405: AND (process_flag = 1 OR process_flag = 5);
406: -- AND alternate_bom_designator IS NOT NULL;

Line 418: UPDATE bom_bill_of_mtls_interface

414: --Update Structure Name:End
415:
416: IF pg_batch_options.structure_type_id IS NOT NULL
417: THEN
418: UPDATE bom_bill_of_mtls_interface
419: SET structure_type_id = pg_batch_options.structure_type_id
420: WHERE batch_id = p_batch_id
421: AND (process_flag = 1 OR process_flag = 5)
422: AND structure_type_id IS NULL;

Line 424: UPDATE bom_bill_of_mtls_interface

420: WHERE batch_id = p_batch_id
421: AND (process_flag = 1 OR process_flag = 5)
422: AND structure_type_id IS NULL;
423:
424: UPDATE bom_bill_of_mtls_interface
425: SET structure_type_name = (SELECT STV1.structure_type_name
426: FROM bom_structure_types_vl STV1 where
427: STV1.structure_type_id = pg_batch_options.structure_type_id)
428: WHERE batch_id = p_batch_id

Line 440: bom_bill_of_mtls_interface

436:
437: --Update Effectivity Details:Start
438: IF ( pg_batch_options.STRUCTURE_EFFECTIVITY_TYPE = 1 ) THEN
439: UPDATE
440: bom_bill_of_mtls_interface
441: SET
442: EFFECTIVITY_CONTROL = 1
443: WHERE
444: batch_id = p_batch_id

Line 461: bom_bill_of_mtls_interface

457: AND (PROCESS_FLAG = 1 OR PROCESS_FLAG =5); --Check New effectivity date
458: END IF;
459: ELSIF (pg_batch_options.STRUCTURE_EFFECTIVITY_TYPE = 2) THEN
460: UPDATE
461: bom_bill_of_mtls_interface
462: SET
463: EFFECTIVITY_CONTROL = 2
464: WHERE
465: batch_id = p_batch_id

Line 943: FROM bom_bill_of_mtls_interface BBMI,mtl_cross_references MCR,ego_import_batches_b EIBB,mtl_system_items MSI

939:
940: CURSOR Process_Header(l_batch_id IN NUMBER)
941: IS
942: SELECT MCR.inventory_item_id,MCR.organization_id,BBMI.source_system_reference,MSI.segment1
943: FROM bom_bill_of_mtls_interface BBMI,mtl_cross_references MCR,ego_import_batches_b EIBB,mtl_system_items MSI
944: WHERE BBMI.batch_id = l_batch_id
945: AND EIBB.batch_id = BBMI.batch_id
946: AND MCR.source_system_id = EIBB.source_system_id
947: AND MCR.cross_reference = BBMI.source_system_reference

Line 1014: UPDATE bom_bill_of_mtls_interface

1010:
1011: ELSE
1012: write_debug('Updating the header x-refs ');
1013:
1014: UPDATE bom_bill_of_mtls_interface
1015: SET assembly_item_id = l_item_id_table(i),
1016: organization_id = l_org_id_table(i),
1017: item_number = l_item_num_table(i)
1018: WHERE batch_id = p_batch_id

Line 1120: FROM bom_bill_of_mtls_interface BBMI,mtl_system_items_interface MSII

1116: l_request_id NUMBER := nvl(FND_GLOBAL.conc_request_id,-1);
1117: CURSOR Process_Header
1118: IS
1119: SELECT MSII.inventory_item_id,MSII.organization_id,MSII.source_system_reference,MSII.item_number
1120: FROM bom_bill_of_mtls_interface BBMI,mtl_system_items_interface MSII
1121: WHERE BBMI.batch_id = p_batch_id
1122: AND (BBMI.process_flag = 1 OR BBMI.process_flag = 5)
1123: AND MSII.set_process_id = BBMI.batch_id
1124: AND MSII.process_flag IN (0,1,7)

Line 1180: UPDATE bom_bill_of_mtls_interface

1176: x_return_status := FND_API.G_RET_STS_ERROR;
1177: ELSE
1178: write_debug('Updating the Header matches ');
1179:
1180: UPDATE bom_bill_of_mtls_interface
1181: SET assembly_item_id = l_item_id_table(i),
1182: Organization_id = l_org_id_table(i),
1183: item_number = l_item_num_table(i),
1184: bill_sequence_id = null,

Line 1307: FROM bom_bill_of_mtls_interface BBMI

1303:
1304: CURSOR Get_Header(l_batch_id IN NUMBER)
1305: IS
1306: SELECT BBMI.assembly_item_id,BBMI.organization_id,BBMI.alternate_bom_designator,BBMI.source_system_reference,UPPER(BBMI.transaction_type),BBMI.organization_code,BBMI.item_number
1307: FROM bom_bill_of_mtls_interface BBMI
1308: WHERE batch_id = l_batch_id
1309: AND process_flag NOT IN(3,7,-1);
1310:
1311: CURSOR Process_Header(l_batch_id IN NUMBER,l_item_id IN NUMBER,l_org_id IN NUMBER,l_name IN VARCHAR2)

Line 1314: FROM bom_bill_of_mtls_interface BBMI,

1310:
1311: CURSOR Process_Header(l_batch_id IN NUMBER,l_item_id IN NUMBER,l_org_id IN NUMBER,l_name IN VARCHAR2)
1312: IS
1313: SELECT BSB.bill_sequence_id,BSB.effectivity_control,BSB.organization_id
1314: FROM bom_bill_of_mtls_interface BBMI,
1315: bom_Structures_b BSB
1316: WHERE BBMI.batch_id = l_batch_id
1317: AND process_flag NOT IN(3,7,-1)
1318: AND BSB.assembly_item_id = l_item_id

Line 1564: UPDATE bom_bill_of_mtls_interface

1560: -- AND transaction_id = l_comp_table(j).transaction_id;
1561: -- END IF;
1562: END LOOP;
1563:
1564: UPDATE bom_bill_of_mtls_interface
1565: SET transaction_type = l_txn_table(i),
1566: Bill_sequence_id = l_bill_seq_id,
1567: assembly_item_id = l_item_id_table(i)
1568: WHERE batch_id = p_batch_id

Line 1627: TYPE bom_intf_header IS TABLE OF Bom_Bill_of_Mtls_Interface%ROWTYPE;

1623:
1624: TYPE var_type IS TABLE OF VARCHAR2(50);
1625: TYPE num_type IS TABLE OF NUMBER;
1626:
1627: TYPE bom_intf_header IS TABLE OF Bom_Bill_of_Mtls_Interface%ROWTYPE;
1628: TYPE bom_intf_comp IS TABLE OF Bom_Inventory_Comps_Interface%ROWTYPE;
1629: TYPE batch_options IS TABLE OF Ego_Import_Option_Sets%ROWTYPE;
1630:
1631: l_header_table bom_intf_header;

Line 1701: bom_bill_of_mtls_interface BBMI,

1697: BBMI.ITEM_NUMBER,
1698: UPPER(BBMI.TRANSACTION_TYPE),
1699: BBMI.ITEM_DESCRIPTION
1700: FROM
1701: bom_bill_of_mtls_interface BBMI,
1702: ego_import_batches_b EIBB
1703: WHERE
1704: BBMI.batch_id = l_batch_id
1705: AND EIBB.batch_id = BBMI.batch_id

Line 3430: bom_bill_of_mtls_interface

3426: FOR iicr IN Item_Intf_ReadyCr
3427: LOOP --iicr cursor loop start
3428: -- Update Bill of materials for Unconfirmed and Excluded
3429: UPDATE
3430: bom_bill_of_mtls_interface
3431: SET
3432: process_flag = 1
3433: WHERE
3434: batch_id = p_batch_id

Line 3440: bom_bill_of_mtls_interface bmi

3436: AND process_flag = 0;
3437:
3438: -- Update Bill of materials for Unconfirmed Children
3439: UPDATE
3440: bom_bill_of_mtls_interface bmi
3441: SET
3442: process_flag = 1
3443: WHERE
3444: bmi.batch_id = p_batch_id

Line 3472: bom_bill_of_mtls_interface

3468: FOR iicr IN Item_Intf_NotReadyCr
3469: LOOP --iicr cursor loop start
3470: -- Update Bill of materials for Unconfirmed and Excluded
3471: UPDATE
3472: bom_bill_of_mtls_interface
3473: SET
3474: process_flag = 0
3475: WHERE
3476: batch_id = p_batch_id

Line 3482: bom_bill_of_mtls_interface bmi

3478: AND process_flag = 1;
3479:
3480: -- Update Bill of materials for Unconfirmed Children
3481: UPDATE
3482: bom_bill_of_mtls_interface bmi
3483: SET
3484: process_flag = 0
3485: WHERE
3486: bmi.batch_id = p_batch_id

Line 3667: FROM bom_bill_of_mtls_interface

3663:
3664: CURSOR Get_Header(p_batch_id IN NUMBER)
3665: IS
3666: SELECT assembly_item_id,organization_id,bill_sequence_id,alternate_bom_designator,item_number,organization_code
3667: FROM bom_bill_of_mtls_interface
3668: WHERE batch_id = p_batch_id
3669: --AND (process_flag = 1 OR process_flag = 5)
3670: AND (assembly_item_id IS NOT NULL OR item_number IS NOT NULL);
3671:

Line 3678: bom_bill_of_mtls_interface BBMI

3674: SELECT BICI.component_item_id,BICI.organization_id,BICI.bill_sequence_id,BBMI.assembly_item_id,decode(BICI.operation_seq_num,null,
3675: BICI.new_operation_seq_num,BICI.operation_seq_num),decode(BICI.effectivity_date,null,BICI.new_effectivity_date,BICI.effectivity_date),
3676: BICI.component_item_number,BICI.assembly_item_number,BICI.organization_code,BICI.component_sequence_id
3677: FROM bom_inventory_comps_interface BICI,
3678: bom_bill_of_mtls_interface BBMI
3679: WHERE BBMI.batch_id = p_batch_id
3680: AND BICI.batch_id = BBMI.batch_id
3681: --AND (BBMI.process_flag = 1 OR BBMI.process_flag = 5)
3682: --AND (BICI.process_flag = 1 OR BICI.process_flag = 5)

Line 3759: UPDATE bom_bill_of_mtls_interface

3755:
3756: Write_Debug('Updating the Header with Ids');
3757:
3758: IF pG_batch_options.PDH_BATCH = 'Y' THEN
3759: UPDATE bom_bill_of_mtls_interface
3760: SET source_system_reference = l_head_name_table(i),
3761: item_number = l_head_name_table(i),
3762: assembly_item_id = l_head_item_id_table(i),
3763: organization_id = l_org_id_table(i)

Line 3769: UPDATE bom_bill_of_mtls_interface

3765: AND NVL(alternate_bom_designator,'Primary') = NVL(l_alt_desg_table(i),'Primary')
3766: --AND (process_flag = 1 OR process_flag = 5)
3767: AND batch_id = p_batch_id;
3768: ELSE
3769: UPDATE bom_bill_of_mtls_interface
3770: SET item_number = l_head_name_table(i),
3771: assembly_item_id = l_head_item_id_table(i),
3772: organization_id = l_org_id_table(i)
3773: WHERE ((assembly_item_id = l_head_item_id_table(i) AND organization_id = l_org_id_table(i)) OR (item_number = l_head_name_table(i) AND organization_code = l_org_code_table(i)))

Line 3969: UPDATE bom_bill_of_mtls_interface

3965: AND source_system_reference = p_ssRef_varray(i);
3966:
3967: --Update the header
3968:
3969: UPDATE bom_bill_of_mtls_interface
3970: SET assembly_item_id = l_item_id
3971: WHERE batch_id = p_batch_id
3972: AND source_system_reference = p_ssRef_varray(i);
3973:

Line 4023: FROM bom_bill_of_mtls_interface

4019:
4020: CURSOR Get_Bill_Seq_Id
4021: IS
4022: SELECT bill_sequence_id
4023: FROM bom_bill_of_mtls_interface
4024: WHERE batch_id = p_batch_id;
4025:
4026: CURSOR Get_Change_Option
4027: IS

Line 4062: UPDATE Bom_Bill_Of_Mtls_Interface

4058: l_change_flag := 'Y';
4059: END IF;
4060: IF l_change_flag = 'Y' THEN
4061: --Update the Header rows with process flag = 5
4062: UPDATE Bom_Bill_Of_Mtls_Interface
4063: SET process_flag = 5
4064: WHERE batch_id = p_batch_id
4065: AND bill_sequence_id = l_bill_seq_table(i);
4066:

Line 4121: FROM bom_bill_of_mtls_interface BBMI

4117: CURSOR Get_Header(l_batch_id IN NUMBER)
4118: IS
4119: SELECT
4120: BBMI.assembly_item_id,BBMI.organization_id,BBMI.alternate_bom_designator,BBMI.source_system_reference,UPPER(BBMI.transaction_type),request_id,bundle_id
4121: FROM bom_bill_of_mtls_interface BBMI
4122: WHERE batch_id = l_batch_id
4123: AND process_flag NOT IN (3,7,-1,0);
4124:
4125: CURSOR Process_Header(l_batch_id IN NUMBER,l_item_id IN NUMBER,l_org_id IN NUMBER,l_name IN VARCHAR2)

Line 4130: bom_bill_of_mtls_interface BBMI,

4126: IS
4127: SELECT
4128: BSB.bill_sequence_id,BSB.effectivity_control,BSB.organization_id
4129: FROM
4130: bom_bill_of_mtls_interface BBMI,
4131: bom_Structures_b BSB
4132: WHERE
4133: BBMI.batch_id = l_batch_id
4134: AND BBMI.process_flag NOT IN (3,7,-1,0)

Line 4746: DELETE bom_bill_of_mtls_interface

4742:
4743: stmt_num := 1;
4744: Write_Debug('Deleting the header rows');
4745:
4746: DELETE bom_bill_of_mtls_interface
4747: WHERE batch_id = p_batch_id;
4748:
4749: stmt_num := 2;
4750: Write_Debug('Deleting the component rows');

Line 5365: FROM bom_bill_of_mtls_interface

5361: IS
5362: CURSOR Get_Header
5363: IS
5364: SELECT *
5365: FROM bom_bill_of_mtls_interface
5366: WHERE batch_id = p_batch_id
5367: AND process_flag = 1;
5368:
5369: TYPE bom_header_type IS TABLE OF bom_bill_of_mtls_interface%ROWTYPE;

Line 5369: TYPE bom_header_type IS TABLE OF bom_bill_of_mtls_interface%ROWTYPE;

5365: FROM bom_bill_of_mtls_interface
5366: WHERE batch_id = p_batch_id
5367: AND process_flag = 1;
5368:
5369: TYPE bom_header_type IS TABLE OF bom_bill_of_mtls_interface%ROWTYPE;
5370: l_header_table bom_header_type;
5371: l_str_chng_policy VARCHAR2(50);
5372: l_count NUMBER;
5373: l_rev_id NUMBER;

Line 5383: UPDATE bom_bill_of_mtls_interface

5379: THEN
5380: IF nvl(pG_batch_options.ADD_ALL_TO_CHANGE_FLAG,'N') = 'Y' THEN
5381: -- Only for header setting the process flag to 5 even for already
5382: -- process_flag = 7 records for bug 4686771
5383: UPDATE bom_bill_of_mtls_interface
5384: SET process_flag = 5
5385: --pending_from_ecn = nvl(pending_from_ecn,pG_batch_options.CHANGE_NOTICE) we need not do this
5386: WHERE batch_id = p_batch_id
5387: AND (process_flag = 1 OR process_flag = 7);

Line 5442: UPDATE bom_bill_of_mtls_interface

5438: l_header_table(i).structure_type_id);
5439: END IF;
5440:
5441: IF l_str_chng_policy = 'CHANGE_ORDER_REQUIRED' THEN
5442: UPDATE bom_bill_of_mtls_interface
5443: SET process_flag = 5
5444: WHERE batch_id = p_batch_id
5445: AND (process_flag = 1 OR process_flag = 7)
5446: AND interface_table_unique_id = l_header_table(i).interface_table_unique_id;