[Home] [Help]
199: o.first_unit_start_date,
200: o.department_id
201: FROM
202: WIP_OPERATIONS O,
203: BOM_INVENTORY_COMPONENTS A,
204: MTL_SYSTEM_ITEMS C,
205: BOM_EXPLOSION_TEMP BE
206: WHERE
207: BE.GROUP_ID=WSMPWROT.EXPLOSION_GROUP_ID
239: AND nvl(A.DISABLE_DATE, p_bom_revision_date + 1) >= p_bom_revision_date -- CHG: BUG2380517 from > to >=
240: AND A.EFFECTIVITY_DATE =
241: (
242: SELECT MAX(EFFECTIVITY_DATE)
243: FROM BOM_INVENTORY_COMPONENTS BIC,
244: ENG_REVISED_ITEMS ERI
245: WHERE BIC.BILL_SEQUENCE_ID = A.BILL_SEQUENCE_ID
246: AND BIC.COMPONENT_ITEM_ID = A.COMPONENT_ITEM_ID
247: AND (decode(BIC.IMPLEMENTATION_DATE, NULL,
257: ERI.REVISED_ITEM_SEQUENCE_ID(+)
258: AND (nvl(ERI.STATUS_TYPE,6) IN (4,6,7))
259: AND NOT EXISTS
260: (SELECT 'X'
261: FROM BOM_INVENTORY_COMPONENTS BICN, ENG_REVISED_ITEMS ERI1
262: WHERE BICN.BILL_SEQUENCE_ID = A.BILL_SEQUENCE_ID
263: AND BICN.OLD_COMPONENT_SEQUENCE_ID =
264: A.COMPONENT_SEQUENCE_ID
265: AND BICN.ACD_TYPE in (2,3)
751: c.segment20,
752: x_start_date first_unit_start_date,
753: x_department_id department_id
754: FROM
755: BOM_INVENTORY_COMPONENTS A,
756: MTL_SYSTEM_ITEMS C,
757: BOM_EXPLOSION_TEMP BE
758: WHERE BE.GROUP_ID = WSMPWROT.EXPLOSION_GROUP_ID
759: AND A.COMPONENT_SEQUENCE_ID = BE.COMPONENT_SEQUENCE_ID
765: AND nvl(A.DISABLE_DATE, p_bom_revision_date + 1) >= p_bom_revision_date -- CHG: BUG2380517 from > to >=
766: AND A.EFFECTIVITY_DATE =
767: (
768: SELECT MAX(EFFECTIVITY_DATE)
769: FROM BOM_INVENTORY_COMPONENTS BIC,
770: ENG_REVISED_ITEMS ERI
771: WHERE BIC.BILL_SEQUENCE_ID = A.BILL_SEQUENCE_ID
772: AND BIC.COMPONENT_ITEM_ID = A.COMPONENT_ITEM_ID
773: AND (
784: ERI.REVISED_ITEM_SEQUENCE_ID(+)
785: AND ( nvl(ERI.STATUS_TYPE,6) IN (4,6,7))
786: AND NOT EXISTS
787: (SELECT 'X'
788: FROM BOM_INVENTORY_COMPONENTS BICN, ENG_REVISED_ITEMS ERI1
789: WHERE BICN.BILL_SEQUENCE_ID = A.BILL_SEQUENCE_ID
790: AND BICN.OLD_COMPONENT_SEQUENCE_ID =
791: A.COMPONENT_SEQUENCE_ID
792: AND BICN.ACD_TYPE in (2,3)