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_COMPONENTS_B

Line 631: FROM bom_components_b BCB,bom_inventory_comps_interface BICI

627: BEGIN
628:
629: SELECT BCB.component_sequence_id
630: INTO l_comp_seq_id
631: FROM bom_components_b BCB,bom_inventory_comps_interface BICI
632: WHERE BICI.batch_id = p_batch_id
633: AND (BICI.comp_source_system_reference = p_comp_rec_id OR BICI.component_item_number = p_comp_rec_id)
634: AND (BICI.process_flag = 1 or BICI.process_flag = 5 )
635: AND BCB.bill_sequence_id = p_bill_seq_id

Line 656: FROM bom_components_b BCB,bom_inventory_comps_interface BICI

652: CLOSE l_src_attrs;*/
653: BEGIN
654: SELECT BCB.component_sequence_id
655: INTO l_comp_seq_id
656: FROM bom_components_b BCB,bom_inventory_comps_interface BICI
657: WHERE BICI.batch_id = p_batch_id
658: AND (BICI.comp_source_system_reference = p_comp_rec_id OR BICI.component_item_number = p_comp_rec_id)
659: AND (BICI.process_flag = 1 or BICI.process_flag = 5 )
660: AND BCB.bill_sequence_id = p_bill_seq_id

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

671: ELSIF p_effec_control = 4 THEN
672: BEGIN
673: SELECT BCB.component_sequence_id
674: INTO l_comp_seq_id
675: FROM bom_components_b BCB,bom_inventory_comps_interface BICI,Mtl_Item_Revisions MIR
676: WHERE BICI.batch_id = p_batch_id
677: AND (BICI.comp_source_system_reference = p_comp_rec_id OR BICI.component_item_number = p_comp_rec_id)
678: AND (BICI.process_flag = 1 or BICI.process_flag = 5 )
679: AND BCB.bill_sequence_id = p_bill_seq_id

Line 726: FROM bom_components_b BCB,bom_inventory_comps_interface BICI

722: -- we should check if the component with sysdate as effective date exists or not.
723: IF UPPER(p_transaction_type) IN ('ADD','CREATE') THEN
724: SELECT BCB.component_sequence_id
725: INTO l_comp_seq_id
726: FROM bom_components_b BCB,bom_inventory_comps_interface BICI
727: WHERE BICI.batch_id = p_batch_id
728: AND (BICI.comp_source_system_reference = p_comp_rec_id OR BICI.component_item_number = p_comp_rec_id)
729: AND (BICI.process_flag = 1 or BICI.process_flag = 5 )
730: AND BCB.bill_sequence_id = p_bill_seq_id

Line 741: FROM bom_components_b BCB,bom_inventory_comps_interface BICI

737: OR(pg_batch_options.CHANGE_NOTICE IS NOT NULL AND BCB.implementation_date IS NULL AND BCB.change_notice = pg_batch_options.CHANGE_NOTICE));
738: ELSE
739: SELECT BCB.component_sequence_id
740: INTO l_comp_seq_id
741: FROM bom_components_b BCB,bom_inventory_comps_interface BICI
742: WHERE BICI.batch_id = p_batch_id
743: AND (BICI.comp_source_system_reference = p_comp_rec_id OR BICI.component_item_number = p_comp_rec_id)
744: AND (BICI.process_flag = 1 or BICI.process_flag = 5 )
745: AND BCB.bill_sequence_id = p_bill_seq_id

Line 763: FROM bom_components_b BCB,bom_inventory_comps_interface BICI

759: ELSIF p_effec_control = 2 THEN
760: BEGIN
761: SELECT BCB.component_sequence_id
762: INTO l_comp_seq_id
763: FROM bom_components_b BCB,bom_inventory_comps_interface BICI
764: WHERE BICI.batch_id = p_batch_id
765: AND (BICI.comp_source_system_reference = p_comp_rec_id OR BICI.component_item_number = p_comp_rec_id)
766: AND (BICI.process_flag = 1 or BICI.process_flag = 5 )
767: AND BCB.bill_sequence_id = p_bill_seq_id

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

780: ELSIF p_effec_control = 4 THEN
781: BEGIN
782: SELECT BCB.component_sequence_id
783: INTO l_comp_seq_id
784: FROM bom_components_b BCB,bom_inventory_comps_interface BICI,Mtl_Item_Revisions MIR
785: WHERE BICI.batch_id = p_batch_id
786: AND (BICI.comp_source_system_reference = p_comp_rec_id OR BICI.component_item_number = p_comp_rec_id)
787: AND (BICI.process_flag = 1 or BICI.process_flag = 5 )
788: AND BCB.bill_sequence_id = p_bill_seq_id

Line 1415: TYPE bom_comp_type IS TABLE OF bom_components_b%ROWTYPE;

1411: IS
1412:
1413:
1414: TYPE bom_comp_intf_type IS TABLE OF bom_inventory_comps_interface%ROWTYPE;
1415: TYPE bom_comp_type IS TABLE OF bom_components_b%ROWTYPE;
1416: TYPE num_type IS TABLE OF NUMBER;
1417: TYPE var_type IS TABLE OF VARCHAR2(1000);
1418:
1419: l_err_text VARCHAR2(1000);

Line 1474: FROM Bom_Components_B BCB

1470:
1471: CURSOR Process_Unmatched_Comps(l_bill_seq_id IN NUMBER)
1472: IS
1473: SELECT *
1474: FROM Bom_Components_B BCB
1475: WHERE BCB.bill_sequence_id = l_bill_seq_id;
1476:
1477: BEGIN
1478:

Line 1578: from bom_components_b

1574: IF l_comp_table(j).component_sequence_id IS NOT NULL THEN
1575: BEGIN
1576: SELECT component_item_id
1577: into l_comp_id
1578: from bom_components_b
1579: where component_sequence_id = l_comp_table(j).component_sequence_id;
1580:
1581: IF l_comp_table(j).component_item_id = l_comp_id THEN
1582: l_wrong_comp := false;

Line 2359: from bom_components_b

2355:
2356: IF p_comp_seq_id IS NOT NULL THEN
2357: SELECT effectivity_date,disable_date,from_end_item_unit_number,to_end_item_unit_number,from_end_item_rev_id,to_end_item_rev_id
2358: INTO l_eff_date_pdh,l_dis_date_pdh,l_from_num_pdh,l_to_unit_num_pdh,l_from_rev_pdh,l_to_item_rev_pdh
2359: from bom_components_b
2360: where component_sequence_id = p_comp_seq_id;
2361: END IF;
2362:
2363: l_eff_sql := ' SELECT ' ;

Line 2602: l_pdh_query := ' (SELECT * FROM bom_components_b WHERE component_sequence_id = :3 ) pdh_value' ;

2598:
2599: l_attr_sql1 := SUBSTR(l_attr_sql1,1,LENGTH(l_attr_sql1)-1) || ' ) pdh_attr_value' ;
2600: IF p_comp_seq_id IS NOT NULL
2601: THEN
2602: l_pdh_query := ' (SELECT * FROM bom_components_b WHERE component_sequence_id = :3 ) pdh_value' ;
2603: ELSE
2604: l_pdh_query := '(SELECT ';
2605: FOR attr IN (SELECT * FROM bom_attrs_v)
2606: LOOP

Line 4477: TYPE bom_comp_type IS TABLE OF bom_components_b%ROWTYPE;

4473: , x_Return_Status IN OUT NOCOPY VARCHAR2
4474: )
4475: IS
4476: TYPE bom_comp_intf_type IS TABLE OF bom_inventory_comps_interface%ROWTYPE;
4477: TYPE bom_comp_type IS TABLE OF bom_components_b%ROWTYPE;
4478: TYPE num_type IS TABLE OF NUMBER;
4479: TYPE var_type IS TABLE OF VARCHAR2(1000);
4480: l_err_text VARCHAR2(1000);
4481: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

Line 4543: FROM Bom_Components_B BCB

4539:
4540: CURSOR Process_Unmatched_Comps(l_bill_seq_id IN NUMBER)
4541: IS
4542: SELECT *
4543: FROM Bom_Components_B BCB
4544: WHERE BCB.bill_sequence_id = l_bill_seq_id;
4545:
4546: BEGIN
4547: