[Home] [Help]
165: PJM_UNIT_EFF.Unit_Effective_Item(
166: X_Item_ID => X_eng_item_id,
167: X_Organization_ID => X_org_id) = 'Y')
168: THEN
169: DELETE FROM BOM_INVENTORY_COMPONENTS BIC
170: WHERE ((X_implemented_only = 1 AND BIC.IMPLEMENTATION_DATE IS NULL)
171: OR (X_transfer_option = 2 AND
172: (BIC.FROM_END_ITEM_UNIT_NUMBER > X_unit_number
173: OR (BIC.FROM_END_ITEM_UNIT_NUMBER < X_unit_number
186: AND (X_GTIN_ST_TYPE_ID IS NULL or STRUCTURE_TYPE_ID <> X_GTIN_ST_TYPE_ID)
187: AND nvl(BOM_T.effectivity_control , 1) <> 4 -- Bug 4210718
188: );
189: ELSE
190: DELETE FROM BOM_INVENTORY_COMPONENTS BIC
191: WHERE ((X_implemented_only = 1 AND BIC.IMPLEMENTATION_DATE IS NULL)
192: OR (X_transfer_option = 2 AND
193: (BIC.EFFECTIVITY_DATE > X_effectivity_date
194: OR NVL(BIC.DISABLE_DATE, X_effectivity_date + 1)
480: BOM_T.ATTRIBUTE13,
481: BOM_T.ATTRIBUTE14,
482: BOM_T.ATTRIBUTE15,
483: 1,
484: BOM_INVENTORY_COMPONENTS_S.NEXTVAL,
485: DECODE(BOM_T.COMMON_BILL_SEQUENCE_ID,BOM_T.BILL_SEQUENCE_ID,BOM_INVENTORY_COMPONENTS_S.CURRVAL,BOM_T.COMMON_BILL_SEQUENCE_ID),
486: BOM_T.REQUEST_ID,
487: BOM_T.PROGRAM_APPLICATION_ID,
488: BOM_T.PROGRAM_ID,
481: BOM_T.ATTRIBUTE14,
482: BOM_T.ATTRIBUTE15,
483: 1,
484: BOM_INVENTORY_COMPONENTS_S.NEXTVAL,
485: DECODE(BOM_T.COMMON_BILL_SEQUENCE_ID,BOM_T.BILL_SEQUENCE_ID,BOM_INVENTORY_COMPONENTS_S.CURRVAL,BOM_T.COMMON_BILL_SEQUENCE_ID),
486: BOM_T.REQUEST_ID,
487: BOM_T.PROGRAM_APPLICATION_ID,
488: BOM_T.PROGRAM_ID,
489: BOM_T.PROGRAM_UPDATE_DATE,
489: BOM_T.PROGRAM_UPDATE_DATE,
490: BOM_T.COMMON_ORGANIZATION_ID,
491: BOM_T.NEXT_EXPLODE_DATE,
492: BOM_T.EFFECTIVITY_CONTROL,
493: DECODE(BOM_T.COMMON_BILL_SEQUENCE_ID,BOM_T.BILL_SEQUENCE_ID,BOM_INVENTORY_COMPONENTS_S.CURRVAL,BOM_T.COMMON_BILL_SEQUENCE_ID),
494: STRUCTURE_TYPE_ID, -- Bug 12555524
495: X_mfg_item_id,
496: ORGANIZATION_ID
497: FROM BOM_BILL_OF_MATERIALS BOM_T