[Home] [Help]
10528: l_primary_comp_item_id,
10529: l_sub_comp_bill_qpa,
10530: l_sub_comp_qpa
10531: FROM bom_bill_of_materials bom,
10532: bom_inventory_components bic,
10533: bom_substitute_components bsc
10534: WHERE bsc.SUBSTITUTE_COMPONENT_ID = v_wsli(v_wlji_src_line_id(v_idx)).inventory_item_id
10535: AND bic.COMPONENT_SEQUENCE_ID = bsc.COMPONENT_SEQUENCE_ID
10536: AND bom.organization_id =v_wlji_org_id(v_idx)
10540: AND bic.effectivity_date <= sysdate and nvl(bic.disable_date,sysdate +1) > sysdate
10541: AND (bic.operation_seq_num = l_start_op_seq_num OR bic.operation_seq_num = 1)
10542: AND bic.item_num = (SELECT min(item_num)
10543: FROM bom_bill_of_materials bom3,
10544: bom_inventory_components bic3,
10545: bom_substitute_components bsc3
10546: WHERE bsc3.SUBSTITUTE_COMPONENT_ID = v_wsli(v_wlji_src_line_id(v_idx)).inventory_item_id
10547: AND bic3.COMPONENT_SEQUENCE_ID = bsc3.COMPONENT_SEQUENCE_ID
10548: AND bom3.organization_id =v_wlji_org_id(v_idx)
10552: AND bic3.effectivity_date <= sysdate
10553: AND nvl(bic3.disable_date,sysdate +1) > sysdate)
10554: AND NOT EXISTS
10555: ( SELECT 1 FROM bom_bill_of_materials bom2,
10556: bom_inventory_components bic2
10557: WHERE bic2.component_item_id = v_wsli(v_wlji_src_line_id(v_idx)).inventory_item_id
10558: AND bom2.organization_id =v_wlji_org_id(v_idx)
10559: AND bic2.bill_sequence_id = bom2.common_bill_sequence_id
10560: AND bom2.common_bill_sequence_id = l_common_bom_seq_id
12659: -- Create the job level copy
12660: --OPTII-PERF:Find if phantom exists or not.
12661: begin
12662: select 1 into v_phantom_exists
12663: from bom_inventory_components
12664: where bill_sequence_id = l_common_bill_seq_id
12665: and p_bom_revision_date between effectivity_date and nvl(disable_date,p_bom_revision_date+1)
12666: and wip_supply_type = 6
12667: and rownum = 1;