INV_TXN_REQUEST_HEADERS

Details

Schema: FUSION
Object owner: INV
Object type: VIEW

Columns

Name
HEADER_ID REQUEST_NUMBER TRANSACTION_TYPE_ID TRANSACTION_TYPE_NAME MOVE_ORDER_TYPE MOVE_ORDER_TYPE_NAME ORGANIZATION_ID DESCRIPTION DATE_REQUIRED FROM_SUBINVENTORY_CODE TO_SUBINVENTORY_CODE TO_ACCOUNT_ID SHIP_TO_LOCATION_ID HEADER_STATUS HEADER_STATUS_NAME STATUS_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN LAST_UPDATE_DATE CREATED_BY CREATION_DATE REQUEST_ID ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ATTRIBUTE_CATEGORY TRANSACTION_ACTION_ID GROUPING_RULE_ID FREIGHT_CODE SHIPMENT_METHOD AUTO_RECEIPT_FLAG REFERENCE_ID REFERENCE_DETAIL_ID ASSIGNMENT_ID

Name

HEADER_ID

REQUEST_NUMBER

TRANSACTION_TYPE_ID

TRANSACTION_TYPE_NAME

MOVE_ORDER_TYPE

MOVE_ORDER_TYPE_NAME

ORGANIZATION_ID

DESCRIPTION

DATE_REQUIRED

FROM_SUBINVENTORY_CODE

TO_SUBINVENTORY_CODE

TO_ACCOUNT_ID

SHIP_TO_LOCATION_ID

HEADER_STATUS

HEADER_STATUS_NAME

STATUS_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

LAST_UPDATE_DATE

CREATED_BY

CREATION_DATE

REQUEST_ID

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

ATTRIBUTE_CATEGORY

TRANSACTION_ACTION_ID

GROUPING_RULE_ID

FREIGHT_CODE

SHIPMENT_METHOD

AUTO_RECEIPT_FLAG

REFERENCE_ID

REFERENCE_DETAIL_ID

ASSIGNMENT_ID

Query

SQL_Statement
SELECT MTRH.HEADER_ID HEADER_ID, MTRH.REQUEST_NUMBER REQUEST_NUMBER, MTRH.TRANSACTION_TYPE_ID TRANSACTION_TYPE_ID, MTT.TRANSACTION_TYPE_NAME TRANSACTION_TYPE_NAME, MTRH.MOVE_ORDER_TYPE MOVE_ORDER_TYPE, MFG1.MEANING MOVE_ORDER_TYPE_NAME, MTRH.ORGANIZATION_ID ORGANIZATION_ID, MTRH.DESCRIPTION DESCRIPTION, MTRH.DATE_REQUIRED DATE_REQUIRED, MTRH.FROM_SUBINVENTORY_CODE FROM_SUBINVENTORY_CODE, MTRH.TO_SUBINVENTORY_CODE TO_SUBINVENTORY_CODE, MTRH.TO_ACCOUNT_ID TO_ACCOUNT_ID, MTRH.SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID, MTRH.HEADER_STATUS HEADER_STATUS, MFG2.MEANING HEADER_STATUS_NAME, MTRH.STATUS_DATE STATUS_DATE, MTRH.LAST_UPDATED_BY LAST_UPDATED_BY, MTRH.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, MTRH.LAST_UPDATE_DATE LAST_UPDATE_DATE, MTRH.CREATED_BY CREATED_BY, MTRH.CREATION_DATE CREATION_DATE, MTRH.REQUEST_ID REQUEST_ID, MTRH.ATTRIBUTE1 ATTRIBUTE1, MTRH.ATTRIBUTE2 ATTRIBUTE2, MTRH.ATTRIBUTE3 ATTRIBUTE3, MTRH.ATTRIBUTE4 ATTRIBUTE4, MTRH.ATTRIBUTE5 ATTRIBUTE5, MTRH.ATTRIBUTE6 ATTRIBUTE6, MTRH.ATTRIBUTE7 ATTRIBUTE7, MTRH.ATTRIBUTE8 ATTRIBUTE8, MTRH.ATTRIBUTE9 ATTRIBUTE9, MTRH.ATTRIBUTE10 ATTRIBUTE10, MTRH.ATTRIBUTE11 ATTRIBUTE11, MTRH.ATTRIBUTE12 ATTRIBUTE12, MTRH.ATTRIBUTE13 ATTRIBUTE13, MTRH.ATTRIBUTE14 ATTRIBUTE14, MTRH.ATTRIBUTE15 ATTRIBUTE15, MTRH.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, MTT.TRANSACTION_ACTION_ID TRANSACTION_ACTION_ID, MTRH.GROUPING_RULE_ID GROUPING_RULE_ID, MTRH.FREIGHT_CODE FREIGHT_CODE, MTRH.SHIPMENT_METHOD SHIPMENT_METHOD, MTRH.AUTO_RECEIPT_FLAG AUTO_RECEIPT_FLAG, MTRH.REFERENCE_ID REFERENCE_ID, MTRH.REFERENCE_DETAIL_ID REFERENCE_DETAIL_ID, MTRH.ASSIGNMENT_ID ASSIGNMENT_ID from INV_TXN_REQUEST_HEADERS MTRH, FND_LOOKUPS MFG1, FND_LOOKUPS MFG2, INV_TRANSACTION_TYPES_VL MTT WHERE MFG1.LOOKUP_TYPE = 'INV_MOVE_ORDER_TYPE' and MFG1.LOOKUP_CODE = MTRH.MOVE_ORDER_TYPE and MFG2.LOOKUP_TYPE = 'INV_TXN_REQUEST_STATUS' and MFG2.LOOKUP_CODE = MTRH.HEADER_STATUS and MTT.TRANSACTION_TYPE_ID (+) = MTRH.TRANSACTION_TYPE_ID

SQL_Statement

SELECT MTRH.HEADER_ID HEADER_ID, MTRH.REQUEST_NUMBER REQUEST_NUMBER, MTRH.TRANSACTION_TYPE_ID TRANSACTION_TYPE_ID, MTT.TRANSACTION_TYPE_NAME TRANSACTION_TYPE_NAME, MTRH.MOVE_ORDER_TYPE MOVE_ORDER_TYPE, MFG1.MEANING MOVE_ORDER_TYPE_NAME, MTRH.ORGANIZATION_ID ORGANIZATION_ID, MTRH.DESCRIPTION DESCRIPTION, MTRH.DATE_REQUIRED DATE_REQUIRED, MTRH.FROM_SUBINVENTORY_CODE FROM_SUBINVENTORY_CODE, MTRH.TO_SUBINVENTORY_CODE TO_SUBINVENTORY_CODE, MTRH.TO_ACCOUNT_ID TO_ACCOUNT_ID, MTRH.SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID, MTRH.HEADER_STATUS HEADER_STATUS, MFG2.MEANING HEADER_STATUS_NAME, MTRH.STATUS_DATE STATUS_DATE, MTRH.LAST_UPDATED_BY LAST_UPDATED_BY, MTRH.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, MTRH.LAST_UPDATE_DATE LAST_UPDATE_DATE, MTRH.CREATED_BY CREATED_BY, MTRH.CREATION_DATE CREATION_DATE, MTRH.REQUEST_ID REQUEST_ID, MTRH.ATTRIBUTE1 ATTRIBUTE1, MTRH.ATTRIBUTE2 ATTRIBUTE2, MTRH.ATTRIBUTE3 ATTRIBUTE3, MTRH.ATTRIBUTE4 ATTRIBUTE4, MTRH.ATTRIBUTE5 ATTRIBUTE5, MTRH.ATTRIBUTE6 ATTRIBUTE6, MTRH.ATTRIBUTE7 ATTRIBUTE7, MTRH.ATTRIBUTE8 ATTRIBUTE8, MTRH.ATTRIBUTE9 ATTRIBUTE9, MTRH.ATTRIBUTE10 ATTRIBUTE10, MTRH.ATTRIBUTE11 ATTRIBUTE11, MTRH.ATTRIBUTE12 ATTRIBUTE12, MTRH.ATTRIBUTE13 ATTRIBUTE13, MTRH.ATTRIBUTE14 ATTRIBUTE14, MTRH.ATTRIBUTE15 ATTRIBUTE15, MTRH.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, MTT.TRANSACTION_ACTION_ID TRANSACTION_ACTION_ID, MTRH.GROUPING_RULE_ID GROUPING_RULE_ID, MTRH.FREIGHT_CODE FREIGHT_CODE, MTRH.SHIPMENT_METHOD SHIPMENT_METHOD, MTRH.AUTO_RECEIPT_FLAG AUTO_RECEIPT_FLAG, MTRH.REFERENCE_ID REFERENCE_ID, MTRH.REFERENCE_DETAIL_ID REFERENCE_DETAIL_ID, MTRH.ASSIGNMENT_ID ASSIGNMENT_ID from INV_TXN_REQUEST_HEADERS MTRH,

FND_LOOKUPS MFG1,

FND_LOOKUPS MFG2,

INV_TRANSACTION_TYPES_VL MTT

WHERE MFG1.LOOKUP_TYPE = 'INV_MOVE_ORDER_TYPE'

and MFG1.LOOKUP_CODE = MTRH.MOVE_ORDER_TYPE

and MFG2.LOOKUP_TYPE = 'INV_TXN_REQUEST_STATUS'

and MFG2.LOOKUP_CODE = MTRH.HEADER_STATUS

and MTT.TRANSACTION_TYPE_ID (+) = MTRH.TRANSACTION_TYPE_ID