[Home] [Help]
10630: l_primary_comp_item_id,
10631: l_sub_comp_bill_qpa,
10632: l_sub_comp_qpa
10633: FROM bom_bill_of_materials bom,
10634: bom_inventory_components bic,
10635: bom_substitute_components bsc
10636: WHERE bsc.SUBSTITUTE_COMPONENT_ID = v_wsli(v_wlji_src_line_id(v_idx)).inventory_item_id
10637: AND bic.COMPONENT_SEQUENCE_ID = bsc.COMPONENT_SEQUENCE_ID
10638: AND bom.organization_id =v_wlji_org_id(v_idx)
10642: AND bic.effectivity_date <= sysdate and nvl(bic.disable_date,sysdate +1) > sysdate
10643: AND (bic.operation_seq_num = l_start_op_seq_num OR bic.operation_seq_num = 1)
10644: AND bic.item_num = (SELECT min(item_num)
10645: FROM bom_bill_of_materials bom3,
10646: bom_inventory_components bic3,
10647: bom_substitute_components bsc3
10648: WHERE bsc3.SUBSTITUTE_COMPONENT_ID = v_wsli(v_wlji_src_line_id(v_idx)).inventory_item_id
10649: AND bic3.COMPONENT_SEQUENCE_ID = bsc3.COMPONENT_SEQUENCE_ID
10650: AND bom3.organization_id =v_wlji_org_id(v_idx)
10654: AND bic3.effectivity_date <= sysdate
10655: AND nvl(bic3.disable_date,sysdate +1) > sysdate)
10656: AND NOT EXISTS
10657: ( SELECT 1 FROM bom_bill_of_materials bom2,
10658: bom_inventory_components bic2
10659: WHERE bic2.component_item_id = v_wsli(v_wlji_src_line_id(v_idx)).inventory_item_id
10660: AND bom2.organization_id =v_wlji_org_id(v_idx)
10661: AND bic2.bill_sequence_id = bom2.common_bill_sequence_id
10662: AND bom2.common_bill_sequence_id = l_common_bom_seq_id
12763: -- Create the job level copy
12764: --OPTII-PERF:Find if phantom exists or not.
12765: begin
12766: select 1 into v_phantom_exists
12767: from bom_inventory_components
12768: where bill_sequence_id = l_common_bill_seq_id
12769: and p_bom_revision_date between effectivity_date and nvl(disable_date,p_bom_revision_date+1)
12770: and wip_supply_type = 6
12771: and rownum = 1;