APPS.BOMPIINQ dependencies on BOM_INVENTORY_COMPONENTS

Line 367: BOM_INVENTORY_COMPONENTS BIC,

363: BIC.FROM_END_ITEM_UNIT_NUMBER FUN,
364: BIC.TO_END_ITEM_UNIT_NUMBER TUN
365: FROM
366: BOM_SMALL_IMPL_TEMP BITT,
367: BOM_INVENTORY_COMPONENTS BIC,
368: BOM_BILL_OF_MATERIALS BBM,
369: MTL_SYSTEM_ITEMS MSI
370: where bitt.current_level = 0
371: and bitt.organization_id = c_org_id

Line 495: from bom_inventory_components bic2

491: ( c_display_option = 2
492: and
493: bic.effectivity_date =
494: (select max(effectivity_date)
495: from bom_inventory_components bic2
496: where bic2.bill_sequence_id = bic.bill_sequence_id
497: and bic2.component_item_id = bic.component_item_id
498: and NVL(BIC2.ECO_FOR_PRODUCTION,2) = 2
499: and decode(bic.implementation_date, NULL,

Line 509: FROM bom_inventory_components bic3

505: and trunc(bic2.effectivity_date, 'MI') <=
506: to_date(c_implosion_date,
507: 'YYYY/MM/DD HH24:MI')
508: and NOT EXISTS (SELECT null
509: FROM bom_inventory_components bic3
510: WHERE bic3.bill_sequence_id =
511: bic.bill_sequence_id
512: AND bic3.old_component_sequence_id =
513: bic.component_sequence_id

Line 529: from bom_inventory_components bic2

525: or
526: ( c_display_option = 3
527: and bic.effectivity_date =
528: (select max(effectivity_date)
529: from bom_inventory_components bic2
530: where bic2.bill_sequence_id = bic.bill_sequence_id
531: and bic2.component_item_id = bic.component_item_id
532: and NVL(bic2.ECO_FOR_PRODUCTION,2) = 2
533: and nvl(bic2.old_component_sequence_id,

Line 541: FROM bom_inventory_components bic4

537: and bic2.effectivity_date <=
538: to_date(c_implosion_date,
539: 'YYYY/MM/DD HH24:MI')
540: and NOT EXISTS (SELECT null
541: FROM bom_inventory_components bic4
542: WHERE bic4.bill_sequence_id =
543: bic.bill_sequence_id
544: AND bic4.old_component_sequence_id =
545: bic.component_sequence_id

Line 1018: BOM_INVENTORY_COMPONENTS BIC,

1014: BIC.FROM_END_ITEM_UNIT_NUMBER FUN,
1015: BIC.TO_END_ITEM_UNIT_NUMBER TUN
1016: FROM
1017: BOM_SMALL_IMPL_TEMP BITT,
1018: BOM_INVENTORY_COMPONENTS BIC,
1019: BOM_BILL_OF_MATERIALS BBM,
1020: MTL_SYSTEM_ITEMS MSI
1021: where
1022: bitt.current_level = c_current_level

Line 1082: from bom_inventory_components bic2

1078: or
1079: ( c_implemented_only_option = 2
1080: and bic.effectivity_date =
1081: (select max(effectivity_date)
1082: from bom_inventory_components bic2
1083: where bic.bill_sequence_id = bic2.bill_sequence_id
1084: and bic.component_item_id = bic2.component_item_id
1085: and NVL(BIC2.ECO_FOR_PRODUCTION,2) = 2
1086: and decode(bic.implementation_date, NULL,

Line 1099: FROM bom_inventory_components bic3

1095: , bic2.component_sequence_id)
1096: and bic2.effectivity_date <=
1097: to_date(c_implosion_date,'YYYY/MM/DD HH24:MI')
1098: and NOT EXISTS (SELECT null
1099: FROM bom_inventory_components bic3
1100: WHERE bic3.bill_sequence_id =
1101: bic.bill_sequence_id
1102: AND bic3.old_component_sequence_id =
1103: bic.component_sequence_id