Req 1:
Default batch number as lot number (Non FG Batch)and WIP Qty as Transaction Qty for WIP batches in Pending lot screen (Batch Details form):
Condition:
:GME_BATCH_HEADER.BATCH_STATUS IN (1,2)
AND :GME_PRODUCT_LOTS.LOT_NUMBER IS NULL
AND :GME_MTL_DTL_PROD.LINE_TYPE = 1
AND EXISTS (SELECT distinct INVENTORY_ITEM_ID FROM MTL_SYSTEM_ITEMS_B
WHERE ORGANIZATION_ID in (101,102) AND INVENTORY_ITEM_ID = :GME_PRODUCT_LOTS.INVENTORY_ITEM_ID AND ITEM_TYPE <> 'FG')
Req 2:Change EXPIRATION_DATE Format(Pending Lot Form)
DD:MON:YYYY to DD:MON:YYYY HH24:MI:SS
Default batch number as lot number (Non FG Batch)and WIP Qty as Transaction Qty for WIP batches in Pending lot screen (Batch Details form):
Condition:
:GME_BATCH_HEADER.BATCH_STATUS IN (1,2)
AND :GME_PRODUCT_LOTS.LOT_NUMBER IS NULL
AND :GME_MTL_DTL_PROD.LINE_TYPE = 1
AND EXISTS (SELECT distinct INVENTORY_ITEM_ID FROM MTL_SYSTEM_ITEMS_B
WHERE ORGANIZATION_ID in (101,102) AND INVENTORY_ITEM_ID = :GME_PRODUCT_LOTS.INVENTORY_ITEM_ID AND ITEM_TYPE <> 'FG')
Value: ${item.gme_batch_header.batch_no.value}
Req 2:Change EXPIRATION_DATE Format(Pending Lot Form)
DD:MON:YYYY to DD:MON:YYYY HH24:MI:SS
Value: DD-MON-YYYY HH24:MI:SS
Req 3:If Revision number is null then return error msg (Batch Details Form Product tab)
Condition::GME_MTL_DTL_PROD.REVISION is null and fnd_profile.value('MFG_ORGANIZATION_ID')=(select ORGANIZATION_ID from org_organization_definitions where ORGANIZATION_CODE ='XYZ')
No comments:
Post a Comment