[Home] [Help]
87: PJM_UNIT_EFF.Unit_Effective_Item(
88: X_Item_ID => X_eng_item_id,
89: X_Organization_ID => X_org_id) = 'Y')
90: THEN
91: DELETE FROM BOM_INVENTORY_COMPONENTS BIC
92: WHERE ((X_implemented_only = 1 AND BIC.IMPLEMENTATION_DATE IS NULL)
93: OR (X_transfer_option = 2 AND
94: (BIC.FROM_END_ITEM_UNIT_NUMBER > X_unit_number
95: OR (BIC.FROM_END_ITEM_UNIT_NUMBER < X_unit_number
108: AND (X_GTIN_ST_TYPE_ID IS NULL or STRUCTURE_TYPE_ID <> X_GTIN_ST_TYPE_ID)
109: AND nvl(BOM_T.effectivity_control , 1) <> 4 -- Bug 4210718
110: );
111: ELSE
112: DELETE FROM BOM_INVENTORY_COMPONENTS BIC
113: WHERE ((X_implemented_only = 1 AND BIC.IMPLEMENTATION_DATE IS NULL)
114: OR (X_transfer_option = 2 AND
115: (BIC.EFFECTIVITY_DATE > X_effectivity_date
116: OR NVL(BIC.DISABLE_DATE, X_effectivity_date + 1)
296: BOM_T.ATTRIBUTE13,
297: BOM_T.ATTRIBUTE14,
298: BOM_T.ATTRIBUTE15,
299: 1,
300: BOM_INVENTORY_COMPONENTS_S.NEXTVAL,
301: DECODE(BOM_T.COMMON_BILL_SEQUENCE_ID,BOM_T.BILL_SEQUENCE_ID,BOM_INVENTORY_COMPONENTS_S.CURRVAL,BOM_T.COMMON_BILL_SEQUENCE_ID),
302: BOM_T.REQUEST_ID,
303: BOM_T.PROGRAM_APPLICATION_ID,
304: BOM_T.PROGRAM_ID,
297: BOM_T.ATTRIBUTE14,
298: BOM_T.ATTRIBUTE15,
299: 1,
300: BOM_INVENTORY_COMPONENTS_S.NEXTVAL,
301: DECODE(BOM_T.COMMON_BILL_SEQUENCE_ID,BOM_T.BILL_SEQUENCE_ID,BOM_INVENTORY_COMPONENTS_S.CURRVAL,BOM_T.COMMON_BILL_SEQUENCE_ID),
302: BOM_T.REQUEST_ID,
303: BOM_T.PROGRAM_APPLICATION_ID,
304: BOM_T.PROGRAM_ID,
305: BOM_T.PROGRAM_UPDATE_DATE,
305: BOM_T.PROGRAM_UPDATE_DATE,
306: BOM_T.COMMON_ORGANIZATION_ID,
307: BOM_T.NEXT_EXPLODE_DATE,
308: BOM_T.EFFECTIVITY_CONTROL,
309: DECODE(BOM_T.COMMON_BILL_SEQUENCE_ID,BOM_T.BILL_SEQUENCE_ID,BOM_INVENTORY_COMPONENTS_S.CURRVAL,BOM_T.COMMON_BILL_SEQUENCE_ID),
310: X_mfg_item_id,
311: ORGANIZATION_ID
312: FROM BOM_BILL_OF_MATERIALS BOM_T
313: WHERE ORGANIZATION_ID = X_org_id