eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: MTL_TRANSACTION_FLOW_LINES_V

Product:	INV - Inventory
Description:	MTL_TRANSACTION_FLOW_LINES_V is a view for Intercompany transaction flow lines of type shipping and procuring flow for each header.
Implementation/DBA Data:	APPS.MTL_TRANSACTION_FLOW_LINES_V

View Text

SELECT MTFL.ROWID ROW_ID
, MTFL.HEADER_ID
, MTFL.LINE_NUMBER
, MTFL.FROM_ORG_ID
, HOU1.NAME FROM_ORG_NAME
, MTFL.FROM_ORGANIZATION_ID
, MP2.ORGANIZATION_CODE FROM_ORGANIZATION_CODE
, MTFL.TO_ORG_ID
, HOU3.NAME TO_ORG_NAME
, MTFL.TO_ORGANIZATION_ID
, MP4.ORGANIZATION_CODE TO_ORGANIZATION_CODE
, MTFL.CREATED_BY
, MTFL.CREATION_DATE
, MTFL.LAST_UPDATE_DATE
, MTFL.LAST_UPDATED_BY
, MTFL.LAST_UPDATE_LOGIN
, MTFL.ATTRIBUTE_CATEGORY
, MTFL.ATTRIBUTE1
, MTFL.ATTRIBUTE2
, MTFL.ATTRIBUTE3
, MTFL.ATTRIBUTE4
, MTFL.ATTRIBUTE5
, MTFL.ATTRIBUTE6
, MTFL.ATTRIBUTE7
, MTFL.ATTRIBUTE8
, MTFL.ATTRIBUTE9
, MTFL.ATTRIBUTE10
, MTFL.ATTRIBUTE11
, MTFL.ATTRIBUTE12
, MTFL.ATTRIBUTE13
, MTFL.ATTRIBUTE14
, MTFL.ATTRIBUTE15
FROM MTL_TRANSACTION_FLOW_LINES MTFL
, HR_OPERATING_UNITS HOU1
, MTL_PARAMETERS MP2
, HR_OPERATING_UNITS HOU3
, MTL_PARAMETERS MP4
WHERE HOU1.ORGANIZATION_ID=MTFL.FROM_ORG_ID
AND MP2.ORGANIZATION_ID=MTFL.FROM_ORGANIZATION_ID
AND HOU3.ORGANIZATION_ID=MTFL.TO_ORG_ID
AND MP4.ORGANIZATION_ID=MTFL.TO_ORGANIZATION_ID
AND MTFL.FROM_ORGANIZATION_ID IS NOT NULL
AND MTFL.TO_ORGANIZATION_ID IS NOT NULL UNION ALL SELECT MTFL.ROWID ROW_ID
, MTFL.HEADER_ID
, MTFL.LINE_NUMBER
, MTFL.FROM_ORG_ID
, HOU1.NAME FROM_ORG_NAME
, MTFL.FROM_ORGANIZATION_ID
, NULL FROM_ORGANIZATION_CODE
, MTFL.TO_ORG_ID
, HOU3.NAME TO_ORG_NAME
, MTFL.TO_ORGANIZATION_ID
, MP4.ORGANIZATION_CODE TO_ORGANIZATION_CODE
, MTFL.CREATED_BY
, MTFL.CREATION_DATE
, MTFL.LAST_UPDATE_DATE
, MTFL.LAST_UPDATED_BY
, MTFL.LAST_UPDATE_LOGIN
, MTFL.ATTRIBUTE_CATEGORY
, MTFL.ATTRIBUTE1
, MTFL.ATTRIBUTE2
, MTFL.ATTRIBUTE3
, MTFL.ATTRIBUTE4
, MTFL.ATTRIBUTE5
, MTFL.ATTRIBUTE6
, MTFL.ATTRIBUTE7
, MTFL.ATTRIBUTE8
, MTFL.ATTRIBUTE9
, MTFL.ATTRIBUTE10
, MTFL.ATTRIBUTE11
, MTFL.ATTRIBUTE12
, MTFL.ATTRIBUTE13
, MTFL.ATTRIBUTE14
, MTFL.ATTRIBUTE15
FROM MTL_TRANSACTION_FLOW_LINES MTFL
, HR_OPERATING_UNITS HOU1
, HR_OPERATING_UNITS HOU3
, MTL_PARAMETERS MP4
WHERE HOU1.ORGANIZATION_ID=MTFL.FROM_ORG_ID
AND MTFL.FROM_ORGANIZATION_ID IS NULL
AND HOU3.ORGANIZATION_ID=MTFL.TO_ORG_ID
AND MP4.ORGANIZATION_ID=MTFL.TO_ORGANIZATION_ID UNION ALL SELECT MTFL.ROWID ROW_ID
, MTFL.HEADER_ID
, MTFL.LINE_NUMBER
, MTFL.FROM_ORG_ID
, HOU1.NAME FROM_ORG_NAME
, MTFL.FROM_ORGANIZATION_ID
, MP2.ORGANIZATION_CODE FROM_ORGANIZATION_CODE
, MTFL.TO_ORG_ID
, HOU3.NAME TO_ORG_NAME
, MTFL.TO_ORGANIZATION_ID
, NULL TO_ORGANIZATION_CODE
, MTFL.CREATED_BY
, MTFL.CREATION_DATE
, MTFL.LAST_UPDATE_DATE
, MTFL.LAST_UPDATED_BY
, MTFL.LAST_UPDATE_LOGIN
, MTFL.ATTRIBUTE_CATEGORY
, MTFL.ATTRIBUTE1
, MTFL.ATTRIBUTE2
, MTFL.ATTRIBUTE3
, MTFL.ATTRIBUTE4
, MTFL.ATTRIBUTE5
, MTFL.ATTRIBUTE6
, MTFL.ATTRIBUTE7
, MTFL.ATTRIBUTE8
, MTFL.ATTRIBUTE9
, MTFL.ATTRIBUTE10
, MTFL.ATTRIBUTE11
, MTFL.ATTRIBUTE12
, MTFL.ATTRIBUTE13
, MTFL.ATTRIBUTE14
, MTFL.ATTRIBUTE15
FROM MTL_TRANSACTION_FLOW_LINES MTFL
, HR_OPERATING_UNITS HOU1
, MTL_PARAMETERS MP2
, HR_OPERATING_UNITS HOU3
WHERE HOU1.ORGANIZATION_ID=MTFL.FROM_ORG_ID
AND MP2.ORGANIZATION_ID=MTFL.FROM_ORGANIZATION_ID
AND HOU3.ORGANIZATION_ID=MTFL.TO_ORG_ID
AND MTFL.TO_ORGANIZATION_ID IS NULL UNION ALL SELECT MTFL.ROWID ROW_ID
, MTFL.HEADER_ID
, MTFL.LINE_NUMBER
, MTFL.FROM_ORG_ID
, HOU1.NAME FROM_ORG_NAME
, MTFL.FROM_ORGANIZATION_ID
, NULL FROM_ORGANIZATION_CODE
, MTFL.TO_ORG_ID
, HOU3.NAME TO_ORG_NAME
, MTFL.TO_ORGANIZATION_ID
, NULL TO_ORGANIZATION_CODE
, MTFL.CREATED_BY
, MTFL.CREATION_DATE
, MTFL.LAST_UPDATE_DATE
, MTFL.LAST_UPDATED_BY
, MTFL.LAST_UPDATE_LOGIN
, MTFL.ATTRIBUTE_CATEGORY
, MTFL.ATTRIBUTE1
, MTFL.ATTRIBUTE2
, MTFL.ATTRIBUTE3
, MTFL.ATTRIBUTE4
, MTFL.ATTRIBUTE5
, MTFL.ATTRIBUTE6
, MTFL.ATTRIBUTE7
, MTFL.ATTRIBUTE8
, MTFL.ATTRIBUTE9
, MTFL.ATTRIBUTE10
, MTFL.ATTRIBUTE11
, MTFL.ATTRIBUTE12
, MTFL.ATTRIBUTE13
, MTFL.ATTRIBUTE14
, MTFL.ATTRIBUTE15
FROM MTL_TRANSACTION_FLOW_LINES MTFL
, HR_OPERATING_UNITS HOU1
, HR_OPERATING_UNITS HOU3
WHERE HOU1.ORGANIZATION_ID=MTFL.FROM_ORG_ID
AND HOU3.ORGANIZATION_ID=MTFL.TO_ORG_ID
AND MTFL.FROM_ORGANIZATION_ID IS NULL
AND MTFL.TO_ORGANIZATION_ID IS NULL

Columns

Name
ROW_ID
HEADER_ID
LINE_NUMBER
FROM_ORG_ID
FROM_ORG_NAME
FROM_ORGANIZATION_ID
FROM_ORGANIZATION_CODE
TO_ORG_ID
TO_ORG_NAME
TO_ORGANIZATION_ID
TO_ORGANIZATION_CODE
CREATED_BY
CREATION_DATE
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15