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_HEADERS_V

Product:	INV - Inventory
Description:	MTL_TRANSACTION_FLOW_HEADERS_V is a view for Intercompany transaction flow headers of type shipping and procuring flows.
Implementation/DBA Data:	APPS.MTL_TRANSACTION_FLOW_HEADERS_V

View Text

SELECT TRXHDR.ROWID ROW_ID
, TRXHDR.HEADER_ID
, TRXHDR.START_ORG_ID
, HOU1.NAME START_ORG_NAME
, TRXHDR.END_ORG_ID
, HOU2.NAME END_ORG_NAME
, TRXHDR.FLOW_TYPE
, TRXHDR.ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, TRXHDR.QUALIFIER_CODE
, TRXHDR.QUALIFIER_VALUE_ID
, MCV.CATEGORY_CONCAT_SEGS QUALIFIER_VALUE_CODE
, TRXHDR.ASSET_ITEM_PRICING_OPTION
, TRXHDR.EXPENSE_ITEM_PRICING_OPTION
, TRXHDR.START_DATE
, TRXHDR.END_DATE
, TRXHDR.NEW_ACCOUNTING_FLAG
, TRXHDR.CREATION_DATE
, TRXHDR.CREATED_BY
, TRXHDR.LAST_UPDATE_DATE
, TRXHDR.LAST_UPDATED_BY
, TRXHDR.LAST_UPDATE_LOGIN
, TRXHDR.ATTRIBUTE_CATEGORY
, TRXHDR.ATTRIBUTE1
, TRXHDR.ATTRIBUTE2
, TRXHDR.ATTRIBUTE3
, TRXHDR.ATTRIBUTE4
, TRXHDR.ATTRIBUTE5
, TRXHDR.ATTRIBUTE6
, TRXHDR.ATTRIBUTE7
, TRXHDR.ATTRIBUTE8
, TRXHDR.ATTRIBUTE9
, TRXHDR.ATTRIBUTE10
, TRXHDR.ATTRIBUTE11
, TRXHDR.ATTRIBUTE12
, TRXHDR.ATTRIBUTE13
, TRXHDR.ATTRIBUTE14
, TRXHDR.ATTRIBUTE15
FROM MTL_TRANSACTION_FLOW_HEADERS TRXHDR
, HR_OPERATING_UNITS HOU1
, HR_OPERATING_UNITS HOU2
, MTL_PARAMETERS MP
, MTL_CATEGORIES_V MCV
, MTL_CATEGORY_SETS_B MCS
WHERE HOU1.ORGANIZATION_ID=TRXHDR.START_ORG_ID
AND HOU2.ORGANIZATION_ID=TRXHDR.END_ORG_ID
AND MP.ORGANIZATION_ID=TRXHDR.ORGANIZATION_ID
AND TRXHDR.ORGANIZATION_ID IS NOT NULL
AND MCS.CATEGORY_SET_ID = DECODE(TRXHDR.FLOW_TYPE
, 1
, 1
, 2)
AND MCS.STRUCTURE_ID = MCV.STRUCTURE_ID
AND MCS.DEFAULT_CATEGORY_ID = MCV.CATEGORY_ID
AND TRXHDR.QUALIFIER_VALUE_ID = MCV.CATEGORY_ID
AND TRXHDR.QUALIFIER_VALUE_ID IS NOT NULL UNION SELECT TRXHDR.ROWID ROW_ID
, TRXHDR.HEADER_ID
, TRXHDR.START_ORG_ID
, HOU1.NAME START_ORG_NAME
, TRXHDR.END_ORG_ID
, HOU2.NAME END_ORG_NAME
, TRXHDR.FLOW_TYPE
, TRXHDR.ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, TRXHDR.QUALIFIER_CODE
, TRXHDR.QUALIFIER_VALUE_ID
, MCV.CATEGORY_CONCAT_SEGS QUALIFIER_VALUE_CODE
, TRXHDR.ASSET_ITEM_PRICING_OPTION
, TRXHDR.EXPENSE_ITEM_PRICING_OPTION
, TRXHDR.START_DATE
, TRXHDR.END_DATE
, TRXHDR.NEW_ACCOUNTING_FLAG
, TRXHDR.CREATION_DATE
, TRXHDR.CREATED_BY
, TRXHDR.LAST_UPDATE_DATE
, TRXHDR.LAST_UPDATED_BY
, TRXHDR.LAST_UPDATE_LOGIN
, TRXHDR.ATTRIBUTE_CATEGORY
, TRXHDR.ATTRIBUTE1
, TRXHDR.ATTRIBUTE2
, TRXHDR.ATTRIBUTE3
, TRXHDR.ATTRIBUTE4
, TRXHDR.ATTRIBUTE5
, TRXHDR.ATTRIBUTE6
, TRXHDR.ATTRIBUTE7
, TRXHDR.ATTRIBUTE8
, TRXHDR.ATTRIBUTE9
, TRXHDR.ATTRIBUTE10
, TRXHDR.ATTRIBUTE11
, TRXHDR.ATTRIBUTE12
, TRXHDR.ATTRIBUTE13
, TRXHDR.ATTRIBUTE14
, TRXHDR.ATTRIBUTE15
FROM MTL_TRANSACTION_FLOW_HEADERS TRXHDR
, HR_OPERATING_UNITS HOU1
, HR_OPERATING_UNITS HOU2
, MTL_PARAMETERS MP
, MTL_CATEGORIES_V MCV
, MTL_CATEGORY_SETS_B MCS
, MTL_CATEGORY_SET_VALID_CATS MCSVC
WHERE HOU1.ORGANIZATION_ID=TRXHDR.START_ORG_ID
AND HOU2.ORGANIZATION_ID=TRXHDR.END_ORG_ID
AND MP.ORGANIZATION_ID=TRXHDR.ORGANIZATION_ID
AND TRXHDR.ORGANIZATION_ID IS NOT NULL
AND TRXHDR.QUALIFIER_VALUE_ID = MCV.CATEGORY_ID
AND MCS.CATEGORY_SET_ID = DECODE(TRXHDR.FLOW_TYPE
, 1
, 1
, 2)
AND MCS.STRUCTURE_ID = MCV.STRUCTURE_ID
AND MCS.CATEGORY_SET_ID = MCSVC.CATEGORY_SET_ID
AND MCSVC.CATEGORY_ID = MCV.CATEGORY_ID
AND TRXHDR.QUALIFIER_VALUE_ID IS NOT NULL UNION ALL SELECT TRXHDR.ROWID ROW_ID
, TRXHDR.HEADER_ID
, TRXHDR.START_ORG_ID
, HOU1.NAME START_ORG_NAME
, TRXHDR.END_ORG_ID
, HOU2.NAME END_ORG_NAME
, TRXHDR.FLOW_TYPE
, TRXHDR.ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, TRXHDR.QUALIFIER_CODE
, TRXHDR.QUALIFIER_VALUE_ID
, NULL QUALIFIER_VALUE_CODE
, TRXHDR.ASSET_ITEM_PRICING_OPTION
, TRXHDR.EXPENSE_ITEM_PRICING_OPTION
, TRXHDR.START_DATE
, TRXHDR.END_DATE
, TRXHDR.NEW_ACCOUNTING_FLAG
, TRXHDR.CREATION_DATE
, TRXHDR.CREATED_BY
, TRXHDR.LAST_UPDATE_DATE
, TRXHDR.LAST_UPDATED_BY
, TRXHDR.LAST_UPDATE_LOGIN
, TRXHDR.ATTRIBUTE_CATEGORY
, TRXHDR.ATTRIBUTE1
, TRXHDR.ATTRIBUTE2
, TRXHDR.ATTRIBUTE3
, TRXHDR.ATTRIBUTE4
, TRXHDR.ATTRIBUTE5
, TRXHDR.ATTRIBUTE6
, TRXHDR.ATTRIBUTE7
, TRXHDR.ATTRIBUTE8
, TRXHDR.ATTRIBUTE9
, TRXHDR.ATTRIBUTE10
, TRXHDR.ATTRIBUTE11
, TRXHDR.ATTRIBUTE12
, TRXHDR.ATTRIBUTE13
, TRXHDR.ATTRIBUTE14
, TRXHDR.ATTRIBUTE15
FROM MTL_TRANSACTION_FLOW_HEADERS TRXHDR
, HR_OPERATING_UNITS HOU1
, HR_OPERATING_UNITS HOU2
, MTL_PARAMETERS MP
WHERE HOU1.ORGANIZATION_ID=TRXHDR.START_ORG_ID
AND HOU2.ORGANIZATION_ID=TRXHDR.END_ORG_ID
AND MP.ORGANIZATION_ID=TRXHDR.ORGANIZATION_ID
AND TRXHDR.ORGANIZATION_ID IS NOT NULL
AND TRXHDR.QUALIFIER_VALUE_ID IS NULL UNION ALL SELECT TRXHDR.ROWID ROW_ID
, TRXHDR.HEADER_ID
, HOU1.ORGANIZATION_ID START_ORG_ID
, HOU1.NAME START_ORG_NAME
, HOU2.ORGANIZATION_ID END_ORG_ID
, HOU2.NAME END_ORG_NAME
, TRXHDR.FLOW_TYPE
, TRXHDR.ORGANIZATION_ID
, NULL ORGANIZATION_CODE
, TRXHDR.QUALIFIER_CODE
, TRXHDR.QUALIFIER_VALUE_ID
, MCV.CATEGORY_CONCAT_SEGS QUALIFIER_VALUE_CODE
, TRXHDR.ASSET_ITEM_PRICING_OPTION
, TRXHDR.EXPENSE_ITEM_PRICING_OPTION
, TRXHDR.START_DATE
, TRXHDR.END_DATE
, TRXHDR.NEW_ACCOUNTING_FLAG
, TRXHDR.CREATION_DATE
, TRXHDR.CREATED_BY
, TRXHDR.LAST_UPDATE_DATE
, TRXHDR.LAST_UPDATED_BY
, TRXHDR.LAST_UPDATE_LOGIN
, TRXHDR.ATTRIBUTE_CATEGORY
, TRXHDR.ATTRIBUTE1
, TRXHDR.ATTRIBUTE2
, TRXHDR.ATTRIBUTE3
, TRXHDR.ATTRIBUTE4
, TRXHDR.ATTRIBUTE5
, TRXHDR.ATTRIBUTE6
, TRXHDR.ATTRIBUTE7
, TRXHDR.ATTRIBUTE8
, TRXHDR.ATTRIBUTE9
, TRXHDR.ATTRIBUTE10
, TRXHDR.ATTRIBUTE11
, TRXHDR.ATTRIBUTE12
, TRXHDR.ATTRIBUTE13
, TRXHDR.ATTRIBUTE14
, TRXHDR.ATTRIBUTE15
FROM MTL_TRANSACTION_FLOW_HEADERS TRXHDR
, HR_OPERATING_UNITS HOU1
, HR_OPERATING_UNITS HOU2
, MTL_CATEGORIES_V MCV
, MTL_CATEGORY_SETS_B MCS
WHERE HOU1.ORGANIZATION_ID=TRXHDR.START_ORG_ID
AND HOU2.ORGANIZATION_ID=TRXHDR.END_ORG_ID
AND TRXHDR.ORGANIZATION_ID IS NULL
AND TRXHDR.QUALIFIER_VALUE_ID = MCV.CATEGORY_ID
AND MCS.CATEGORY_SET_ID = DECODE(TRXHDR.FLOW_TYPE
, 1
, 1
, 2)
AND MCS.STRUCTURE_ID = MCV.STRUCTURE_ID
AND MCS.DEFAULT_CATEGORY_ID = MCV.CATEGORY_ID
AND TRXHDR.QUALIFIER_VALUE_ID IS NOT NULL UNION SELECT TRXHDR.ROWID ROW_ID
, TRXHDR.HEADER_ID
, HOU1.ORGANIZATION_ID START_ORG_ID
, HOU1.NAME START_ORG_NAME
, HOU2.ORGANIZATION_ID END_ORG_ID
, HOU2.NAME END_ORG_NAME
, TRXHDR.FLOW_TYPE
, TRXHDR.ORGANIZATION_ID
, NULL ORGANIZATION_CODE
, TRXHDR.QUALIFIER_CODE
, TRXHDR.QUALIFIER_VALUE_ID
, MCV.CATEGORY_CONCAT_SEGS QUALIFIER_VALUE_CODE
, TRXHDR.ASSET_ITEM_PRICING_OPTION
, TRXHDR.EXPENSE_ITEM_PRICING_OPTION
, TRXHDR.START_DATE
, TRXHDR.END_DATE
, TRXHDR.NEW_ACCOUNTING_FLAG
, TRXHDR.CREATION_DATE
, TRXHDR.CREATED_BY
, TRXHDR.LAST_UPDATE_DATE
, TRXHDR.LAST_UPDATED_BY
, TRXHDR.LAST_UPDATE_LOGIN
, TRXHDR.ATTRIBUTE_CATEGORY
, TRXHDR.ATTRIBUTE1
, TRXHDR.ATTRIBUTE2
, TRXHDR.ATTRIBUTE3
, TRXHDR.ATTRIBUTE4
, TRXHDR.ATTRIBUTE5
, TRXHDR.ATTRIBUTE6
, TRXHDR.ATTRIBUTE7
, TRXHDR.ATTRIBUTE8
, TRXHDR.ATTRIBUTE9
, TRXHDR.ATTRIBUTE10
, TRXHDR.ATTRIBUTE11
, TRXHDR.ATTRIBUTE12
, TRXHDR.ATTRIBUTE13
, TRXHDR.ATTRIBUTE14
, TRXHDR.ATTRIBUTE15
FROM MTL_TRANSACTION_FLOW_HEADERS TRXHDR
, HR_OPERATING_UNITS HOU1
, HR_OPERATING_UNITS HOU2
, MTL_CATEGORIES_V MCV
, MTL_CATEGORY_SETS_B MCS
, MTL_CATEGORY_SET_VALID_CATS MCSVC
WHERE HOU1.ORGANIZATION_ID=TRXHDR.START_ORG_ID
AND HOU2.ORGANIZATION_ID=TRXHDR.END_ORG_ID
AND TRXHDR.ORGANIZATION_ID IS NULL
AND TRXHDR.QUALIFIER_VALUE_ID = MCV.CATEGORY_ID
AND MCS.CATEGORY_SET_ID = DECODE(TRXHDR.FLOW_TYPE
, 1
, 1
, 2)
AND MCS.STRUCTURE_ID = MCV.STRUCTURE_ID
AND MCS.CATEGORY_SET_ID = MCSVC.CATEGORY_SET_ID
AND MCSVC.CATEGORY_ID = MCV.CATEGORY_ID
AND TRXHDR.QUALIFIER_VALUE_ID IS NOT NULL UNION ALL SELECT TRXHDR.ROWID ROW_ID
, TRXHDR.HEADER_ID
, HOU1.ORGANIZATION_ID START_ORG_ID
, HOU1.NAME START_ORG_NAME
, HOU2.ORGANIZATION_ID END_ORG_ID
, HOU2.NAME END_ORG_NAME
, TRXHDR.FLOW_TYPE
, TRXHDR.ORGANIZATION_ID
, NULL ORGANIZATION_CODE
, TRXHDR.QUALIFIER_CODE
, TRXHDR.QUALIFIER_VALUE_ID
, NULL QUALIFIER_VALUE_CODE
, TRXHDR.ASSET_ITEM_PRICING_OPTION
, TRXHDR.EXPENSE_ITEM_PRICING_OPTION
, TRXHDR.START_DATE
, TRXHDR.END_DATE
, TRXHDR.NEW_ACCOUNTING_FLAG
, TRXHDR.CREATION_DATE
, TRXHDR.CREATED_BY
, TRXHDR.LAST_UPDATE_DATE
, TRXHDR.LAST_UPDATED_BY
, TRXHDR.LAST_UPDATE_LOGIN
, TRXHDR.ATTRIBUTE_CATEGORY
, TRXHDR.ATTRIBUTE1
, TRXHDR.ATTRIBUTE2
, TRXHDR.ATTRIBUTE3
, TRXHDR.ATTRIBUTE4
, TRXHDR.ATTRIBUTE5
, TRXHDR.ATTRIBUTE6
, TRXHDR.ATTRIBUTE7
, TRXHDR.ATTRIBUTE8
, TRXHDR.ATTRIBUTE9
, TRXHDR.ATTRIBUTE10
, TRXHDR.ATTRIBUTE11
, TRXHDR.ATTRIBUTE12
, TRXHDR.ATTRIBUTE13
, TRXHDR.ATTRIBUTE14
, TRXHDR.ATTRIBUTE15
FROM MTL_TRANSACTION_FLOW_HEADERS TRXHDR
, HR_OPERATING_UNITS HOU1
, HR_OPERATING_UNITS HOU2
WHERE HOU1.ORGANIZATION_ID=TRXHDR.START_ORG_ID
AND HOU2.ORGANIZATION_ID=TRXHDR.END_ORG_ID
AND TRXHDR.ORGANIZATION_ID IS NULL
AND TRXHDR.QUALIFIER_VALUE_ID IS NULL

Columns

Name
ROW_ID
HEADER_ID
START_ORG_ID
START_ORG_NAME
END_ORG_ID
END_ORG_NAME
FLOW_TYPE
ORGANIZATION_ID
ORGANIZATION_CODE
QUALIFIER_CODE
QUALIFIER_VALUE_ID
QUALIFIER_VALUE_CODE
ASSET_ITEM_PRICING_OPTION
EXPENSE_ITEM_PRICING_OPTION
START_DATE
END_DATE
NEW_ACCOUNTING_FLAG
CREATION_DATE
CREATED_BY
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