View: MTL_PROCURING_TXN_FLOW_LINES_V

Product:	INV - Inventory
Description:	MTL_PROCURING_TXN_FLOW_LINES_V is a view for transaction flow lines of type procuring. This view is used by Oracle Procuring to query the transaction flow lines information for each header.
Implementation/DBA Data:	APPS.MTL_PROCURING_TXN_FLOW_LINES_V

View Text

SELECT L.HEADER_ID
, L.LINE_NUMBER
, L.FROM_ORG_ID
, L.FROM_ORGANIZATION_ID
, L.TO_ORG_ID
, L.TO_ORGANIZATION_ID
, L.LAST_UPDATE_DATE
, L.LAST_UPDATED_BY
, L.CREATION_DATE
, L.CREATED_BY
, L.LAST_UPDATE_LOGIN
, L.ATTRIBUTE_CATEGORY
, L.ATTRIBUTE1
, L.ATTRIBUTE2
, L.ATTRIBUTE3
, L.ATTRIBUTE4
, L.ATTRIBUTE5
, L.ATTRIBUTE6
, L.ATTRIBUTE7
, L.ATTRIBUTE8
, L.ATTRIBUTE9
, L.ATTRIBUTE10
, L.ATTRIBUTE11
, L.ATTRIBUTE12
, L.ATTRIBUTE13
, L.ATTRIBUTE14
, L.ATTRIBUTE15
FROM MTL_TRANSACTION_FLOW_LINES L
, MTL_TRANSACTION_FLOW_HEADERS H
WHERE L.HEADER_ID = H.HEADER_ID
AND H.FLOW_TYPE = 2

Columns