JL_BR_AP_INVOICES_SHIP

Details

Schema: FUSION
Object owner: JL
Object type: VIEW

Columns

Name
ROW_ID INVOICE_ID LAST_UPDATE_DATE LAST_UPDATED_BY VENDOR_ID INVOICE_NUM SET_OF_BOOKS_ID INVOICE_CURRENCY_CODE PAYMENT_CURRENCY_CODE PAYMENT_CROSS_RATE INVOICE_AMOUNT VENDOR_SITE_ID AMOUNT_PAID DISCOUNT_AMOUNT_TAKEN INVOICE_DATE SOURCE INVOICE_TYPE_LOOKUP_CODE DESCRIPTION BATCH_ID AMOUNT_APPLICABLE_TO_DISCOUNT TERMS_ID TERMS_DATE PAYMENT_METHOD_LOOKUP_CODE PAY_GROUP_LOOKUP_CODE ACCTS_PAY_CODE_COMBINATION_ID PAYMENT_STATUS_FLAG CREATION_DATE CREATED_BY BASE_AMOUNT LAST_UPDATE_LOGIN EXCLUSIVE_PAYMENT_FLAG PO_HEADER_ID FREIGHT_AMOUNT GOODS_RECEIVED_DATE INVOICE_RECEIVED_DATE VOUCHER_NUM APPROVED_AMOUNT RECURRING_PAYMENT_ID EXCHANGE_RATE EXCHANGE_RATE_TYPE EXCHANGE_DATE EARLIEST_SETTLEMENT_DATE DOC_SEQUENCE_ID DOC_SEQUENCE_VALUE DOC_CATEGORY_CODE ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ATTRIBUTE_CATEGORY APPROVAL_STATUS APPROVAL_DESCRIPTION POSTING_STATUS CANCELLED_DATE CANCELLED_BY CANCELLED_AMOUNT TEMP_CANCELLED_AMOUNT USSGL_TRANSACTION_CODE USSGL_TRX_CODE_CONTEXT PROJECT_ID TASK_ID EXPENDITURE_TYPE EXPENDITURE_ITEM_DATE PA_QUANTITY EXPENDITURE_ORGANIZATION_ID PA_DEFAULT_DIST_CCID PAYMENT_AMOUNT_TOTAL AWT_FLAG AWT_GROUP_ID REFERENCE_1 REFERENCE_2 ORG_ID PRE_WITHHOLDING_AMOUNT GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE20 NAME

Name

ROW_ID

INVOICE_ID

LAST_UPDATE_DATE

LAST_UPDATED_BY

VENDOR_ID

INVOICE_NUM

SET_OF_BOOKS_ID

INVOICE_CURRENCY_CODE

PAYMENT_CURRENCY_CODE

PAYMENT_CROSS_RATE

INVOICE_AMOUNT

VENDOR_SITE_ID

AMOUNT_PAID

DISCOUNT_AMOUNT_TAKEN

INVOICE_DATE

SOURCE

INVOICE_TYPE_LOOKUP_CODE

DESCRIPTION

BATCH_ID

AMOUNT_APPLICABLE_TO_DISCOUNT

TERMS_ID

TERMS_DATE

PAYMENT_METHOD_LOOKUP_CODE

PAY_GROUP_LOOKUP_CODE

ACCTS_PAY_CODE_COMBINATION_ID

PAYMENT_STATUS_FLAG

CREATION_DATE

CREATED_BY

BASE_AMOUNT

LAST_UPDATE_LOGIN

EXCLUSIVE_PAYMENT_FLAG

PO_HEADER_ID

FREIGHT_AMOUNT

GOODS_RECEIVED_DATE

INVOICE_RECEIVED_DATE

VOUCHER_NUM

APPROVED_AMOUNT

RECURRING_PAYMENT_ID

EXCHANGE_RATE

EXCHANGE_RATE_TYPE

EXCHANGE_DATE

EARLIEST_SETTLEMENT_DATE

DOC_SEQUENCE_ID

DOC_SEQUENCE_VALUE

DOC_CATEGORY_CODE

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

ATTRIBUTE_CATEGORY

APPROVAL_STATUS

APPROVAL_DESCRIPTION

POSTING_STATUS

CANCELLED_DATE

CANCELLED_BY

CANCELLED_AMOUNT

TEMP_CANCELLED_AMOUNT

USSGL_TRANSACTION_CODE

USSGL_TRX_CODE_CONTEXT

PROJECT_ID

TASK_ID

EXPENDITURE_TYPE

EXPENDITURE_ITEM_DATE

PA_QUANTITY

EXPENDITURE_ORGANIZATION_ID

PA_DEFAULT_DIST_CCID

PAYMENT_AMOUNT_TOTAL

AWT_FLAG

AWT_GROUP_ID

REFERENCE_1

REFERENCE_2

ORG_ID

PRE_WITHHOLDING_AMOUNT

GLOBAL_ATTRIBUTE_CATEGORY

GLOBAL_ATTRIBUTE1

GLOBAL_ATTRIBUTE2

GLOBAL_ATTRIBUTE3

GLOBAL_ATTRIBUTE4

GLOBAL_ATTRIBUTE5

GLOBAL_ATTRIBUTE6

GLOBAL_ATTRIBUTE7

GLOBAL_ATTRIBUTE8

GLOBAL_ATTRIBUTE9

GLOBAL_ATTRIBUTE10

GLOBAL_ATTRIBUTE11

GLOBAL_ATTRIBUTE12

GLOBAL_ATTRIBUTE13

GLOBAL_ATTRIBUTE14

GLOBAL_ATTRIBUTE15

GLOBAL_ATTRIBUTE16

GLOBAL_ATTRIBUTE17

GLOBAL_ATTRIBUTE18

GLOBAL_ATTRIBUTE19

GLOBAL_ATTRIBUTE20

NAME

Query

SQL_Statement
SELECT APIN.ROWID , APIN.INVOICE_ID , APIN.LAST_UPDATE_DATE , APIN.LAST_UPDATED_BY , APIN.VENDOR_ID , APIN.INVOICE_NUM , APIN.SET_OF_BOOKS_ID , APIN.INVOICE_CURRENCY_CODE , APIN.PAYMENT_CURRENCY_CODE , APIN.PAYMENT_CROSS_RATE , APIN.INVOICE_AMOUNT , APIN.VENDOR_SITE_ID , APIN.AMOUNT_PAID , APIN.DISCOUNT_AMOUNT_TAKEN , APIN.INVOICE_DATE , APIN.SOURCE , APIN.INVOICE_TYPE_LOOKUP_CODE , APIN.DESCRIPTION , APIN.BATCH_ID , APIN.AMOUNT_APPLICABLE_TO_DISCOUNT , APIN.TERMS_ID , APIN.TERMS_DATE , APIN.PAYMENT_METHOD_LOOKUP_CODE , APIN.PAY_GROUP_LOOKUP_CODE , APIN.ACCTS_PAY_CODE_COMBINATION_ID , APIN.PAYMENT_STATUS_FLAG , APIN.CREATION_DATE , APIN.CREATED_BY , APIN.BASE_AMOUNT , APIN.LAST_UPDATE_LOGIN , APIN.EXCLUSIVE_PAYMENT_FLAG , APIN.PO_HEADER_ID , APIN.FREIGHT_AMOUNT , APIN.GOODS_RECEIVED_DATE , APIN.INVOICE_RECEIVED_DATE , APIN.VOUCHER_NUM , APIN.APPROVED_AMOUNT , APIN.RECURRING_PAYMENT_ID , APIN.EXCHANGE_RATE , APIN.EXCHANGE_RATE_TYPE , APIN.EXCHANGE_DATE , APIN.EARLIEST_SETTLEMENT_DATE , APIN.DOC_SEQUENCE_ID , APIN.DOC_SEQUENCE_VALUE , APIN.DOC_CATEGORY_CODE , APIN.ATTRIBUTE1 , APIN.ATTRIBUTE2 , APIN.ATTRIBUTE3 , APIN.ATTRIBUTE4 , APIN.ATTRIBUTE5 , APIN.ATTRIBUTE6 , APIN.ATTRIBUTE7 , APIN.ATTRIBUTE8 , APIN.ATTRIBUTE9 , APIN.ATTRIBUTE10 , APIN.ATTRIBUTE11 , APIN.ATTRIBUTE12 , APIN.ATTRIBUTE13 , APIN.ATTRIBUTE14 , APIN.ATTRIBUTE15 , APIN.ATTRIBUTE_CATEGORY , APIN.APPROVAL_STATUS , APIN.APPROVAL_DESCRIPTION , APIN.POSTING_STATUS , APIN.CANCELLED_DATE , APIN.CANCELLED_BY , APIN.CANCELLED_AMOUNT , APIN.TEMP_CANCELLED_AMOUNT , APIN.USSGL_TRANSACTION_CODE , APIN.USSGL_TRX_CODE_CONTEXT , APIN.PROJECT_ID , APIN.TASK_ID , APIN.EXPENDITURE_TYPE , APIN.EXPENDITURE_ITEM_DATE , APIN.PA_QUANTITY , APIN.EXPENDITURE_ORGANIZATION_ID , APIN.PA_DEFAULT_DIST_CCID , APIN.PAYMENT_AMOUNT_TOTAL , APIN.AWT_FLAG , APIN.AWT_GROUP_ID , APIN.REFERENCE_1 , APIN.REFERENCE_2 , APIN.ORG_ID , APIN.PRE_WITHHOLDING_AMOUNT , APIN.GLOBAL_ATTRIBUTE_CATEGORY , APIN.GLOBAL_ATTRIBUTE1 , APIN.GLOBAL_ATTRIBUTE2 , APIN.GLOBAL_ATTRIBUTE3 , APIN.GLOBAL_ATTRIBUTE4 , APIN.GLOBAL_ATTRIBUTE5 , APIN.GLOBAL_ATTRIBUTE6 , APIN.GLOBAL_ATTRIBUTE7 , APIN.GLOBAL_ATTRIBUTE8 , APIN.GLOBAL_ATTRIBUTE9 , APIN.GLOBAL_ATTRIBUTE10 , APIN.GLOBAL_ATTRIBUTE11 , APIN.GLOBAL_ATTRIBUTE12 , APIN.GLOBAL_ATTRIBUTE13 , APIN.GLOBAL_ATTRIBUTE14 , APIN.GLOBAL_ATTRIBUTE15 , APIN.GLOBAL_ATTRIBUTE16 , APIN.GLOBAL_ATTRIBUTE17 , APIN.GLOBAL_ATTRIBUTE18 , APIN.GLOBAL_ATTRIBUTE19 , APIN.GLOBAL_ATTRIBUTE20 , APT.NAME FROM AP_INVOICES APIN, AP_TERMS APT WHERE APT.TERM_ID (+) = APIN.TERMS_ID

SQL_Statement

SELECT APIN.ROWID , APIN.INVOICE_ID , APIN.LAST_UPDATE_DATE , APIN.LAST_UPDATED_BY , APIN.VENDOR_ID , APIN.INVOICE_NUM , APIN.SET_OF_BOOKS_ID , APIN.INVOICE_CURRENCY_CODE , APIN.PAYMENT_CURRENCY_CODE , APIN.PAYMENT_CROSS_RATE , APIN.INVOICE_AMOUNT , APIN.VENDOR_SITE_ID , APIN.AMOUNT_PAID , APIN.DISCOUNT_AMOUNT_TAKEN , APIN.INVOICE_DATE , APIN.SOURCE , APIN.INVOICE_TYPE_LOOKUP_CODE , APIN.DESCRIPTION , APIN.BATCH_ID , APIN.AMOUNT_APPLICABLE_TO_DISCOUNT

, APIN.TERMS_ID , APIN.TERMS_DATE , APIN.PAYMENT_METHOD_LOOKUP_CODE , APIN.PAY_GROUP_LOOKUP_CODE , APIN.ACCTS_PAY_CODE_COMBINATION_ID , APIN.PAYMENT_STATUS_FLAG , APIN.CREATION_DATE , APIN.CREATED_BY , APIN.BASE_AMOUNT

, APIN.LAST_UPDATE_LOGIN , APIN.EXCLUSIVE_PAYMENT_FLAG , APIN.PO_HEADER_ID , APIN.FREIGHT_AMOUNT , APIN.GOODS_RECEIVED_DATE , APIN.INVOICE_RECEIVED_DATE , APIN.VOUCHER_NUM , APIN.APPROVED_AMOUNT , APIN.RECURRING_PAYMENT_ID , APIN.EXCHANGE_RATE , APIN.EXCHANGE_RATE_TYPE , APIN.EXCHANGE_DATE , APIN.EARLIEST_SETTLEMENT_DATE

, APIN.DOC_SEQUENCE_ID , APIN.DOC_SEQUENCE_VALUE , APIN.DOC_CATEGORY_CODE , APIN.ATTRIBUTE1 , APIN.ATTRIBUTE2 , APIN.ATTRIBUTE3 , APIN.ATTRIBUTE4 , APIN.ATTRIBUTE5 , APIN.ATTRIBUTE6 , APIN.ATTRIBUTE7 , APIN.ATTRIBUTE8 , APIN.ATTRIBUTE9 , APIN.ATTRIBUTE10 , APIN.ATTRIBUTE11 , APIN.ATTRIBUTE12 , APIN.ATTRIBUTE13 , APIN.ATTRIBUTE14 , APIN.ATTRIBUTE15 , APIN.ATTRIBUTE_CATEGORY , APIN.APPROVAL_STATUS , APIN.APPROVAL_DESCRIPTION , APIN.POSTING_STATUS

, APIN.CANCELLED_DATE , APIN.CANCELLED_BY , APIN.CANCELLED_AMOUNT , APIN.TEMP_CANCELLED_AMOUNT , APIN.USSGL_TRANSACTION_CODE , APIN.USSGL_TRX_CODE_CONTEXT , APIN.PROJECT_ID , APIN.TASK_ID , APIN.EXPENDITURE_TYPE , APIN.EXPENDITURE_ITEM_DATE , APIN.PA_QUANTITY , APIN.EXPENDITURE_ORGANIZATION_ID , APIN.PA_DEFAULT_DIST_CCID

, APIN.PAYMENT_AMOUNT_TOTAL , APIN.AWT_FLAG , APIN.AWT_GROUP_ID , APIN.REFERENCE_1 , APIN.REFERENCE_2 , APIN.ORG_ID , APIN.PRE_WITHHOLDING_AMOUNT , APIN.GLOBAL_ATTRIBUTE_CATEGORY , APIN.GLOBAL_ATTRIBUTE1 , APIN.GLOBAL_ATTRIBUTE2 , APIN.GLOBAL_ATTRIBUTE3 , APIN.GLOBAL_ATTRIBUTE4 , APIN.GLOBAL_ATTRIBUTE5 , APIN.GLOBAL_ATTRIBUTE6 , APIN.GLOBAL_ATTRIBUTE7 , APIN.GLOBAL_ATTRIBUTE8 , APIN.GLOBAL_ATTRIBUTE9 , APIN.GLOBAL_ATTRIBUTE10 , APIN.GLOBAL_ATTRIBUTE11 , APIN.GLOBAL_ATTRIBUTE12 , APIN.GLOBAL_ATTRIBUTE13 , APIN.GLOBAL_ATTRIBUTE14 , APIN.GLOBAL_ATTRIBUTE15 , APIN.GLOBAL_ATTRIBUTE16 , APIN.GLOBAL_ATTRIBUTE17 , APIN.GLOBAL_ATTRIBUTE18 , APIN.GLOBAL_ATTRIBUTE19 , APIN.GLOBAL_ATTRIBUTE20

, APT.NAME FROM AP_INVOICES APIN, AP_TERMS APT WHERE APT.TERM_ID (+) = APIN.TERMS_ID