Tuesday 28 October 2014

Form Personalization in Batch Details form

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')



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