[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
969:
970: /* BUGFIX FOR BUG#2310435 */
971: select assembly_item_id
972: into v_top_model_item_id
973: from bom_bill_of_materials
974: where bill_sequence_id = p_top_bill_sequence_id ;
975:
976:
977:
2014:
2015: begin
2016:
2017: select bill_sequence_id into x_bill_sequence_id
2018: from bom_bill_of_materials
2019: where assembly_item_id = p_top_matched_item_id
2020: and organization_id = p_current_org_id ;
2021:
2022: exception
2995: bic.attribute14,
2996: bic.attribute15
2997: FROM bom_inventory_components bic
2998: , bom_inventory_components mod_oc
2999: , bom_bill_of_materials bom
3000: , cz_config_details_v cz
3001: WHERE cz.config_hdr_id = x_cz_config_hdr_id
3002: AND cz.config_rev_nbr = x_cz_config_rev_num
3003: AND mod_oc.component_sequence_id = cz.component_sequence_id
3070: bic.attribute14,
3071: bic.attribute15
3072: FROM bom_inventory_components bic
3073: , bom_inventory_components mod_oc
3074: , bom_bill_of_materials bom
3075: , cz_config_details_v cz
3076: , bom_explosion_temp bet
3077: WHERE cz.config_hdr_id = x_cz_config_hdr_id
3078: AND cz.config_rev_nbr = x_cz_config_rev_num
3140: DECODE(nvl(common_organization_id, organization_id), organization_id,
3141: organization_id, common_organization_id)
3142: INTO l_bill_sequence_id,
3143: l_organization_id
3144: FROM bom_bill_of_materials
3145: WHERE bill_sequence_id = x_top_bill_sequence_id;
3146:
3147: X_Stmt_Num := 10;
3148: