Oracle apps important lookup SQL queries

ORACLE SCM TECHNICAL, TECHNOLOGY
Spread the love..!
  • 1
    Share

Useful Oracle Lookups  

oracle-lookups-r12

1. Picking line status from WSH_DELIVERY_DETAILS table  (wdd.released_status) 

SELECT FND.LOOKUP_CODE, FND.MEANING 

FROM apps.FND_LOOKUP_VALUES FND 

WHERE FND.LOOKUP_TYPE= 'PICK_STATUS

AND LANGUAGE ='US' 

ORDER BY lookup_code; 

2. Delivery FIRM Status 

SELECT FLV.LOOKUP_CODE, 

FLV.MEANING 

FROM FND_LOOKUP_VALUES FLV 

WHERE FLV.LANGUAGE = 'US' 

AND FLV.LOOKUP_TYPE = 'DELIVERY_PLANNED_FLAG

ORDER BY lookup_code; 

3. Delivery Status 

SELECT FLV.LOOKUP_CODE,  

FLV.MEANING 

FROM FND_LOOKUP_VALUES FLV  

WHERE FLV.LANGUAGE = 'US' 

and flv.lookup_type = 'DELIVERY_STATUS

ORDER BY lookup_code; 

4. WMS TASK status 

SELECT * 

FROM MFG_LOOKUPS 

WHERE LOOKUP_TYPE = 'WMS_TASK_STATUS

ORDER BY lookup_code; 

5. WMS Task Type 

SELECT * 

FROM MFG_LOOKUPS 

WHERE LOOKUP_TYPE = 'WMS_TASK_TYPES

ORDER BY lookup_code; 

6. WMS LPN  Context 

SELECT * 

FROM MFG_LOOKUPS 

WHERE LOOKUP_TYPE = 'WMS_LPN_CONTEXT

ORDER BY LOOKUP_CODE; 

7. Serial Number status 

select * 

FROM MFG_LOOKUPS 

WHERE LOOKUP_TYPE = 'SERIAL_NUM_STATUS

order by lookup_code; 

8. WIP Job status 

SELECT *   FROM MFG_LOOKUPS
where LOOKUP_TYPE = 'WIP_JOB_STATUS'; 

SELECT * FROM MFG_LOOKUPS WHERE LOOKUP_TYPE = 'WIP_SUPPLY

SELECT * FROM MFG_LOOKUPS WHERE LOOKUP_TYPE = 'BOM_ITEM_TYPE

9. Move Order Status 

SELECT * 

FROM MFG_LOOKUPS 

WHERE LOOKUP_TYPE = 'MTL_TXN_REQUEST_STATUS

order by lookup_code; 

10. Move Order Type 

SELECT * 

FROM apps.MFG_LOOKUPS 

WHERE  LOOKUP_TYPE = 'MOVE_ORDER_TYPE' 

order by lookup_code; 

11. INV transaction Actions 

SELECT * 

FROM MFG_LOOKUPS 

where lookup_type like 'MTL_TRANSACTION_ACTION'; 

12. INV transaction Source Type 

SELECT * 

FROM MFG_LOOKUPS 

WHERE lookup_type like 'MTL_TRANSACTION_SOURCE'; 

13. INV transaction TYPES 

SELECT TRANSACTION_TYPE_ID , 

TRANSACTION_TYPE_NAME , 

DESCRIPTION 

FROM MTL_TRANSACTION_TYPES 

ORDER BY 1; 
Trending Articles:
oracle-lookups-r12

Oracle apps important lookup SQL queries

Spread the love..!
  • 1
    Share

Oracle lookup is a collection of values (or, list of values) which is accessed through a user interface and used for validation and to keep programs flexible and easier to configure.
There are three types of lookup in Oracle R12 which are System, Extensible and User. [Read more..]


Spread the love..!
  • 1
    Share

Spread the love..!
  • 1
    Share

Your Comments