VIEW: APPS.CST_ACCOUNTING_EVENT_TYPES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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