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_INVENTORY_COMPS_INTERFACE

Line 338: BOM_INVENTORY_COMPS_INTERFACE

334: and batch_id = p_batch_id
335: and process_flag = 1;
336:
337: update
338: BOM_INVENTORY_COMPS_INTERFACE
339: set
340: transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
341: where
342: transaction_id is null

Line 408: UPDATE bom_inventory_comps_interface

404: WHERE batch_id = p_batch_id
405: AND (process_flag = 1 OR process_flag = 5);
406: -- AND alternate_bom_designator IS NOT NULL;
407:
408: UPDATE bom_inventory_comps_interface
409: SET alternate_bom_designator = pg_batch_options.structure_name
410: WHERE batch_id = p_batch_id
411: AND ( process_flag = 1 OR process_flag = 5);
412: -- AND alternate_bom_designator IS NOT NULL;

Line 450: bom_inventory_comps_interface

446: AND EFFECTIVITY_CONTROL is NULL;
447:
448: IF (pg_batch_options.EFFECTIVITY_DATE IS NOT NULL) THEN
449: UPDATE
450: bom_inventory_comps_interface
451: SET
452: EFFECTIVITY_DATE = pg_batch_options.EFFECTIVITY_DATE
453: WHERE
454: EFFECTIVITY_DATE IS NULL

Line 470: bom_inventory_comps_interface

466: AND (process_flag = 1 OR process_flag = 5)
467: AND EFFECTIVITY_CONTROL is NULL;
468: IF (pg_batch_options.FROM_END_ITEM_UNIT_NUMBER IS NOT NULL) THEN
469: UPDATE
470: bom_inventory_comps_interface
471: SET
472: FROM_END_ITEM_UNIT_NUMBER = pg_batch_options.FROM_END_ITEM_UNIT_NUMBER
473: WHERE
474: FROM_END_ITEM_UNIT_NUMBER IS NULL

Line 615: bom_inventory_comps_interface

611: component_item_id,
612: new_operation_seq_num,
613: new_effectivity_date
614: FROM
615: bom_inventory_comps_interface
616: WHERE
617: batch_id = p_batch_id AND comp_source_system_reference = p_comp_rec_id;*
618: FETCH l_src_attrs INTO l_comp_id,l_op_seq_num,l_effec_date;
619: CLOSE l_src_attrs;*/

Line 624: FROM bom_components_b BCB,bom_inventory_comps_interface BICI

620: BEGIN
621:
622: SELECT BCB.component_sequence_id
623: INTO l_comp_seq_id
624: FROM bom_components_b BCB,bom_inventory_comps_interface BICI
625: WHERE BICI.batch_id = p_batch_id
626: AND (BICI.comp_source_system_reference = p_comp_rec_id OR BICI.component_item_number = p_comp_rec_id)
627: AND (BICI.process_flag = 1 or BICI.process_flag = 5 )
628: AND BCB.bill_sequence_id = p_bill_seq_id

Line 642: FROM bom_inventory_comps_interface

638: NULL;
639: END;
640: ELSIF p_effec_control = 2 THEN
641: /*OPEN l_src_attrs FOR SELECT component_item_id,operation_seq_num,from_end_item_unit_number
642: FROM bom_inventory_comps_interface
643: WHERE batch_id = p_batch_id AND comp_source_system_reference = p_comp_rec_id;
644: FETCH l_src_attrs INTO l_comp_id,l_op_seq_num,l_from_unit_number;
645: CLOSE l_src_attrs;*/
646: BEGIN

Line 649: FROM bom_components_b BCB,bom_inventory_comps_interface BICI

645: CLOSE l_src_attrs;*/
646: BEGIN
647: SELECT BCB.component_sequence_id
648: INTO l_comp_seq_id
649: FROM bom_components_b BCB,bom_inventory_comps_interface BICI
650: WHERE BICI.batch_id = p_batch_id
651: AND (BICI.comp_source_system_reference = p_comp_rec_id OR BICI.component_item_number = p_comp_rec_id)
652: AND (BICI.process_flag = 1 or BICI.process_flag = 5 )
653: AND BCB.bill_sequence_id = p_bill_seq_id

Line 668: FROM bom_components_b BCB,bom_inventory_comps_interface BICI,Mtl_Item_Revisions MIR

664: ELSIF p_effec_control = 4 THEN
665: BEGIN
666: SELECT BCB.component_sequence_id
667: INTO l_comp_seq_id
668: FROM bom_components_b BCB,bom_inventory_comps_interface BICI,Mtl_Item_Revisions MIR
669: WHERE BICI.batch_id = p_batch_id
670: AND (BICI.comp_source_system_reference = p_comp_rec_id OR BICI.component_item_number = p_comp_rec_id)
671: AND (BICI.process_flag = 1 or BICI.process_flag = 5 )
672: AND BCB.bill_sequence_id = p_bill_seq_id

Line 957: FROM bom_inventory_comps_interface BICI,mtl_cross_references MCR,ego_import_batches_b EIBB,mtl_system_items MSI

953:
954: CURSOR Process_Comp(l_batch_id IN NUMBER)
955: IS
956: SELECT MCR.inventory_item_id,MCR.organization_id,BICI.comp_source_system_reference,MSI.segment1
957: FROM bom_inventory_comps_interface BICI,mtl_cross_references MCR,ego_import_batches_b EIBB,mtl_system_items MSI
958: WHERE BICI.batch_id = l_batch_id
959: AND EIBB.batch_id = BICI.batch_id
960: AND MCR.source_system_id = EIBB.source_system_id
961: AND MCR.cross_reference = BICI.comp_source_system_reference

Line 971: FROM bom_inventory_comps_interface BICI,mtl_cross_references MCR,ego_import_batches_b EIBB,mtl_system_items MSI

967:
968: CURSOR Process_Header_For_Comp
969: IS
970: SELECT MCR.inventory_item_id,MCR.organization_id,BICI.comp_source_system_reference,MSI.segment1
971: FROM bom_inventory_comps_interface BICI,mtl_cross_references MCR,ego_import_batches_b EIBB,mtl_system_items MSI
972: WHERE BICI.batch_id = p_batch_id
973: AND EIBB.batch_id = BICI.batch_id
974: AND MCR.source_system_id = EIBB.source_system_id
975: AND MCR.cross_reference = BICI.parent_source_system_reference

Line 1045: UPDATE bom_inventory_comps_interface

1041: x_return_status := FND_API.G_RET_STS_ERROR;
1042: ELSE
1043: write_debug('Updating the component x-refs ');
1044:
1045: UPDATE bom_inventory_comps_interface
1046: SET component_item_id = l_item_id_table(i),
1047: organization_id = l_org_id_table(i),
1048: component_item_number = l_item_num_table(i)
1049: WHERE batch_id = p_batch_id

Line 1062: UPDATE bom_inventory_comps_interface

1058:
1059: l_count := l_ss_record_table.COUNT;
1060:
1061: FOR i in 1..l_count LOOP
1062: UPDATE bom_inventory_comps_interface
1063: SET assembly_item_id = l_item_id_table(i),
1064: organization_id = l_org_id_table(i),
1065: assembly_item_number = l_item_num_table(i)
1066: WHERE batch_id = p_batch_id

Line 1132: FROM bom_inventory_comps_interface BICI,mtl_system_items_interface MSII

1128:
1129: CURSOR Process_Comp
1130: IS
1131: SELECT MSII.inventory_item_id,MSII.organization_id,MSII.source_system_reference,MSII.item_number
1132: FROM bom_inventory_comps_interface BICI,mtl_system_items_interface MSII
1133: WHERE BICI.batch_id = p_batch_id
1134: AND (BICI.process_flag = 1 OR BICI.process_flag = 5)
1135: AND MSII.set_process_id = BICI.batch_id
1136: AND MSII.process_flag IN (0,1,7)

Line 1144: FROM bom_inventory_comps_interface BICI,mtl_system_items_interface MSII

1140:
1141: Cursor Process_Header_For_Comp
1142: IS
1143: SELECT MSII.inventory_item_id,MSII.organization_id,MSII.source_system_reference,MSII.item_number
1144: FROM bom_inventory_comps_interface BICI,mtl_system_items_interface MSII
1145: WHERE BICI.batch_id = p_batch_id
1146: AND (BICI.process_flag = 1 OR BICI.process_flag = 5)
1147: AND MSII.set_process_id = BICI.batch_id
1148: AND MSII.process_flag IN (0,1,7)

Line 1213: UPDATE bom_inventory_comps_interface

1209: );
1210: x_return_status := FND_API.G_RET_STS_ERROR;
1211: ELSE
1212: write_debug('Updating the Component Matches');
1213: UPDATE bom_inventory_comps_interface
1214: SET component_item_id = l_item_id_table(i),
1215: Organization_id = l_org_id_table(i),
1216: component_item_number = l_item_num_table(i)
1217: WHERE batch_id = p_batch_id

Line 1230: UPDATE bom_inventory_comps_interface

1226:
1227: l_count := l_ss_record_table.COUNT;
1228: FOR i in 1..l_count LOOP
1229: write_debug('Updating the Header matches in Component');
1230: UPDATE bom_inventory_comps_interface
1231: SET assembly_item_id = l_item_id_table(i),
1232: Organization_id = l_org_id_table(i),
1233: assembly_item_number = l_item_num_table(i)
1234: WHERE batch_id = p_batch_id

Line 1273: TYPE bom_comp_intf_type IS TABLE OF bom_inventory_comps_interface%ROWTYPE;

1269: )
1270: IS
1271:
1272:
1273: TYPE bom_comp_intf_type IS TABLE OF bom_inventory_comps_interface%ROWTYPE;
1274: TYPE bom_comp_type IS TABLE OF bom_components_b%ROWTYPE;
1275: TYPE num_type IS TABLE OF NUMBER;
1276: TYPE var_type IS TABLE OF VARCHAR2(1000);
1277:

Line 1325: FROM bom_inventory_comps_interface BICI

1321:
1322: CURSOR Process_Comp(l_batch_id IN NUMBER,p_parent_reference IN VARCHAR2,l_parent_name IN VARCHAR2)
1323: IS
1324: SELECT *
1325: FROM bom_inventory_comps_interface BICI
1326: WHERE batch_id = l_batch_id
1327: AND process_flag NOT IN(3,7,-1)
1328: AND (parent_source_system_reference = p_parent_reference OR assembly_item_number = l_parent_name);
1329:

Line 1532: UPDATE bom_inventory_comps_interface

1528: FOR j IN 1..l_comp_count
1529: LOOP
1530: write_debug('updating comp -'|| l_comp_table(j).comp_source_system_reference);
1531: write_debug('with parent -'|| l_comp_table(j).parent_source_system_reference);
1532: UPDATE bom_inventory_comps_interface
1533: SET bill_sequence_id = l_comp_table(j).bill_sequence_id ,
1534: transaction_type = l_comp_table(j).transaction_type,
1535: component_sequence_id = l_comp_table(j).component_sequence_id,
1536: old_component_sequence_id = l_comp_table(j).old_component_sequence_id,

Line 1628: TYPE bom_intf_comp IS TABLE OF Bom_Inventory_Comps_Interface%ROWTYPE;

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;
1632: l_comp_table bom_intf_comp;

Line 1727: bom_inventory_comps_interface BICI,

1723: BICI.ORGANIZATION_CODE,
1724: UPPER(BICI.TRANSACTION_TYPE),
1725: BICI.ITEM_DESCRIPTION
1726: FROM
1727: bom_inventory_comps_interface BICI,
1728: ego_import_batches_b EIBB
1729: WHERE
1730: BICI.batch_id = l_batch_id
1731: AND EIBB.batch_id = BICI.batch_id

Line 2208: FROM bom_inventory_comps_interface

2204:
2205: IF p_intf_uniq_id IS NOT NULL THEN
2206: SELECT effectivity_date,new_effectivity_date,disable_date,from_end_item_unit_number,new_from_end_item_unit_number,to_end_item_unit_number,from_end_item_rev_code,to_end_item_rev_code
2207: INTO l_eff_date_intf,l_new_eff_date_intf,l_dis_date_intf,l_from_num_intf ,l_new_from_num_intf,l_to_unit_num_intf,l_from_rev_intf ,l_to_item_rev_intf
2208: FROM bom_inventory_comps_interface
2209: WHERE batch_id = p_batch_id
2210: AND interface_table_unique_id = p_intf_uniq_id;
2211: END IF;
2212:

Line 2476: l_src_query := ' (SELECT * FROM bom_inventory_comps_interface WHERE batch_id = :1 ' ||

2472: END IF;
2473:
2474: IF p_ss_record_id IS NOT NULL
2475: THEN
2476: l_src_query := ' (SELECT * FROM bom_inventory_comps_interface WHERE batch_id = :1 ' ||
2477: ' AND ( (comp_source_system_reference = :2 OR component_item_number = ' || '''' || p_ss_record_id || ''' )' ||
2478: ' AND interface_table_unique_id = ' || p_intf_uniq_id ||
2479: ' AND organization_id = ' || p_org_id ||
2480: ' ) ) src_val ,';

Line 2942: FROM bom_inventory_comps_interface

2938: IF l_comp_seq_id IS NULL THEN
2939:
2940: SELECT component_sequence_id
2941: INTO l_comp_seq_id
2942: FROM bom_inventory_comps_interface
2943: WHERE batch_id = p_batch_id
2944: AND (process_flag = 1 OR process_flag = 5)
2945: AND transaction_id = p_transaction_id;
2946: END IF;

Line 2952: FROM bom_inventory_comps_interface

2948: IF l_bill_seq_id IS NULL THEN
2949:
2950: SELECT bill_sequence_id
2951: INTO l_bill_seq_id
2952: FROM bom_inventory_comps_interface
2953: WHERE batch_id = p_batch_id
2954: AND (process_flag = 1 OR process_flag = 5)
2955: AND transaction_id = p_transaction_id;
2956: END IF;

Line 2962: FROM bom_inventory_comps_interface

2958: IF ( p_transaction_id IS NOT NULL OR p_comp_seq_id IS NOT NULL )THEN
2959:
2960: SELECT component_item_number,assembly_item_number,component_item_id,organization_id,UPPER(transaction_type)
2961: INTO l_comp_name,l_parent_name,l_comp_id,l_org_id,l_txn_type
2962: FROM bom_inventory_comps_interface
2963: WHERE batch_id = p_batch_id
2964: AND (process_flag = 1 or process_flag = 5)
2965: AND (component_sequence_id = p_comp_seq_id OR transaction_id = p_transaction_id);
2966: END IF;

Line 3449: FROM bom_inventory_comps_interface bci

3445: AND bmi.process_flag = 0
3446: AND bmi.source_system_reference =
3447: ( SELECT DISTINCT
3448: bci.parent_source_system_reference
3449: FROM bom_inventory_comps_interface bci
3450: WHERE
3451: bci.batch_id = p_batch_id
3452: AND bci.comp_source_system_reference = iicr.source_system_reference
3453: AND iicr.confirm_status in ('CC','CM','CN'));

Line 3456: bom_inventory_comps_interface

3452: AND bci.comp_source_system_reference = iicr.source_system_reference
3453: AND iicr.confirm_status in ('CC','CM','CN'));
3454: -- Update Components for Unconfirmed and Excluded
3455: UPDATE
3456: bom_inventory_comps_interface
3457: SET
3458: process_flag = 1
3459: WHERE
3460: batch_id = p_batch_id

Line 3491: FROM bom_inventory_comps_interface bci

3487: AND bmi.process_flag = 1
3488: AND bmi.source_system_reference =
3489: ( SELECT DISTINCT
3490: bci.parent_source_system_reference
3491: FROM bom_inventory_comps_interface bci
3492: WHERE
3493: bci.batch_id = p_batch_id
3494: AND bci.comp_source_system_reference = iicr.source_system_reference
3495: AND iicr.confirm_status in ('US','UM','UN'));

Line 3498: bom_inventory_comps_interface

3494: AND bci.comp_source_system_reference = iicr.source_system_reference
3495: AND iicr.confirm_status in ('US','UM','UN'));
3496: -- Update Components for Unconfirmed and Excluded
3497: UPDATE
3498: bom_inventory_comps_interface
3499: SET
3500: process_flag = 0
3501: WHERE
3502: batch_id = p_batch_id

Line 3677: FROM bom_inventory_comps_interface BICI,

3673: IS
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)

Line 3848: UPDATE bom_inventory_comps_interface

3844: Write_Debug('Updating the Comps-- ' ||l_comp_name_table(i) );
3845: Write_Debug('With Parent -- ' || l_head_name_table(i));
3846:
3847: IF pG_batch_options.PDH_BATCH = 'Y' THEN
3848: UPDATE bom_inventory_comps_interface
3849: SET comp_source_system_reference = l_comp_name_table(i),
3850: parent_source_system_reference = l_head_name_table(i),
3851: component_item_number = l_comp_name_table(i),
3852: component_item_id = l_comp_item_id_table(i),

Line 3863: UPDATE bom_inventory_comps_interface

3859: --AND new_operation_seq_num = l_op_seq_table(i)
3860: --AND new_effectivity_date = l_effectivity_table(i)
3861: AND batch_id = p_batch_id;
3862: ELSE
3863: UPDATE bom_inventory_comps_interface
3864: SET component_item_number = l_comp_name_table(i),
3865: component_item_id = l_comp_item_id_table(i),
3866: assembly_item_number = l_head_name_table(i),
3867: assembly_item_id = l_head_item_id_table(i),

Line 3976: UPDATE bom_inventory_comps_interface BICI

3972: AND source_system_reference = p_ssRef_varray(i);
3973:
3974: -- Update the comps
3975:
3976: UPDATE bom_inventory_comps_interface BICI
3977: SET component_item_id = l_item_id
3978: WHERE batch_id = p_batch_id
3979: AND comp_source_system_reference = p_ssRef_varray(i);
3980:

Line 4068: UPDATE Bom_Inventory_Comps_Interface

4064: WHERE batch_id = p_batch_id
4065: AND bill_sequence_id = l_bill_seq_table(i);
4066:
4067: -- Update the direct Component rows with process Flag = 5
4068: UPDATE Bom_Inventory_Comps_Interface
4069: SET Process_Flag = 5
4070: WHERE batch_id = p_batch_id
4071: AND bill_sequence_id = l_bill_seq_table(i);
4072: END IF;

Line 4084: TYPE bom_comp_intf_type IS TABLE OF bom_inventory_comps_interface%ROWTYPE;

4080: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
4081: , x_Return_Status IN OUT NOCOPY VARCHAR2
4082: )
4083: IS
4084: TYPE bom_comp_intf_type IS TABLE OF bom_inventory_comps_interface%ROWTYPE;
4085: TYPE bom_comp_type IS TABLE OF bom_components_b%ROWTYPE;
4086: TYPE num_type IS TABLE OF NUMBER;
4087: TYPE var_type IS TABLE OF VARCHAR2(1000);
4088: l_err_text VARCHAR2(1000);

Line 4142: FROM bom_inventory_comps_interface BICI

4138:
4139: CURSOR Process_Comp(l_batch_id IN NUMBER,p_parent_reference IN VARCHAR2)
4140: IS
4141: SELECT *
4142: FROM bom_inventory_comps_interface BICI
4143: WHERE batch_id = l_batch_id
4144: AND process_flag NOT IN(3,7,0,-1)
4145: AND parent_source_system_reference = p_parent_reference;
4146:

Line 4288: bom_inventory_comps_interface

4284:
4285: FOR m in 1..l_unmatch_count LOOP
4286: IF l_unmatch_comp(m).disable_date IS NULL OR (l_unmatch_comp(m).disable_date IS NOT NULL AND l_unmatch_comp(m).disable_date > sysdate) THEN
4287: INSERT INTO
4288: bom_inventory_comps_interface
4289: (
4290: component_item_id,
4291: organization_id,
4292: component_sequence_id,

Line 4425: bom_inventory_comps_interface

4421: LOOP
4422: IF l_comp_pdh_table(k).bill_sequence_id <> 0 THEN
4423: write_debug('inserting delete for comp --' ||l_comp_pdh_table(k).component_item_id );
4424: INSERT INTO
4425: bom_inventory_comps_interface
4426: (
4427: component_item_id,
4428: organization_id,
4429: component_sequence_id,

Line 4487: bom_inventory_comps_interface

4483:
4484: FOR m in 1..l_unmatch_count LOOP
4485: IF l_unmatch_comp(m).disable_date IS NULL OR (l_unmatch_comp(m).disable_date IS NOT NULL AND l_unmatch_comp(m).disable_date > sysdate) THEN
4486: INSERT INTO
4487: bom_inventory_comps_interface
4488: (
4489: component_item_id,
4490: organization_id,
4491: component_sequence_id,

Line 4612: bom_inventory_comps_interface

4608: write_debug('before inserting the delete rows second');
4609: IF l_not_exist AND (l_comp_pdh_table(j).disable_date IS NULL OR (l_comp_pdh_table(j).disable_date IS NOT NULL AND l_comp_pdh_table(j).disable_date > sysdate)) THEN
4610: write_debug('inserting delete for comp --' ||l_comp_pdh_table(j).component_item_id );
4611: INSERT INTO
4612: bom_inventory_comps_interface
4613: (
4614: component_item_id,
4615: organization_id,
4616: component_sequence_id,

Line 4662: UPDATE bom_inventory_comps_interface

4658: END IF;
4659:
4660: l_comp_count := l_comp_table.COUNT;
4661: FOR i in 1..l_comp_count LOOP
4662: UPDATE bom_inventory_comps_interface
4663: SET component_sequence_id = l_comp_table(i).component_sequence_id,
4664: transaction_type = UPPER(l_comp_table(i).transaction_type)
4665: WHERE batch_id = p_batch_id
4666: AND (process_flag = 1 OR process_flag = 5)

Line 4752: Delete bom_inventory_comps_interface

4748:
4749: stmt_num := 2;
4750: Write_Debug('Deleting the component rows');
4751:
4752: Delete bom_inventory_comps_interface
4753: WHERE batch_id = p_batch_id;
4754:
4755: stmt_num := 3;
4756: Write_Debug('Deleting the Ref Desgs interface');

Line 4829: TYPE bom_comp_intf_type IS TABLE OF bom_inventory_comps_interface%ROWTYPE;

4825: x_Ret_Status IN OUT NOCOPY VARCHAR2,
4826: x_Error_Mesg IN OUT NOCOPY VARCHAR2
4827: )
4828: IS
4829: TYPE bom_comp_intf_type IS TABLE OF bom_inventory_comps_interface%ROWTYPE;
4830: l_comp_table bom_comp_intf_type;
4831: l_merge_comp bom_comp_intf_type;
4832: l_count NUMBER;
4833: l_merge_count NUMBER;

Line 4854: FROM bom_inventory_comps_interface

4850: l_txn_type IN VARCHAR2
4851: )
4852: IS
4853: SELECT *
4854: FROM bom_inventory_comps_interface
4855: WHERE batch_id = p_batch_id
4856: AND ( component_sequence_id = l_comp_seq
4857: OR (component_sequence_id is NULL
4858: AND ( (component_item_number = l_comp_name OR comp_source_system_reference = l_comp_ref)

Line 4875: FROM bom_inventory_comps_interface

4871:
4872: CURSOR Get_Comp
4873: IS
4874: SELECT *
4875: FROM bom_inventory_comps_interface
4876: WHERE batch_id = p_batch_id
4877: AND process_flag = 1;
4878:
4879: BEGIN

Line 5032: UPDATE bom_inventory_comps_interface

5028:
5029: l_merge_comp(j).process_flag := -1;
5030: END LOOP; -- merge table loop
5031:
5032: UPDATE bom_inventory_comps_interface
5033: SET operation_seq_num = l_merge_comp(1).operation_seq_num,
5034: new_operation_seq_num = l_merge_comp(1).new_operation_seq_num,
5035: basis_type = l_merge_comp(1).basis_type,
5036: component_quantity = l_merge_comp(1).component_quantity,

Line 5071: UPDATE bom_inventory_comps_interface

5067: unit_price = l_merge_comp(1).unit_price
5068: WHERE batch_id = p_batch_id
5069: AND interface_table_unique_id = l_merge_comp(1).interface_table_unique_id;
5070:
5071: UPDATE bom_inventory_comps_interface
5072: SET process_flag = -1
5073: WHERE batch_id = p_batch_id
5074: AND ( component_sequence_id = l_merge_comp(1).component_sequence_id
5075: OR ( component_sequence_id IS NULL

Line 5389: UPDATE bom_inventory_comps_interface

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);
5388:
5389: UPDATE bom_inventory_comps_interface
5390: SET process_flag = 5
5391: --change_notice = nvl(change_notice,pG_batch_options.CHANGE_NOTICE) we need not do this
5392: WHERE batch_id = p_batch_id
5393: AND process_flag = 1;

Line 5449: UPDATE bom_inventory_comps_interface

5445: AND (process_flag = 1 OR process_flag = 7)
5446: AND interface_table_unique_id = l_header_table(i).interface_table_unique_id;
5447:
5448:
5449: UPDATE bom_inventory_comps_interface
5450: SET process_flag = 5
5451: WHERE batch_id = p_batch_id
5452: AND process_flag = 1
5453: AND ( bill_sequence_id = l_header_table(i).bill_sequence_id