View: CST_ACCOUNTING_EVENT_TYPES_V

Product:	BOM - Bills of Material
Description:
Implementation/DBA Data:	APPS.CST_ACCOUNTING_EVENT_TYPES_V

View Text

SELECT (TO_CHAR(TRANSACTION_TYPE_ID)||'-'||TO_CHAR(TRANSACTION_ACTION_ID)||'-'||TO_CHAR(TRANSACTION_SOURCE_TYPE_ID)) "EVENT_TYPE"
, TRANSACTION_TYPE_ID "TRANSACTION_TYPE_ID"
, TRANSACTION_ACTION_ID "TRANSACTION_ACTION_ID"
, TRANSACTION_SOURCE_TYPE_ID "TRANSACTION_SOURCE_TYPE_ID"
, NULL "TRANSACTION_TYPE"
, TRANSACTION_TYPE_NAME "DESCRIPTION"
, 'INV' "TRANSACTION_TYPE_FLAG"
FROM MTL_TRANSACTION_TYPES UNION SELECT TO_CHAR(LOOKUP_CODE) "EVENT_TYPE"
, LOOKUP_CODE "TRANSACTION_TYPE_ID"
, TO_NUMBER(NULL) "TRANSACTION_ACTION_ID"
, TO_NUMBER(NULL) "TRANSACTION_SOURCE_TYPE_ID"
, NULL "TRANSACTION_TYPE"
, MEANING "DESCRIPTION"
, 'WIP' "TRANSACTION_TYPE_FLAG"
FROM MFG_LOOKUPS
WHERE LOOKUP_TYPE = 'WIP_TRANSACTION_TYPE' UNION SELECT LOOKUP_CODE "EVENT_TYPE"
, TO_NUMBER(NULL) "TRANSACTION_TYPE_ID"
, TO_NUMBER(NULL) "TRANSACTION_ACTION_ID"
, TO_NUMBER(NULL) "TRANSACTION_SOURCE_TYPE_ID"
, LOOKUP_CODE "TRANSACTION_TYPE"
, DISPLAYED_FIELD "DESCRIPTION"
, 'RCV' "TRANSACTION_TYPE_FLAG"
FROM PO_LOOKUP_CODES
WHERE LOOKUP_TYPE = 'RCV TRANSACTION TYPE' UNION SELECT 'PERIOD END ACCRUALS' "EVENT_TYPE"
, TO_NUMBER(NULL) "TRANSACTION_TYPE_ID"
, TO_NUMBER(NULL) "TRANSACTION_ACTION_ID"
, TO_NUMBER(NULL) "TRANSACTION_SOURCE_TYPE_ID"
, NULL "TRANSACTION_TYPE"
, 'PERIOD END ACCRUALS' "DESCRIPTION"
, 'ACR' "TRANSACTION_TYPE_FLAG"
FROM DUAL UNION SELECT 'ADJUST RECEIVE' "EVENT_TYPE"
, TO_NUMBER(NULL) "TRANSACTION_TYPE_ID"
, TO_NUMBER(NULL)"TRANSACTION_ACTION_ID"
, TO_NUMBER(NULL)"TRANSACTION_SOURCE_TYPE_ID"
, 'ADJUST RECEIVE' "TRANSACTION_TYPE"
, 'RETROACTIVE PO RECEIPT ADJUSTMENT' "DESCRIPTION"
, 'ADJ' "TRANSACTION_TYPE_FLAG"
FROM DUAL UNION SELECT 'LOGICAL RECEIVE' "EVENT TYPE"
, TO_NUMBER(NULL) "TRANSACTION_TYPE_ID"
, TO_NUMBER(NULL) "TRANSACTION_ACTION_ID"
, TO_NUMBER(NULL) "TRANSACTION_SOURCE_TYPE_ID"
, 'LOGICAL RECEIVE' "TRANSACTION_TYPE"
, 'LOGICAL RECEIVE' "DESCRIPTION"
, 'RAE' "TRANSACTION_TYPE_FLAG"
FROM DUAL UNION SELECT 'LOGICAL RETURN TO VENDOR' "EVENT TYPE"
, TO_NUMBER(NULL) "TRANSACTION_TYPE_ID"
, TO_NUMBER(NULL) "TRANSACTION_ACTION_ID"
, TO_NUMBER(NULL) "TRANSACTION_SOURCE_TYPE_ID"
, 'LOGICAL RETURN TO VENDOR' "TRANSACTION_TYPE"
, 'LOGICAL RETURN TO VENDOR' "DESCRIPTION"
, 'RAE' "TRANSACTION_TYPE_FLAG"
FROM DUAL

Columns