APPS.BOM_IMPORT_PUB dependencies on BOM_COMPONENTS_B

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 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 1274: TYPE bom_comp_type IS TABLE OF bom_components_b%ROWTYPE;

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:
1278: l_err_text VARCHAR2(1000);

Line 1333: FROM Bom_Components_B BCB

1329:
1330: CURSOR Process_Unmatched_Comps(l_bill_seq_id IN NUMBER)
1331: IS
1332: SELECT *
1333: FROM Bom_Components_B BCB
1334: WHERE BCB.bill_sequence_id = l_bill_seq_id;
1335:
1336: BEGIN
1337:

Line 1437: from bom_components_b

1433: IF l_comp_table(j).component_sequence_id IS NOT NULL THEN
1434: BEGIN
1435: SELECT component_item_id
1436: into l_comp_id
1437: from bom_components_b
1438: where component_sequence_id = l_comp_table(j).component_sequence_id;
1439:
1440: IF l_comp_table(j).component_item_id = l_comp_id THEN
1441: l_wrong_comp := false;

Line 2216: from bom_components_b

2212:
2213: IF p_comp_seq_id IS NOT NULL THEN
2214: 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
2215: 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
2216: from bom_components_b
2217: where component_sequence_id = p_comp_seq_id;
2218: END IF;
2219:
2220: l_eff_sql := ' SELECT ' ;

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

2453:
2454: l_attr_sql1 := SUBSTR(l_attr_sql1,1,LENGTH(l_attr_sql1)-1) || ' ) pdh_attr_value' ;
2455: IF p_comp_seq_id IS NOT NULL
2456: THEN
2457: l_pdh_query := ' (SELECT * FROM bom_components_b WHERE component_sequence_id = :3 ) pdh_value' ;
2458: ELSE
2459: l_pdh_query := '(SELECT ';
2460: FOR attr IN (SELECT * FROM bom_attrs_v)
2461: LOOP

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

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);
4089: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

Line 4151: FROM Bom_Components_B BCB

4147:
4148: CURSOR Process_Unmatched_Comps(l_bill_seq_id IN NUMBER)
4149: IS
4150: SELECT *
4151: FROM Bom_Components_B BCB
4152: WHERE BCB.bill_sequence_id = l_bill_seq_id;
4153:
4154: BEGIN
4155: