VIEW: OZF.OZF_RESALE_BATCHES_ALL#

Source

View Text - Preformatted

select RESALE_BATCH_ID RESALE_BATCH_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, CREATED_FROM CREATED_FROM, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, PROGRAM_ID PROGRAM_ID, BATCH_TYPE BATCH_TYPE, BATCH_NUMBER BATCH_NUMBER, BATCH_COUNT BATCH_COUNT, YEAR YEAR, MONTH MONTH, REPORT_DATE REPORT_DATE, REPORT_START_DATE REPORT_START_DATE, REPORT_END_DATE REPORT_END_DATE, STATUS_CODE STATUS_CODE, DATA_SOURCE_CODE DATA_SOURCE_CODE, REFERENCE_TYPE REFERENCE_TYPE, REFERENCE_NUMBER REFERENCE_NUMBER, COMMENTS COMMENTS, PARTNER_CLAIM_NUMBER PARTNER_CLAIM_NUMBER, TRANSACTION_PURPOSE_CODE TRANSACTION_PURPOSE_CODE, TRANSACTION_TYPE_CODE TRANSACTION_TYPE_CODE, ORG_ID ORG_ID, PARTNER_TYPE PARTNER_TYPE, PARTNER_ID PARTNER_ID, PARTNER_PARTY_ID PARTNER_PARTY_ID, PARTNER_CUST_ACCOUNT_ID PARTNER_CUST_ACCOUNT_ID, PARTNER_SITE_ID PARTNER_SITE_ID, PARTNER_CONTACT_PARTY_ID PARTNER_CONTACT_PARTY_ID, PARTNER_CONTACT_NAME PARTNER_CONTACT_NAME, PARTNER_EMAIL PARTNER_EMAIL, PARTNER_PHONE PARTNER_PHONE, PARTNER_FAX PARTNER_FAX, HEADER_TOLERANCE_OPERAND HEADER_TOLERANCE_OPERAND, HEADER_TOLERANCE_CALC_CODE HEADER_TOLERANCE_CALC_CODE, LINE_TOLERANCE_OPERAND LINE_TOLERANCE_OPERAND, LINE_TOLERANCE_CALC_CODE LINE_TOLERANCE_CALC_CODE, CURRENCY_CODE CURRENCY_CODE, CLAIMED_AMOUNT CLAIMED_AMOUNT, ALLOWED_AMOUNT ALLOWED_AMOUNT, ACCEPTED_AMOUNT ACCEPTED_AMOUNT, PAID_AMOUNT PAID_AMOUNT, DISPUTED_AMOUNT DISPUTED_AMOUNT, LINES_INVALID LINES_INVALID, LINES_W_TOLERANCE LINES_W_TOLERANCE, LINES_DISPUTED LINES_DISPUTED, BATCH_SET_ID_CODE BATCH_SET_ID_CODE, CREDIT_CODE CREDIT_CODE, CREDIT_ADVICE_DATE CREDIT_ADVICE_DATE, PURGE_FLAG PURGE_FLAG, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, SECURITY_GROUP_ID SECURITY_GROUP_ID, DIRECT_ORDER_FLAG DIRECT_ORDER_FLAG from "OZF"."OZF_RESALE_BATCHES_ALL"

View Text - HTML Formatted

SELECT RESALE_BATCH_ID RESALE_BATCH_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, CREATED_FROM CREATED_FROM
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, PROGRAM_ID PROGRAM_ID
, BATCH_TYPE BATCH_TYPE
, BATCH_NUMBER BATCH_NUMBER
, BATCH_COUNT BATCH_COUNT
, YEAR YEAR
, MONTH MONTH
, REPORT_DATE REPORT_DATE
, REPORT_START_DATE REPORT_START_DATE
, REPORT_END_DATE REPORT_END_DATE
, STATUS_CODE STATUS_CODE
, DATA_SOURCE_CODE DATA_SOURCE_CODE
, REFERENCE_TYPE REFERENCE_TYPE
, REFERENCE_NUMBER REFERENCE_NUMBER
, COMMENTS COMMENTS
, PARTNER_CLAIM_NUMBER PARTNER_CLAIM_NUMBER
, TRANSACTION_PURPOSE_CODE TRANSACTION_PURPOSE_CODE
, TRANSACTION_TYPE_CODE TRANSACTION_TYPE_CODE
, ORG_ID ORG_ID
, PARTNER_TYPE PARTNER_TYPE
, PARTNER_ID PARTNER_ID
, PARTNER_PARTY_ID PARTNER_PARTY_ID
, PARTNER_CUST_ACCOUNT_ID PARTNER_CUST_ACCOUNT_ID
, PARTNER_SITE_ID PARTNER_SITE_ID
, PARTNER_CONTACT_PARTY_ID PARTNER_CONTACT_PARTY_ID
, PARTNER_CONTACT_NAME PARTNER_CONTACT_NAME
, PARTNER_EMAIL PARTNER_EMAIL
, PARTNER_PHONE PARTNER_PHONE
, PARTNER_FAX PARTNER_FAX
, HEADER_TOLERANCE_OPERAND HEADER_TOLERANCE_OPERAND
, HEADER_TOLERANCE_CALC_CODE HEADER_TOLERANCE_CALC_CODE
, LINE_TOLERANCE_OPERAND LINE_TOLERANCE_OPERAND
, LINE_TOLERANCE_CALC_CODE LINE_TOLERANCE_CALC_CODE
, CURRENCY_CODE CURRENCY_CODE
, CLAIMED_AMOUNT CLAIMED_AMOUNT
, ALLOWED_AMOUNT ALLOWED_AMOUNT
, ACCEPTED_AMOUNT ACCEPTED_AMOUNT
, PAID_AMOUNT PAID_AMOUNT
, DISPUTED_AMOUNT DISPUTED_AMOUNT
, LINES_INVALID LINES_INVALID
, LINES_W_TOLERANCE LINES_W_TOLERANCE
, LINES_DISPUTED LINES_DISPUTED
, BATCH_SET_ID_CODE BATCH_SET_ID_CODE
, CREDIT_CODE CREDIT_CODE
, CREDIT_ADVICE_DATE CREDIT_ADVICE_DATE
, PURGE_FLAG PURGE_FLAG
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, DIRECT_ORDER_FLAG DIRECT_ORDER_FLAG
FROM "OZF"."OZF_RESALE_BATCHES_ALL"