FND Design Data [Home] [Help]

View: OP_GNRC_ITM_VW2

Product: GML - Process Manufacturing Logistics
Description: View on customer/generic item table.
Implementation/DBA Data: ViewAPPS.OP_GNRC_ITM_VW2
View Text

SELECT G.GENERIC_ITEM
, I.ITEM_NO
, G.DELETE_MARK
FROM OP_GNRC_ITM G
, IC_ITEM_MST I
WHERE G.CUST_ID = 0
AND G.ITEM_ID = I.ITEM_ID
AND G.GENERIC_ID <> 0

Columns

Name
GENERIC_ITEM
ITEM_NO
DELETE_MARK