VIEW: OZF.OZF_NA_CONC_EXCEPTIONS#

Source

View Text - Preformatted

select NA_CONC_EXCEPTION_ID NA_CONC_EXCEPTION_ID, ACT_BUDGET_USED_BY_ID ACT_BUDGET_USED_BY_ID, ARC_ACT_BUDGET_USED_BY ARC_ACT_BUDGET_USED_BY, BUDGET_SOURCE_TYPE BUDGET_SOURCE_TYPE, BUDGET_SOURCE_ID BUDGET_SOURCE_ID, REQUEST_AMOUNT REQUEST_AMOUNT, REQUEST_CURRENCY REQUEST_CURRENCY, REQUEST_DATE REQUEST_DATE, STATUS_CODE STATUS_CODE, APPROVED_AMOUNT APPROVED_AMOUNT, APPROVED_IN_CURRENCY APPROVED_IN_CURRENCY, APPROVAL_DATE APPROVAL_DATE, APPROVER_ID APPROVER_ID, TRANSFER_TYPE TRANSFER_TYPE, REQUESTER_ID REQUESTER_ID, OBJECT_TYPE OBJECT_TYPE, OBJECT_ID OBJECT_ID, PRODUCT_LEVEL_TYPE PRODUCT_LEVEL_TYPE, PRODUCT_ID PRODUCT_ID, CUST_ACCOUNT_ID CUST_ACCOUNT_ID, UTILIZATION_TYPE UTILIZATION_TYPE, ADJUSTMENT_DATE ADJUSTMENT_DATE, GL_DATE GL_DATE, BILLTO_CUST_ACCOUNT_ID BILLTO_CUST_ACCOUNT_ID, REFERENCE_TYPE REFERENCE_TYPE, REFERENCE_ID REFERENCE_ID, ORDER_LINE_ID ORDER_LINE_ID, ORG_ID ORG_ID from "OZF"."OZF_NA_CONC_EXCEPTIONS"

View Text - HTML Formatted

SELECT NA_CONC_EXCEPTION_ID NA_CONC_EXCEPTION_ID
, ACT_BUDGET_USED_BY_ID ACT_BUDGET_USED_BY_ID
, ARC_ACT_BUDGET_USED_BY ARC_ACT_BUDGET_USED_BY
, BUDGET_SOURCE_TYPE BUDGET_SOURCE_TYPE
, BUDGET_SOURCE_ID BUDGET_SOURCE_ID
, REQUEST_AMOUNT REQUEST_AMOUNT
, REQUEST_CURRENCY REQUEST_CURRENCY
, REQUEST_DATE REQUEST_DATE
, STATUS_CODE STATUS_CODE
, APPROVED_AMOUNT APPROVED_AMOUNT
, APPROVED_IN_CURRENCY APPROVED_IN_CURRENCY
, APPROVAL_DATE APPROVAL_DATE
, APPROVER_ID APPROVER_ID
, TRANSFER_TYPE TRANSFER_TYPE
, REQUESTER_ID REQUESTER_ID
, OBJECT_TYPE OBJECT_TYPE
, OBJECT_ID OBJECT_ID
, PRODUCT_LEVEL_TYPE PRODUCT_LEVEL_TYPE
, PRODUCT_ID PRODUCT_ID
, CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, UTILIZATION_TYPE UTILIZATION_TYPE
, ADJUSTMENT_DATE ADJUSTMENT_DATE
, GL_DATE GL_DATE
, BILLTO_CUST_ACCOUNT_ID BILLTO_CUST_ACCOUNT_ID
, REFERENCE_TYPE REFERENCE_TYPE
, REFERENCE_ID REFERENCE_ID
, ORDER_LINE_ID ORDER_LINE_ID
, ORG_ID ORG_ID
FROM "OZF"."OZF_NA_CONC_EXCEPTIONS"