[Home] [Help]
610: , bic.component_sequence_id
611: , bic.operation_seq_num
612: , bic.component_item_id
613: FROM bom_inventory_components bic,
614: bom_bill_of_materials bom
615: WHERE -- bic.operation_seq_num = 1 AND /* Changed by Sushant on 19-Aug-2002*/
616: bic.bill_sequence_id = DECODE(bom.common_bill_sequence_id, NULL,
617: bom.bill_sequence_id, bom.common_bill_sequence_id)
618: AND bom.assembly_item_id = p_component_item_id
966:
967: /* BUGFIX FOR BUG#2310435 */
968: select assembly_item_id
969: into v_top_model_item_id
970: from bom_bill_of_materials
971: where bill_sequence_id = p_top_bill_sequence_id ;
972:
973:
974:
2011:
2012: begin
2013:
2014: select bill_sequence_id into x_bill_sequence_id
2015: from bom_bill_of_materials
2016: where assembly_item_id = p_top_matched_item_id
2017: and organization_id = p_current_org_id ;
2018:
2019: exception
2990: bic.attribute14,
2991: bic.attribute15
2992: FROM bom_inventory_components bic
2993: , bom_inventory_components mod_oc
2994: , bom_bill_of_materials bom
2995: , cz_config_details_v cz
2996: WHERE cz.config_hdr_id = x_cz_config_hdr_id
2997: AND cz.config_rev_nbr = x_cz_config_rev_num
2998: AND mod_oc.component_sequence_id = cz.component_sequence_id
3065: bic.attribute14,
3066: bic.attribute15
3067: FROM bom_inventory_components bic
3068: , bom_inventory_components mod_oc
3069: , bom_bill_of_materials bom
3070: , cz_config_details_v cz
3071: , bom_explosion_temp bet
3072: WHERE cz.config_hdr_id = x_cz_config_hdr_id
3073: AND cz.config_rev_nbr = x_cz_config_rev_num
3135: DECODE(nvl(common_organization_id, organization_id), organization_id,
3136: organization_id, common_organization_id)
3137: INTO l_bill_sequence_id,
3138: l_organization_id
3139: FROM bom_bill_of_materials
3140: WHERE bill_sequence_id = x_top_bill_sequence_id;
3141:
3142: X_Stmt_Num := 10;
3143: