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.

VIEW: APPS.MTL_TRANSACTION_FLOW_LINES_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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