DBA Data[Home] [Help] [Dependency Information]

VIEW: AP.AP_MC_INVOICE_DISTS#

Object Details
Object Name: AP_MC_INVOICE_DISTS#
Object Type: VIEW
Owner: AP
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
INVOICE_DISTRIBUTION_ID NUMBER (15) Yes
INVOICE_ID NUMBER (15) Yes
DISTRIBUTION_LINE_NUMBER NUMBER (15) Yes
SET_OF_BOOKS_ID NUMBER (15) Yes
DIST_CODE_COMBINATION_ID NUMBER (15) Yes
AMOUNT NUMBER

BASE_AMOUNT NUMBER

BASE_INVOICE_PRICE_VARIANCE NUMBER

EXCHANGE_RATE_VARIANCE NUMBER

RATE_VAR_CODE_COMBINATION_ID NUMBER (15)
EXCHANGE_DATE DATE

EXCHANGE_RATE NUMBER

EXCHANGE_RATE_TYPE VARCHAR2 (30)
RECEIPT_CONVERSION_RATE NUMBER

LINE_TYPE_LOOKUP_CODE VARCHAR2 (25) Yes
QUANTITY_INVOICED NUMBER

AMOUNT_TO_POST NUMBER

BASE_AMOUNT_TO_POST NUMBER

UPGRADE_POSTED_AMT NUMBER

UPGRADE_BASE_POSTED_AMT NUMBER

POSTED_AMOUNT NUMBER

POSTED_BASE_AMOUNT NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT INVOICE_DISTRIBUTION_ID
,      INVOICE_ID
,      DISTRIBUTION_LINE_NUMBER
,      SET_OF_BOOKS_ID
,      DIST_CODE_COMBINATION_ID
,      AMOUNT
,      BASE_AMOUNT
,      BASE_INVOICE_PRICE_VARIANCE
,      EXCHANGE_RATE_VARIANCE
,      RATE_VAR_CODE_COMBINATION_ID
,      EXCHANGE_DATE
,      EXCHANGE_RATE
,      EXCHANGE_RATE_TYPE
,      RECEIPT_CONVERSION_RATE
,      LINE_TYPE_LOOKUP_CODE
,      QUANTITY_INVOICED
,      AMOUNT_TO_POST
,      BASE_AMOUNT_TO_POST
,      UPGRADE_POSTED_AMT
,      UPGRADE_BASE_POSTED_AMT
,      POSTED_AMOUNT
,      POSTED_BASE_AMOUNT
FROM AP.AP_MC_INVOICE_DISTS#;

Dependencies

[top of page]

AP.AP_MC_INVOICE_DISTS# references the following:

SchemaAP
TableAP_MC_INVOICE_DISTS
AP.AP_MC_INVOICE_DISTS# is referenced by following:

SchemaAPPS
SynonymAP_MC_INVOICE_DISTS