[Home] [Help]
View: PJM_UNIT_NUMBERS_LOV_V
Product: | PJM - Project Manufacturing |
Description: | End item model/unit number view for List of Values |
Implementation/DBA Data: |
APPS.PJM_UNIT_NUMBERS_LOV_V
|
View Text
SELECT PUN.UNIT_NUMBER
, PUN.END_ITEM_ID
, MIF.ITEM_NUMBER
, PUN.MASTER_ORGANIZATION_ID
, PUN.COMMENTS
FROM PJM_UNIT_NUMBERS PUN
, MTL_ITEM_FLEXFIELDS MIF
, MTL_PARAMETERS MP
WHERE MIF.INVENTORY_ITEM_ID = PUN.END_ITEM_ID
AND MIF.ORGANIZATION_ID = PUN.MASTER_ORGANIZATION_ID
AND MP.MASTER_ORGANIZATION_ID = MIF.ORGANIZATION_ID
AND MP.ORGANIZATION_ID = NVL( FND_PROFILE.VALUE('MFG_ORGANIZATION_ID')
, MIF.ORGANIZATION_ID)
Columns
Name |
UNIT_NUMBER |
END_ITEM_ID |
END_ITEM_NUMBER |
MASTER_ORGANIZATION_ID |
COMMENTS |