OracleAppsForum | Determining Flexfield Value by Reference to Line Item in Main Screen

Determining Flexfield Value by Reference to Line Item in Main Screen

Posted: 21 July 2005 12:15 AM

[ Ignore ]

Newbie

Total Posts: 12

Joined 2005-07-18

SELECT ATTRIBUTE6 FROM MTL_ITEM_REVISIONS WHERE INVENTORY_ITEM_ID = :LINES.ITEM_ID AND ORGANIZATION_ID = 999 AND REVISION = :LINES.ITEM_REVISION

Notes:
- Flexfield value was stored in ATTRIBUTE6
- Use “:LINES” to refer back value selected in main screen

Profile