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

VIEW: APPS.ARBPA_CUSTOMER_TRX_LINE

Object Details
Object Name: ARBPA_CUSTOMER_TRX_LINE
Object Type: VIEW
Owner: APPS
FND Design Data: ViewFND.ARBPA_CUSTOMER_TRX_LINE
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
CUSTOMER_TRX_ID NUMBER (15) Yes
CUSTOMER_TRX_LINE_ID NUMBER (15) Yes
LINE_NUMBER VARCHAR2 (40)
LINE_TYPE VARCHAR2 (20) Yes
DESCRIPTION VARCHAR2 (4000)
QUANTITY VARCHAR2 (40)
UNIT_OF_MEASURE_NAME VARCHAR2 (25)
UNIT_PRICE VARCHAR2 (4000)
EXTENDED_AMOUNT VARCHAR2 (4000)
SALES_ORDER VARCHAR2 (50)
UOM_CODE VARCHAR2 (3)
TRX_NUMBER VARCHAR2 (20) Yes
TAX_EXISTS_FOR_THIS_LINE_FLAG VARCHAR2 (4000)
LINE_TAX_RATE VARCHAR2 (4000)
TAX_CODE VARCHAR2 (4000)
PRINTED_TAX_NAME VARCHAR2 (4000)
INTERFACE_LINE_ATTRIBUTE1 VARCHAR2 (150)
INTERFACE_LINE_ATTRIBUTE2 VARCHAR2 (150)
INTERFACE_LINE_ATTRIBUTE3 VARCHAR2 (150)
INTERFACE_LINE_ATTRIBUTE4 VARCHAR2 (150)
INTERFACE_LINE_ATTRIBUTE5 VARCHAR2 (150)
INTERFACE_LINE_ATTRIBUTE6 VARCHAR2 (150)
INTERFACE_LINE_ATTRIBUTE7 VARCHAR2 (150)
INTERFACE_LINE_ATTRIBUTE8 VARCHAR2 (150)
INTERFACE_LINE_ATTRIBUTE9 VARCHAR2 (150)
INTERFACE_LINE_ATTRIBUTE10 VARCHAR2 (150)
INTERFACE_LINE_ATTRIBUTE11 VARCHAR2 (150)
INTERFACE_LINE_ATTRIBUTE12 VARCHAR2 (150)
INTERFACE_LINE_ATTRIBUTE13 VARCHAR2 (150)
INTERFACE_LINE_ATTRIBUTE14 VARCHAR2 (150)
INTERFACE_LINE_ATTRIBUTE15 VARCHAR2 (150)
UNFORMATTED_UNIT_PRICE VARCHAR2 (40)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
SET_OF_BOOKS_ID NUMBER (15) Yes
REASON_CODE VARCHAR2 (30)
QUANTITY_ORDERED NUMBER

QUANTITY_CREDITED NUMBER

UNIT_STANDARD_PRICE NUMBER

SALES_ORDER_LINE VARCHAR2 (30)
SALES_ORDER_DATE DATE

ACCOUNTING_RULE_DURATION NUMBER (15)
ATTRIBUTE_CATEGORY VARCHAR2 (30)
RULE_START_DATE DATE

INTERFACE_LINE_CONTEXT VARCHAR2 (30)
SALES_ORDER_SOURCE VARCHAR2 (50)
REVENUE_AMOUNT NUMBER

DEFAULT_USSGL_TRANSACTION_CODE VARCHAR2 (30)
DEFAULT_USSGL_TRX_CODE_CONTEXT VARCHAR2 (30)
LAST_PERIOD_TO_CREDIT NUMBER

ITEM_CONTEXT VARCHAR2 (30)
TAX_EXEMPT_FLAG VARCHAR2 (1)
TAX_EXEMPT_NUMBER VARCHAR2 (80)
TAX_EXEMPT_REASON_CODE VARCHAR2 (30)
TAX_VENDOR_RETURN_CODE VARCHAR2 (30)
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (30)
GROSS_UNIT_SELLING_PRICE NUMBER

GROSS_EXTENDED_AMOUNT NUMBER

EXTENDED_ACCTD_AMOUNT NUMBER

MRC_EXTENDED_ACCTD_AMOUNT VARCHAR2 (2000)
ORG_ID NUMBER (15)
GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
TRANSACTION_LINE_NUMBER NUMBER
Yes
TRANSACTION_CURRENCY_CODE VARCHAR2 (15)
TRANSACTION_LINE_DESC VARCHAR2 (4000)
TRANSACTION_DATE DATE
Yes
TRANSACTION_QUANTITY VARCHAR2 (40)
UNIT_SELLING_PRICE VARCHAR2 (4000)
CODE_UNIT_SELLING_PRICE VARCHAR2 (4000)
CODE_LINES_EXTENDED_AMOUNT VARCHAR2 (55)
CODE_TAX_AMOUNT VARCHAR2 (55)
CODE_LINE_GROSS_AMOUNT VARCHAR2 (55)
LINES_EXTENDED_AMOUNT NUMBER
Yes
BILL_TO_CUSTOMER_ID NUMBER (15)
INVENTORY_ITEM_ID NUMBER (15)
COUNTRY_OF_ORIGIN VARCHAR2 (150)
CUSTOMS_DECLARATION_NUMBER VARCHAR2 (150)
TAX_AMOUNT NUMBER

TAX_RATE NUMBER

VAT_TAX_AMOUNT NUMBER

VAT_TAX_RATE NUMBER

EXCISE_TAX_AMOUNT NUMBER

EXCISE_TAX_RATE NUMBER

EXEMPT_TAX_AMOUNT NUMBER

EXEMPT_TAX_RATE NUMBER

TAX_TYPE_CODE VARCHAR2 (30)
ITEM_NAME VARCHAR2 (40)
ITEM_DESCRIPTION VARCHAR2 (240)
ITEM_UOM_CODE VARCHAR2 (3)
ITEM_UOM_NAME VARCHAR2 (25)
TAX_CLASSIF_CODE VARCHAR2 (50)
LINE_GROSS_AMOUNT NUMBER

NULL_VALUE VARCHAR2 (0)
Query Text

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


SELECT CUSTOMER_TRX_ID
,      CUSTOMER_TRX_LINE_ID
,      LINE_NUMBER
,      LINE_TYPE
,      DESCRIPTION
,      QUANTITY
,      UNIT_OF_MEASURE_NAME
,      UNIT_PRICE
,      EXTENDED_AMOUNT
,      SALES_ORDER
,      UOM_CODE
,      TRX_NUMBER
,      TAX_EXISTS_FOR_THIS_LINE_FLAG
,      LINE_TAX_RATE
,      TAX_CODE
,      PRINTED_TAX_NAME
,      INTERFACE_LINE_ATTRIBUTE1
,      INTERFACE_LINE_ATTRIBUTE2
,      INTERFACE_LINE_ATTRIBUTE3
,      INTERFACE_LINE_ATTRIBUTE4
,      INTERFACE_LINE_ATTRIBUTE5
,      INTERFACE_LINE_ATTRIBUTE6
,      INTERFACE_LINE_ATTRIBUTE7
,      INTERFACE_LINE_ATTRIBUTE8
,      INTERFACE_LINE_ATTRIBUTE9
,      INTERFACE_LINE_ATTRIBUTE10
,      INTERFACE_LINE_ATTRIBUTE11
,      INTERFACE_LINE_ATTRIBUTE12
,      INTERFACE_LINE_ATTRIBUTE13
,      INTERFACE_LINE_ATTRIBUTE14
,      INTERFACE_LINE_ATTRIBUTE15
,      UNFORMATTED_UNIT_PRICE
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SET_OF_BOOKS_ID
,      REASON_CODE
,      QUANTITY_ORDERED
,      QUANTITY_CREDITED
,      UNIT_STANDARD_PRICE
,      SALES_ORDER_LINE
,      SALES_ORDER_DATE
,      ACCOUNTING_RULE_DURATION
,      ATTRIBUTE_CATEGORY
,      RULE_START_DATE
,      INTERFACE_LINE_CONTEXT
,      SALES_ORDER_SOURCE
,      REVENUE_AMOUNT
,      DEFAULT_USSGL_TRANSACTION_CODE
,      DEFAULT_USSGL_TRX_CODE_CONTEXT
,      LAST_PERIOD_TO_CREDIT
,      ITEM_CONTEXT
,      TAX_EXEMPT_FLAG
,      TAX_EXEMPT_NUMBER
,      TAX_EXEMPT_REASON_CODE
,      TAX_VENDOR_RETURN_CODE
,      GLOBAL_ATTRIBUTE_CATEGORY
,      GROSS_UNIT_SELLING_PRICE
,      GROSS_EXTENDED_AMOUNT
,      EXTENDED_ACCTD_AMOUNT
,      MRC_EXTENDED_ACCTD_AMOUNT
,      ORG_ID
,      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
,      TRANSACTION_LINE_NUMBER
,      TRANSACTION_CURRENCY_CODE
,      TRANSACTION_LINE_DESC
,      TRANSACTION_DATE
,      TRANSACTION_QUANTITY
,      UNIT_SELLING_PRICE
,      CODE_UNIT_SELLING_PRICE
,      CODE_LINES_EXTENDED_AMOUNT
,      CODE_TAX_AMOUNT
,      CODE_LINE_GROSS_AMOUNT
,      LINES_EXTENDED_AMOUNT
,      BILL_TO_CUSTOMER_ID
,      INVENTORY_ITEM_ID
,      COUNTRY_OF_ORIGIN
,      CUSTOMS_DECLARATION_NUMBER
,      TAX_AMOUNT
,      TAX_RATE
,      VAT_TAX_AMOUNT
,      VAT_TAX_RATE
,      EXCISE_TAX_AMOUNT
,      EXCISE_TAX_RATE
,      EXEMPT_TAX_AMOUNT
,      EXEMPT_TAX_RATE
,      TAX_TYPE_CODE
,      ITEM_NAME
,      ITEM_DESCRIPTION
,      ITEM_UOM_CODE
,      ITEM_UOM_NAME
,      TAX_CLASSIF_CODE
,      LINE_GROSS_AMOUNT
,      NULL_VALUE
FROM APPS.ARBPA_CUSTOMER_TRX_LINE;

Dependencies

[top of page]

APPS.ARBPA_CUSTOMER_TRX_LINE references the following:

SchemaAPPS
PL/SQL PackageAR_BPA_UTILS_PKG - show dependent code
PL/SQL PackageAR_INVOICE_SQL_FUNC_PUB - show dependent code
PL/SQL PackageFND_CURRENCY - show dependent code
SynonymMTL_PARAMETERS
SynonymMTL_SYSTEM_ITEMS_KFV
SynonymMTL_UNITS_OF_MEASURE
SynonymRA_CUSTOMER_TRX
SynonymRA_CUSTOMER_TRX_LINES
SynonymZX_LINES

APPS.ARBPA_CUSTOMER_TRX_LINE is not referenced by any database object