APPS.BOMPVALB dependencies on BOM_INVENTORY_COMPONENTS

Line 835: from bom_inventory_components bic

831: and organization_id = org_id;
832:
833: select count(*)
834: into cnt
835: from bom_inventory_components bic
836: where bic.bill_sequence_id = cmn_bom_id
837: and NOT EXISTS
838: (SELECT 'x'
839: FROM MTL_SYSTEM_ITEMS S

Line 941: from bom_inventory_components bic,

937: */
938: if (org_id <> cmn_org_id) then /* Comp and sub comp in production */
939: select count(*)
940: into cnt
941: from bom_inventory_components bic,
942: bom_substitute_components bsc
943: where bic.bill_sequence_id = cmn_bom_id
944: and bic.component_sequence_id = bsc.component_sequence_id
945: and bsc.substitute_component_id not in

Line 977: from bom_inventory_components bic,

973: end if;
974:
975: select count(*) /* Comp in production and sub comp in interface */
976: into cnt
977: from bom_inventory_components bic,
978: bom_sub_comps_interface bsc
979: where bic.bill_sequence_id = cmn_bom_id
980: and bsc.process_flag in (2, 4)
981: and bic.component_sequence_id = bsc.component_sequence_id

Line 2257: from bom_inventory_components

2253: OVERLAP EXCEPTION;
2254: BEGIN
2255: select count(*)
2256: into dummy
2257: from bom_inventory_components
2258: where bill_sequence_id = bom_id
2259: and component_item_id = cmp_id
2260: and operation_seq_num = op_num
2261: and implementation_date is not null

Line 2340: from bom_inventory_components

2336: */
2337: begin
2338: select 1
2339: into dummy
2340: from bom_inventory_components
2341: where component_sequence_id = cmp_seq_id;
2342: if (exist_flag = 1) then
2343: return(0);
2344: else

Line 2430: from bom_inventory_components

2426: BEGIN
2427: begin
2428: select component_sequence_id
2429: into cnt
2430: from bom_inventory_components
2431: where bill_sequence_id = bill_seq_id
2432: and to_char(effectivity_date,'YYYY/MM/DD HH24:MI') = eff_date
2433: and component_item_id = cmp_item_id
2434: and operation_seq_num = op_seq;

Line 2668: from bom_inventory_components bic,

2664: begin
2665: select bbom.organization_id,
2666: bbom.assembly_item_id, bic.bom_item_type
2667: into org_id_dummy, assy_id_dummy, comp_type
2668: from bom_inventory_components bic,
2669: bom_bill_of_materials bbom
2670: where component_sequence_id = c1rec.CSI
2671: and bbom.bill_sequence_id = bic.bill_sequence_id;
2672: goto check_bom_type;

Line 2904: from bom_inventory_components

2900: BEGIN
2901: begin
2902: select QUANTITY_RELATED, COMPONENT_QUANTITY
2903: into qty_flag, cmp_qty
2904: from bom_inventory_components
2905: where component_sequence_id = cmp_seq_id;
2906:
2907: exception
2908: when NO_DATA_FOUND then

Line 3063: from bom_inventory_components bic,

3059: bbom.assembly_type, bic.component_item_id,
3060: bic.bom_item_type
3061: into assy_id_dummy, org_id_dummy,assy_type_dummy,
3062: comp_id_dummy, comp_type
3063: from bom_inventory_components bic,
3064: bom_bill_of_materials bbom
3065: where component_sequence_id = c1rec.CSI
3066: and bbom.bill_sequence_id = bic.bill_sequence_id;
3067: goto check_bom_type;