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 291: FROM bom_bill_of_mtls_interface BBMI,mtl_system_items_vl MSIVL,mtl_parameters MP,bom_structures_b BSB

287: BEGIN
288:
289: SELECT item_number
290: INTO l_temp
291: FROM bom_bill_of_mtls_interface BBMI,mtl_system_items_vl MSIVL,mtl_parameters MP,bom_structures_b BSB
292: WHERE BBMI.batch_id = p_batch_id
293: AND BSB.bill_sequence_id = p_bill_seq_id
294: AND (BBMI.process_flag = 1 OR BBMI.process_flag = 5 )
295: 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 336: BOM_BILL_OF_MTLS_INTERFACE

332: )
333: is
334: BEGIN
335: update
336: BOM_BILL_OF_MTLS_INTERFACE
337: set
338: transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
339: where
340: transaction_id is null

Line 409: UPDATE bom_bill_of_mtls_interface

405: --Update Structure Name:Start
406: IF (pg_batch_options.structure_name IS NOT NULL
407: AND pg_batch_options.structure_name <> bom_globals.get_primary_ui)
408: THEN
409: UPDATE bom_bill_of_mtls_interface
410: SET alternate_bom_designator = pg_batch_options.structure_name
411: WHERE batch_id = p_batch_id
412: AND (process_flag = 1 OR process_flag = 5);
413: -- AND alternate_bom_designator IS NOT NULL;

Line 425: UPDATE bom_bill_of_mtls_interface

421: --Update Structure Name:End
422:
423: IF pg_batch_options.structure_type_id IS NOT NULL
424: THEN
425: UPDATE bom_bill_of_mtls_interface
426: SET structure_type_id = pg_batch_options.structure_type_id
427: WHERE batch_id = p_batch_id
428: AND (process_flag = 1 OR process_flag = 5)
429: AND structure_type_id IS NULL;

Line 431: UPDATE bom_bill_of_mtls_interface

427: WHERE batch_id = p_batch_id
428: AND (process_flag = 1 OR process_flag = 5)
429: AND structure_type_id IS NULL;
430:
431: UPDATE bom_bill_of_mtls_interface
432: SET structure_type_name = (SELECT STV1.structure_type_name
433: FROM bom_structure_types_vl STV1 where
434: STV1.structure_type_id = pg_batch_options.structure_type_id)
435: WHERE batch_id = p_batch_id

Line 447: bom_bill_of_mtls_interface

443:
444: --Update Effectivity Details:Start
445: IF ( pg_batch_options.STRUCTURE_EFFECTIVITY_TYPE = 1 ) THEN
446: UPDATE
447: bom_bill_of_mtls_interface
448: SET
449: EFFECTIVITY_CONTROL = 1
450: WHERE
451: batch_id = p_batch_id

Line 468: bom_bill_of_mtls_interface

464: AND (PROCESS_FLAG = 1 OR PROCESS_FLAG =5); --Check New effectivity date
465: END IF;
466: ELSIF (pg_batch_options.STRUCTURE_EFFECTIVITY_TYPE = 2) THEN
467: UPDATE
468: bom_bill_of_mtls_interface
469: SET
470: EFFECTIVITY_CONTROL = 2
471: WHERE
472: batch_id = p_batch_id

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

1080:
1081: CURSOR Process_Header(l_batch_id IN NUMBER)
1082: IS
1083: SELECT MCR.inventory_item_id,MCR.organization_id,BBMI.source_system_reference,MSI.segment1
1084: FROM bom_bill_of_mtls_interface BBMI,mtl_cross_references MCR,ego_import_batches_b EIBB,mtl_system_items MSI
1085: WHERE BBMI.batch_id = l_batch_id
1086: AND EIBB.batch_id = BBMI.batch_id
1087: AND MCR.source_system_id = EIBB.source_system_id
1088: AND MCR.cross_reference = BBMI.source_system_reference

Line 1155: UPDATE bom_bill_of_mtls_interface

1151:
1152: ELSE
1153: write_debug('Updating the header x-refs ');
1154:
1155: UPDATE bom_bill_of_mtls_interface
1156: SET assembly_item_id = l_item_id_table(i),
1157: organization_id = l_org_id_table(i),
1158: item_number = l_item_num_table(i)
1159: WHERE batch_id = p_batch_id

Line 1261: FROM bom_bill_of_mtls_interface BBMI,mtl_system_items_interface MSII

1257: l_request_id NUMBER := nvl(FND_GLOBAL.conc_request_id,-1);
1258: CURSOR Process_Header
1259: IS
1260: SELECT MSII.inventory_item_id,MSII.organization_id,MSII.source_system_reference,MSII.item_number
1261: FROM bom_bill_of_mtls_interface BBMI,mtl_system_items_interface MSII
1262: WHERE BBMI.batch_id = p_batch_id
1263: AND (BBMI.process_flag = 1 OR BBMI.process_flag = 5)
1264: AND MSII.set_process_id = BBMI.batch_id
1265: AND MSII.process_flag IN (0,1,7)

Line 1321: UPDATE bom_bill_of_mtls_interface

1317: x_return_status := FND_API.G_RET_STS_ERROR;
1318: ELSE
1319: write_debug('Updating the Header matches ');
1320:
1321: UPDATE bom_bill_of_mtls_interface
1322: SET assembly_item_id = l_item_id_table(i),
1323: Organization_id = l_org_id_table(i),
1324: item_number = l_item_num_table(i),
1325: bill_sequence_id = null,

Line 1448: FROM bom_bill_of_mtls_interface BBMI

1444:
1445: CURSOR Get_Header(l_batch_id IN NUMBER)
1446: IS
1447: 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
1448: FROM bom_bill_of_mtls_interface BBMI
1449: WHERE batch_id = l_batch_id
1450: AND process_flag NOT IN(3,7,-1);
1451:
1452: CURSOR Process_Header(l_batch_id IN NUMBER,l_item_id IN NUMBER,l_org_id IN NUMBER,l_name IN VARCHAR2)

Line 1455: FROM bom_bill_of_mtls_interface BBMI,

1451:
1452: CURSOR Process_Header(l_batch_id IN NUMBER,l_item_id IN NUMBER,l_org_id IN NUMBER,l_name IN VARCHAR2)
1453: IS
1454: SELECT BSB.bill_sequence_id,BSB.effectivity_control,BSB.organization_id
1455: FROM bom_bill_of_mtls_interface BBMI,
1456: bom_Structures_b BSB
1457: WHERE BBMI.batch_id = l_batch_id
1458: AND process_flag NOT IN(3,7,-1)
1459: AND BSB.assembly_item_id = l_item_id

Line 1707: UPDATE bom_bill_of_mtls_interface

1703: -- AND transaction_id = l_comp_table(j).transaction_id;
1704: -- END IF;
1705: END LOOP;
1706:
1707: UPDATE bom_bill_of_mtls_interface
1708: SET transaction_type = l_txn_table(i),
1709: Bill_sequence_id = l_bill_seq_id,
1710: assembly_item_id = l_item_id_table(i)
1711: WHERE batch_id = p_batch_id

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

1766:
1767: TYPE var_type IS TABLE OF VARCHAR2(50);
1768: TYPE num_type IS TABLE OF NUMBER;
1769:
1770: TYPE bom_intf_header IS TABLE OF Bom_Bill_of_Mtls_Interface%ROWTYPE;
1771: TYPE bom_intf_comp IS TABLE OF Bom_Inventory_Comps_Interface%ROWTYPE;
1772: TYPE batch_options IS TABLE OF Ego_Import_Option_Sets%ROWTYPE;
1773:
1774: l_header_table bom_intf_header;

Line 1844: bom_bill_of_mtls_interface BBMI,

1840: BBMI.ITEM_NUMBER,
1841: UPPER(BBMI.TRANSACTION_TYPE),
1842: BBMI.ITEM_DESCRIPTION
1843: FROM
1844: bom_bill_of_mtls_interface BBMI,
1845: ego_import_batches_b EIBB
1846: WHERE
1847: BBMI.batch_id = l_batch_id
1848: AND EIBB.batch_id = BBMI.batch_id

Line 3822: bom_bill_of_mtls_interface

3818: FOR iicr IN Item_Intf_ReadyCr
3819: LOOP --iicr cursor loop start
3820: -- Update Bill of materials for Unconfirmed and Excluded
3821: UPDATE
3822: bom_bill_of_mtls_interface
3823: SET
3824: process_flag = 1
3825: WHERE
3826: batch_id = p_batch_id

Line 3832: bom_bill_of_mtls_interface bmi

3828: AND process_flag = 0;
3829:
3830: -- Update Bill of materials for Unconfirmed Children
3831: UPDATE
3832: bom_bill_of_mtls_interface bmi
3833: SET
3834: process_flag = 1
3835: WHERE
3836: bmi.batch_id = p_batch_id

Line 3864: bom_bill_of_mtls_interface

3860: FOR iicr IN Item_Intf_NotReadyCr
3861: LOOP --iicr cursor loop start
3862: -- Update Bill of materials for Unconfirmed and Excluded
3863: UPDATE
3864: bom_bill_of_mtls_interface
3865: SET
3866: process_flag = 0
3867: WHERE
3868: batch_id = p_batch_id

Line 3874: bom_bill_of_mtls_interface bmi

3870: AND process_flag = 1;
3871:
3872: -- Update Bill of materials for Unconfirmed Children
3873: UPDATE
3874: bom_bill_of_mtls_interface bmi
3875: SET
3876: process_flag = 0
3877: WHERE
3878: bmi.batch_id = p_batch_id

Line 4059: FROM bom_bill_of_mtls_interface

4055:
4056: CURSOR Get_Header(p_batch_id IN NUMBER)
4057: IS
4058: SELECT assembly_item_id,organization_id,bill_sequence_id,alternate_bom_designator,item_number,organization_code
4059: FROM bom_bill_of_mtls_interface
4060: WHERE batch_id = p_batch_id
4061: --AND (process_flag = 1 OR process_flag = 5)
4062: AND (assembly_item_id IS NOT NULL OR item_number IS NOT NULL);
4063:

Line 4070: bom_bill_of_mtls_interface BBMI

4066: SELECT BICI.component_item_id,BICI.organization_id,BICI.bill_sequence_id,BBMI.assembly_item_id,decode(BICI.operation_seq_num,null,
4067: BICI.new_operation_seq_num,BICI.operation_seq_num),decode(BICI.effectivity_date,null,BICI.new_effectivity_date,BICI.effectivity_date),
4068: BICI.component_item_number,BICI.assembly_item_number,BICI.organization_code,BICI.component_sequence_id
4069: FROM bom_inventory_comps_interface BICI,
4070: bom_bill_of_mtls_interface BBMI
4071: WHERE BBMI.batch_id = p_batch_id
4072: AND BICI.batch_id = BBMI.batch_id
4073: --AND (BBMI.process_flag = 1 OR BBMI.process_flag = 5)
4074: --AND (BICI.process_flag = 1 OR BICI.process_flag = 5)

Line 4151: UPDATE bom_bill_of_mtls_interface

4147:
4148: Write_Debug('Updating the Header with Ids');
4149:
4150: IF pG_batch_options.PDH_BATCH = 'Y' THEN
4151: UPDATE bom_bill_of_mtls_interface
4152: SET source_system_reference = l_head_name_table(i),
4153: item_number = l_head_name_table(i),
4154: assembly_item_id = l_head_item_id_table(i),
4155: organization_id = l_org_id_table(i)

Line 4161: UPDATE bom_bill_of_mtls_interface

4157: AND NVL(alternate_bom_designator,'Primary') = NVL(l_alt_desg_table(i),'Primary')
4158: --AND (process_flag = 1 OR process_flag = 5)
4159: AND batch_id = p_batch_id;
4160: ELSE
4161: UPDATE bom_bill_of_mtls_interface
4162: SET item_number = l_head_name_table(i),
4163: assembly_item_id = l_head_item_id_table(i),
4164: organization_id = l_org_id_table(i)
4165: 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 4361: UPDATE bom_bill_of_mtls_interface

4357: AND source_system_reference = p_ssRef_varray(i);
4358:
4359: --Update the header
4360:
4361: UPDATE bom_bill_of_mtls_interface
4362: SET assembly_item_id = l_item_id
4363: WHERE batch_id = p_batch_id
4364: AND source_system_reference = p_ssRef_varray(i);
4365:

Line 4415: FROM bom_bill_of_mtls_interface

4411:
4412: CURSOR Get_Bill_Seq_Id
4413: IS
4414: SELECT bill_sequence_id
4415: FROM bom_bill_of_mtls_interface
4416: WHERE batch_id = p_batch_id;
4417:
4418: CURSOR Get_Change_Option
4419: IS

Line 4454: UPDATE Bom_Bill_Of_Mtls_Interface

4450: l_change_flag := 'Y';
4451: END IF;
4452: IF l_change_flag = 'Y' THEN
4453: --Update the Header rows with process flag = 5
4454: UPDATE Bom_Bill_Of_Mtls_Interface
4455: SET process_flag = 5
4456: WHERE batch_id = p_batch_id
4457: AND bill_sequence_id = l_bill_seq_table(i);
4458:

Line 4513: FROM bom_bill_of_mtls_interface BBMI

4509: CURSOR Get_Header(l_batch_id IN NUMBER)
4510: IS
4511: SELECT
4512: BBMI.assembly_item_id,BBMI.organization_id,BBMI.alternate_bom_designator,BBMI.source_system_reference,UPPER(BBMI.transaction_type),request_id,bundle_id
4513: FROM bom_bill_of_mtls_interface BBMI
4514: WHERE batch_id = l_batch_id
4515: AND process_flag NOT IN (3,7,-1,0);
4516:
4517: CURSOR Process_Header(l_batch_id IN NUMBER,l_item_id IN NUMBER,l_org_id IN NUMBER,l_name IN VARCHAR2)

Line 4522: bom_bill_of_mtls_interface BBMI,

4518: IS
4519: SELECT
4520: BSB.bill_sequence_id,BSB.effectivity_control,BSB.organization_id
4521: FROM
4522: bom_bill_of_mtls_interface BBMI,
4523: bom_Structures_b BSB
4524: WHERE
4525: BBMI.batch_id = l_batch_id
4526: AND BBMI.process_flag NOT IN (3,7,-1,0)

Line 5138: DELETE bom_bill_of_mtls_interface

5134:
5135: stmt_num := 1;
5136: Write_Debug('Deleting the header rows');
5137:
5138: DELETE bom_bill_of_mtls_interface
5139: WHERE batch_id = p_batch_id;
5140:
5141: stmt_num := 2;
5142: Write_Debug('Deleting the component rows');

Line 5757: FROM bom_bill_of_mtls_interface

5753: IS
5754: CURSOR Get_Header
5755: IS
5756: SELECT *
5757: FROM bom_bill_of_mtls_interface
5758: WHERE batch_id = p_batch_id
5759: AND process_flag = 1;
5760:
5761: TYPE bom_header_type IS TABLE OF bom_bill_of_mtls_interface%ROWTYPE;

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

5757: FROM bom_bill_of_mtls_interface
5758: WHERE batch_id = p_batch_id
5759: AND process_flag = 1;
5760:
5761: TYPE bom_header_type IS TABLE OF bom_bill_of_mtls_interface%ROWTYPE;
5762: l_header_table bom_header_type;
5763: l_str_chng_policy VARCHAR2(50);
5764: l_count NUMBER;
5765: l_rev_id NUMBER;

Line 5775: UPDATE bom_bill_of_mtls_interface

5771: THEN
5772: IF nvl(pG_batch_options.ADD_ALL_TO_CHANGE_FLAG,'N') = 'Y' THEN
5773: -- Only for header setting the process flag to 5 even for already
5774: -- process_flag = 7 records for bug 4686771
5775: UPDATE bom_bill_of_mtls_interface
5776: SET process_flag = 5
5777: --pending_from_ecn = nvl(pending_from_ecn,pG_batch_options.CHANGE_NOTICE) we need not do this
5778: WHERE batch_id = p_batch_id
5779: AND (process_flag = 1 OR process_flag = 7);

Line 5834: UPDATE bom_bill_of_mtls_interface

5830: l_header_table(i).structure_type_id);
5831: END IF;
5832:
5833: IF l_str_chng_policy = 'CHANGE_ORDER_REQUIRED' THEN
5834: UPDATE bom_bill_of_mtls_interface
5835: SET process_flag = 5
5836: WHERE batch_id = p_batch_id
5837: AND (process_flag = 1 OR process_flag = 7)
5838: AND interface_table_unique_id = l_header_table(i).interface_table_unique_id;