VIEW: AR.RA_BATCH_SOURCES_ALL#

Source

View Text - Preformatted

select BATCH_SOURCE_ID BATCH_SOURCE_ID, 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, NAME NAME, ORG_ID ORG_ID, DESCRIPTION DESCRIPTION, STATUS STATUS, LAST_BATCH_NUM LAST_BATCH_NUM, DEFAULT_INV_TRX_TYPE DEFAULT_INV_TRX_TYPE, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ACCOUNTING_FLEXFIELD_RULE ACCOUNTING_FLEXFIELD_RULE, ACCOUNTING_RULE_RULE ACCOUNTING_RULE_RULE, AGREEMENT_RULE AGREEMENT_RULE, AUTO_BATCH_NUMBERING_FLAG AUTO_BATCH_NUMBERING_FLAG, AUTO_TRX_NUMBERING_FLAG AUTO_TRX_NUMBERING_FLAG, BATCH_SOURCE_TYPE BATCH_SOURCE_TYPE, BILL_ADDRESS_RULE BILL_ADDRESS_RULE, BILL_CONTACT_RULE BILL_CONTACT_RULE, BILL_CUSTOMER_RULE BILL_CUSTOMER_RULE, CREATE_CLEARING_FLAG CREATE_CLEARING_FLAG, CUST_TRX_TYPE_RULE CUST_TRX_TYPE_RULE, DERIVE_DATE_FLAG DERIVE_DATE_FLAG, END_DATE END_DATE, FOB_POINT_RULE FOB_POINT_RULE, GL_DATE_PERIOD_RULE GL_DATE_PERIOD_RULE, INVALID_LINES_RULE INVALID_LINES_RULE, INVALID_TAX_RATE_RULE INVALID_TAX_RATE_RULE, INVENTORY_ITEM_RULE INVENTORY_ITEM_RULE, INVOICING_RULE_RULE INVOICING_RULE_RULE, MEMO_REASON_RULE MEMO_REASON_RULE, REV_ACC_ALLOCATION_RULE REV_ACC_ALLOCATION_RULE, SALESPERSON_RULE SALESPERSON_RULE, SALES_CREDIT_RULE SALES_CREDIT_RULE, SALES_CREDIT_TYPE_RULE SALES_CREDIT_TYPE_RULE, SALES_TERRITORY_RULE SALES_TERRITORY_RULE, SHIP_ADDRESS_RULE SHIP_ADDRESS_RULE, SHIP_CONTACT_RULE SHIP_CONTACT_RULE, SHIP_CUSTOMER_RULE SHIP_CUSTOMER_RULE, SHIP_VIA_RULE SHIP_VIA_RULE, SOLD_CUSTOMER_RULE SOLD_CUSTOMER_RULE, START_DATE START_DATE, TERM_RULE TERM_RULE, UNIT_OF_MEASURE_RULE UNIT_OF_MEASURE_RULE, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, CUSTOMER_BANK_ACCOUNT_RULE CUSTOMER_BANK_ACCOUNT_RULE, MEMO_LINE_RULE MEMO_LINE_RULE, RECEIPT_METHOD_RULE RECEIPT_METHOD_RULE, RELATED_DOCUMENT_RULE RELATED_DOCUMENT_RULE, ALLOW_SALES_CREDIT_FLAG ALLOW_SALES_CREDIT_FLAG, GROUPING_RULE_ID GROUPING_RULE_ID, CREDIT_MEMO_BATCH_SOURCE_ID CREDIT_MEMO_BATCH_SOURCE_ID, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY, COPY_DOC_NUMBER_FLAG COPY_DOC_NUMBER_FLAG, DEFAULT_REFERENCE DEFAULT_REFERENCE, COPY_INV_TIDFF_TO_CM_FLAG COPY_INV_TIDFF_TO_CM_FLAG, RECEIPT_HANDLING_OPTION RECEIPT_HANDLING_OPTION, ALLOW_DUPLICATE_TRX_NUM_FLAG ALLOW_DUPLICATE_TRX_NUM_FLAG, LEGAL_ENTITY_ID LEGAL_ENTITY_ID, GEN_LINE_LEVEL_BAL_FLAG GEN_LINE_LEVEL_BAL_FLAG, PAYMENT_DET_DEF_HIERARCHY PAYMENT_DET_DEF_HIERARCHY, ZD_EDITION_NAME ZD_EDITION_NAME from "AR"."RA_BATCH_SOURCES_ALL"

View Text - HTML Formatted

SELECT BATCH_SOURCE_ID BATCH_SOURCE_ID
, 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
, NAME NAME
, ORG_ID ORG_ID
, DESCRIPTION DESCRIPTION
, STATUS STATUS
, LAST_BATCH_NUM LAST_BATCH_NUM
, DEFAULT_INV_TRX_TYPE DEFAULT_INV_TRX_TYPE
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ACCOUNTING_FLEXFIELD_RULE ACCOUNTING_FLEXFIELD_RULE
, ACCOUNTING_RULE_RULE ACCOUNTING_RULE_RULE
, AGREEMENT_RULE AGREEMENT_RULE
, AUTO_BATCH_NUMBERING_FLAG AUTO_BATCH_NUMBERING_FLAG
, AUTO_TRX_NUMBERING_FLAG AUTO_TRX_NUMBERING_FLAG
, BATCH_SOURCE_TYPE BATCH_SOURCE_TYPE
, BILL_ADDRESS_RULE BILL_ADDRESS_RULE
, BILL_CONTACT_RULE BILL_CONTACT_RULE
, BILL_CUSTOMER_RULE BILL_CUSTOMER_RULE
, CREATE_CLEARING_FLAG CREATE_CLEARING_FLAG
, CUST_TRX_TYPE_RULE CUST_TRX_TYPE_RULE
, DERIVE_DATE_FLAG DERIVE_DATE_FLAG
, END_DATE END_DATE
, FOB_POINT_RULE FOB_POINT_RULE
, GL_DATE_PERIOD_RULE GL_DATE_PERIOD_RULE
, INVALID_LINES_RULE INVALID_LINES_RULE
, INVALID_TAX_RATE_RULE INVALID_TAX_RATE_RULE
, INVENTORY_ITEM_RULE INVENTORY_ITEM_RULE
, INVOICING_RULE_RULE INVOICING_RULE_RULE
, MEMO_REASON_RULE MEMO_REASON_RULE
, REV_ACC_ALLOCATION_RULE REV_ACC_ALLOCATION_RULE
, SALESPERSON_RULE SALESPERSON_RULE
, SALES_CREDIT_RULE SALES_CREDIT_RULE
, SALES_CREDIT_TYPE_RULE SALES_CREDIT_TYPE_RULE
, SALES_TERRITORY_RULE SALES_TERRITORY_RULE
, SHIP_ADDRESS_RULE SHIP_ADDRESS_RULE
, SHIP_CONTACT_RULE SHIP_CONTACT_RULE
, SHIP_CUSTOMER_RULE SHIP_CUSTOMER_RULE
, SHIP_VIA_RULE SHIP_VIA_RULE
, SOLD_CUSTOMER_RULE SOLD_CUSTOMER_RULE
, START_DATE START_DATE
, TERM_RULE TERM_RULE
, UNIT_OF_MEASURE_RULE UNIT_OF_MEASURE_RULE
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, CUSTOMER_BANK_ACCOUNT_RULE CUSTOMER_BANK_ACCOUNT_RULE
, MEMO_LINE_RULE MEMO_LINE_RULE
, RECEIPT_METHOD_RULE RECEIPT_METHOD_RULE
, RELATED_DOCUMENT_RULE RELATED_DOCUMENT_RULE
, ALLOW_SALES_CREDIT_FLAG ALLOW_SALES_CREDIT_FLAG
, GROUPING_RULE_ID GROUPING_RULE_ID
, CREDIT_MEMO_BATCH_SOURCE_ID CREDIT_MEMO_BATCH_SOURCE_ID
, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20
, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY
, COPY_DOC_NUMBER_FLAG COPY_DOC_NUMBER_FLAG
, DEFAULT_REFERENCE DEFAULT_REFERENCE
, COPY_INV_TIDFF_TO_CM_FLAG COPY_INV_TIDFF_TO_CM_FLAG
, RECEIPT_HANDLING_OPTION RECEIPT_HANDLING_OPTION
, ALLOW_DUPLICATE_TRX_NUM_FLAG ALLOW_DUPLICATE_TRX_NUM_FLAG
, LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, GEN_LINE_LEVEL_BAL_FLAG GEN_LINE_LEVEL_BAL_FLAG
, PAYMENT_DET_DEF_HIERARCHY PAYMENT_DET_DEF_HIERARCHY
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "AR"."RA_BATCH_SOURCES_ALL"