[Home] [Help]
376: BIC.FROM_END_ITEM_UNIT_NUMBER FUN,
377: BIC.TO_END_ITEM_UNIT_NUMBER TUN
378: FROM
379: BOM_SMALL_IMPL_TEMP BITT,
380: BOM_INVENTORY_COMPONENTS BIC,
381: BOM_BILL_OF_MATERIALS BBM,
382: MTL_SYSTEM_ITEMS MSI
383: where bic.pk1_value = BITT.PARENT_ITEM_ID and
384: bic.pk2_value = NVL(bbm.common_organization_id,bbm.organization_id) and
506: ( c_display_option = 2
507: and
508: bic.effectivity_date =
509: (select max(effectivity_date)
510: from bom_inventory_components bic2
511: where bic2.bill_sequence_id = bic.bill_sequence_id
512: and bic2.component_item_id = bic.component_item_id
513: and NVL(BIC2.ECO_FOR_PRODUCTION,2) = 2
514: and decode(bic.implementation_date, NULL,
520: and trunc(bic2.effectivity_date, 'MI') <=
521: to_date(c_implosion_date,
522: 'YYYY/MM/DD HH24:MI')
523: and NOT EXISTS (SELECT null
524: FROM bom_inventory_components bic3
525: WHERE bic3.bill_sequence_id =
526: bic.bill_sequence_id
527: AND bic3.old_component_sequence_id =
528: bic.component_sequence_id
540: or
541: ( c_display_option = 3
542: and bic.effectivity_date =
543: (select max(effectivity_date)
544: from bom_inventory_components bic2
545: where bic2.bill_sequence_id = bic.bill_sequence_id
546: and bic2.component_item_id = bic.component_item_id
547: and NVL(bic2.ECO_FOR_PRODUCTION,2) = 2
548: and nvl(bic2.old_component_sequence_id,
552: and bic2.effectivity_date <=
553: to_date(c_implosion_date,
554: 'YYYY/MM/DD HH24:MI')
555: and NOT EXISTS (SELECT null
556: FROM bom_inventory_components bic4
557: WHERE bic4.bill_sequence_id =
558: bic.bill_sequence_id
559: AND bic4.old_component_sequence_id =
560: bic.component_sequence_id
1042: BIC.FROM_END_ITEM_UNIT_NUMBER FUN,
1043: BIC.TO_END_ITEM_UNIT_NUMBER TUN
1044: FROM
1045: BOM_SMALL_IMPL_TEMP BITT,
1046: BOM_INVENTORY_COMPONENTS BIC,
1047: BOM_BILL_OF_MATERIALS BBM,
1048: MTL_SYSTEM_ITEMS MSI
1049: where bic.pk1_value = BITT.PARENT_ITEM_ID and
1050: bic.pk2_value = NVL(bbm.common_organization_id, bbm.organization_id) and
1107: or
1108: ( c_implemented_only_option = 2
1109: and bic.effectivity_date =
1110: (select max(effectivity_date)
1111: from bom_inventory_components bic2
1112: where bic.bill_sequence_id = bic2.bill_sequence_id
1113: and bic.component_item_id = bic2.component_item_id
1114: and NVL(BIC2.ECO_FOR_PRODUCTION,2) = 2
1115: and decode(bic.implementation_date, NULL,
1124: , bic2.component_sequence_id)
1125: and bic2.effectivity_date <=
1126: to_date(c_implosion_date,'YYYY/MM/DD HH24:MI')
1127: and NOT EXISTS (SELECT null
1128: FROM bom_inventory_components bic3
1129: WHERE bic3.bill_sequence_id =
1130: bic.bill_sequence_id
1131: AND bic3.old_component_sequence_id =
1132: bic.component_sequence_id