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


VIEW: APPS.AP_EXPENSE_FEED_DISTS_V

Object Details
Object Name: AP_EXPENSE_FEED_DISTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewSQLAP.AP_EXPENSE_FEED_DISTS_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
FEED_LINE_ID NUMBER (15) Yes
FEED_DISTRIBUTION_ID NUMBER (15) Yes
INVOICE_ID NUMBER (15)

INVOICE_LINE_ID NUMBER (15)

AMOUNT NUMBER
Yes
DIST_CODE_COMBINATION_ID NUMBER (15) Yes
STATUS_CHANGE_DATE DATE


STATUS_LOOKUP_CODE VARCHAR2 (25)

INVOICED_FLAG VARCHAR2 (1)

AMOUNT_INCLUDES_TAX_FLAG VARCHAR2 (1)

TAX_CODE VARCHAR2 (15)

MANAGER_APPROVAL_ID NUMBER (15)

EMPLOYEE_VERIFICATION_ID NUMBER (15)
ACCOUNT_SEGMENT_VALUE VARCHAR2 (25)
COST_CENTER VARCHAR2 (25)
ORG_ID NUMBER (15)
Organization identifier
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.
CREATED_BY NUMBER (15)
Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
ATTRIBUTE_CATEGORY VARCHAR2 (150)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
EMPLOYEE_ID NUMBER (15)

CARD_ID NUMBER (15)

CARD_PROGRAM_ID NUMBER (15) Yes
CARD_NUMBER VARCHAR2 (30)
REFERENCE_NUMBER VARCHAR2 (240)
ALT_REFERENCE_NUMBER VARCHAR2 (240)
CUSTOMER_CODE VARCHAR2 (240)
LINE_AMOUNT NUMBER
Yes
ORIGINAL_CURRENCY_AMOUNT NUMBER

ORIGINAL_CURRENCY_CODE VARCHAR2 (15)
POSTED_CURRENCY_CODE VARCHAR2 (15)
CURRENCY_CONVERSION_RATE NUMBER

TRANSACTION_DATE DATE

POSTED_DATE DATE
Yes
RECORD_TYPE VARCHAR2 (25)
CREATE_DISTRIBUTION_FLAG VARCHAR2 (1)
MERCHANT_NAME VARCHAR2 (80)
MERCHANT_NUMBER VARCHAR2 (80)
CARD_CODE_VALUE VARCHAR2 (80)
CODE_ID NUMBER (15)
INDUSTRY_CODE1 VARCHAR2 (80)
INDUSTRY_CODE2 VARCHAR2 (80)
ALT_MERCHANT_NUMBER VARCHAR2 (80)
MERCHANT_ADDRESS1 VARCHAR2 (35)
MERCHANT_ADDRESS2 VARCHAR2 (35)
MERCHANT_ADDRESS3 VARCHAR2 (35)
MERCHANT_ADDRESS4 VARCHAR2 (35)
MERCHANT_CITY VARCHAR2 (25)
MERCHANT_PROVINCE_STATE VARCHAR2 (25)
MERCHANT_POSTAL_CODE VARCHAR2 (20)
MERCHANT_COUNTRY VARCHAR2 (25)
MERCHANT_PHONE VARCHAR2 (25)
SHIP_FROM_POSTAL_CODE VARCHAR2 (25)
SHIP_FROM_COUNTRY VARCHAR2 (25)
SHIP_TO_POSTAL_CODE VARCHAR2 (25)
SHIP_TO_COUNTRY VARCHAR2 (25)
MERCHANT_TAX_ID VARCHAR2 (80)
TAX_PAID_FLAG VARCHAR2 (1)
TAX_AMOUNT NUMBER

TAX_RATE NUMBER

TAX_TYPE VARCHAR2 (25)
ALT_MERCHANT_TAX_ID VARCHAR2 (80)
ALT_TAX_PAID_FLAG VARCHAR2 (1)
ALT_TAX_AMOUNT NUMBER

ALT_TAX_RATE NUMBER

ALT_TAX_TYPE VARCHAR2 (25)
FREIGHT_AMOUNT NUMBER

DUTY_AMOUNT NUMBER

MERCHANT_BUSINESS_TYPE VARCHAR2 (80)
MERCHANT_OWNER_TYPE VARCHAR2 (80)
PRODUCT_CODE VARCHAR2 (80)
ITEM_DESCRIPTION VARCHAR2 (240)
ITEM_QUANTITY NUMBER

ITEM_UOM VARCHAR2 (80)
EXTENDED_ITEM_AMOUNT NUMBER

DISCOUNT_INDICATOR VARCHAR2 (1)
DISCOUNT_AMOUNT NUMBER

LINE_EMP_VERIFICATION_ID NUMBER (15)
LINE_DESCRIPTION VARCHAR2 (240)
REJECT_CODE VARCHAR2 (25)
LINE_ATTRIBUTE_CATEGORY VARCHAR2 (150)
LINE_ATTRIBUTE1 VARCHAR2 (150)
LINE_ATTRIBUTE2 VARCHAR2 (150)
LINE_ATTRIBUTE3 VARCHAR2 (150)
LINE_ATTRIBUTE4 VARCHAR2 (150)
LINE_ATTRIBUTE5 VARCHAR2 (150)
LINE_ATTRIBUTE6 VARCHAR2 (150)
LINE_ATTRIBUTE7 VARCHAR2 (150)
LINE_ATTRIBUTE8 VARCHAR2 (150)
LINE_ATTRIBUTE9 VARCHAR2 (150)
LINE_ATTRIBUTE10 VARCHAR2 (150)
LINE_ATTRIBUTE11 VARCHAR2 (150)
LINE_ATTRIBUTE12 VARCHAR2 (150)
LINE_ATTRIBUTE13 VARCHAR2 (150)
LINE_ATTRIBUTE14 VARCHAR2 (150)
LINE_ATTRIBUTE15 VARCHAR2 (150)
LINE_ATTRIBUTE16 VARCHAR2 (150)
LINE_ATTRIBUTE17 VARCHAR2 (150)
LINE_ATTRIBUTE18 VARCHAR2 (150)
LINE_ATTRIBUTE19 VARCHAR2 (150)
LINE_ATTRIBUTE20 VARCHAR2 (150)
LINE_ATTRIBUTE21 VARCHAR2 (150)
LINE_ATTRIBUTE22 VARCHAR2 (150)
LINE_ATTRIBUTE23 VARCHAR2 (150)
LINE_ATTRIBUTE24 VARCHAR2 (150)
LINE_ATTRIBUTE25 VARCHAR2 (150)
LINE_ATTRIBUTE26 VARCHAR2 (150)
LINE_ATTRIBUTE27 VARCHAR2 (150)
LINE_ATTRIBUTE28 VARCHAR2 (150)
LINE_ATTRIBUTE29 VARCHAR2 (150)
LINE_ATTRIBUTE30 VARCHAR2 (150)
SET_UP_CARD_NUMBER VARCHAR2 (30)
CARD_EMPLOYEE_ID NUMBER (15)
DEPARTMENT_NAME VARCHAR2 (80)
CARD_PROGRAM_NAME VARCHAR2 (80) Yes
CARD_TYPE_LOOKUP_CODE VARCHAR2 (25)
PROFILE_NAME VARCHAR2 (80) Yes
DIST_STATUS VARCHAR2 (80)
FULL_NAME VARCHAR2 (240)
DESCRIPTION VARCHAR2 (240)
SUPERVISOR_ID NUMBER (10)
PROGRAM_ADMIN_EMPLOYEE_ID NUMBER (15)
PROFILE_ADMIN_EMPLOYEE_ID NUMBER (15)
CONC_REQUEST_ID NUMBER (15)
DISPLAYED_AMOUNT VARCHAR2 (4000)
MASKED_CC_NUMBER VARCHAR2 (30)
Query Text

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


SELECT FEED_LINE_ID
,      FEED_DISTRIBUTION_ID
,      INVOICE_ID
,      INVOICE_LINE_ID
,      AMOUNT
,      DIST_CODE_COMBINATION_ID
,      STATUS_CHANGE_DATE
,      STATUS_LOOKUP_CODE
,      INVOICED_FLAG
,      AMOUNT_INCLUDES_TAX_FLAG
,      TAX_CODE
,      MANAGER_APPROVAL_ID
,      EMPLOYEE_VERIFICATION_ID
,      ACCOUNT_SEGMENT_VALUE
,      COST_CENTER
,      ORG_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      EMPLOYEE_ID
,      CARD_ID
,      CARD_PROGRAM_ID
,      CARD_NUMBER
,      REFERENCE_NUMBER
,      ALT_REFERENCE_NUMBER
,      CUSTOMER_CODE
,      LINE_AMOUNT
,      ORIGINAL_CURRENCY_AMOUNT
,      ORIGINAL_CURRENCY_CODE
,      POSTED_CURRENCY_CODE
,      CURRENCY_CONVERSION_RATE
,      TRANSACTION_DATE
,      POSTED_DATE
,      RECORD_TYPE
,      CREATE_DISTRIBUTION_FLAG
,      MERCHANT_NAME
,      MERCHANT_NUMBER
,      CARD_CODE_VALUE
,      CODE_ID
,      INDUSTRY_CODE1
,      INDUSTRY_CODE2
,      ALT_MERCHANT_NUMBER
,      MERCHANT_ADDRESS1
,      MERCHANT_ADDRESS2
,      MERCHANT_ADDRESS3
,      MERCHANT_ADDRESS4
,      MERCHANT_CITY
,      MERCHANT_PROVINCE_STATE
,      MERCHANT_POSTAL_CODE
,      MERCHANT_COUNTRY
,      MERCHANT_PHONE
,      SHIP_FROM_POSTAL_CODE
,      SHIP_FROM_COUNTRY
,      SHIP_TO_POSTAL_CODE
,      SHIP_TO_COUNTRY
,      MERCHANT_TAX_ID
,      TAX_PAID_FLAG
,      TAX_AMOUNT
,      TAX_RATE
,      TAX_TYPE
,      ALT_MERCHANT_TAX_ID
,      ALT_TAX_PAID_FLAG
,      ALT_TAX_AMOUNT
,      ALT_TAX_RATE
,      ALT_TAX_TYPE
,      FREIGHT_AMOUNT
,      DUTY_AMOUNT
,      MERCHANT_BUSINESS_TYPE
,      MERCHANT_OWNER_TYPE
,      PRODUCT_CODE
,      ITEM_DESCRIPTION
,      ITEM_QUANTITY
,      ITEM_UOM
,      EXTENDED_ITEM_AMOUNT
,      DISCOUNT_INDICATOR
,      DISCOUNT_AMOUNT
,      LINE_EMP_VERIFICATION_ID
,      LINE_DESCRIPTION
,      REJECT_CODE
,      LINE_ATTRIBUTE_CATEGORY
,      LINE_ATTRIBUTE1
,      LINE_ATTRIBUTE2
,      LINE_ATTRIBUTE3
,      LINE_ATTRIBUTE4
,      LINE_ATTRIBUTE5
,      LINE_ATTRIBUTE6
,      LINE_ATTRIBUTE7
,      LINE_ATTRIBUTE8
,      LINE_ATTRIBUTE9
,      LINE_ATTRIBUTE10
,      LINE_ATTRIBUTE11
,      LINE_ATTRIBUTE12
,      LINE_ATTRIBUTE13
,      LINE_ATTRIBUTE14
,      LINE_ATTRIBUTE15
,      LINE_ATTRIBUTE16
,      LINE_ATTRIBUTE17
,      LINE_ATTRIBUTE18
,      LINE_ATTRIBUTE19
,      LINE_ATTRIBUTE20
,      LINE_ATTRIBUTE21
,      LINE_ATTRIBUTE22
,      LINE_ATTRIBUTE23
,      LINE_ATTRIBUTE24
,      LINE_ATTRIBUTE25
,      LINE_ATTRIBUTE26
,      LINE_ATTRIBUTE27
,      LINE_ATTRIBUTE28
,      LINE_ATTRIBUTE29
,      LINE_ATTRIBUTE30
,      SET_UP_CARD_NUMBER
,      CARD_EMPLOYEE_ID
,      DEPARTMENT_NAME
,      CARD_PROGRAM_NAME
,      CARD_TYPE_LOOKUP_CODE
,      PROFILE_NAME
,      DIST_STATUS
,      FULL_NAME
,      DESCRIPTION
,      SUPERVISOR_ID
,      PROGRAM_ADMIN_EMPLOYEE_ID
,      PROFILE_ADMIN_EMPLOYEE_ID
,      CONC_REQUEST_ID
,      DISPLAYED_AMOUNT
,      MASKED_CC_NUMBER
FROM APPS.AP_EXPENSE_FEED_DISTS_V;

Dependencies

[top of page]

APPS.AP_EXPENSE_FEED_DISTS_V references the following:

SchemaAPPS
SynonymAP_CARDS
SynonymAP_CARD_PROFILES
SynonymAP_CARD_PROGRAMS
SynonymAP_EXPENSE_FEED_DISTS
SynonymAP_EXPENSE_FEED_LINES
ViewAP_LOOKUP_CODES
PL/SQL PackageFND_CURRENCY - show dependent code
PL/SQL PackageFND_GLOBAL - show dependent code
PL/SQL PackageFND_PROFILE - show dependent code
ViewHR_EMPLOYEES_CURRENT_V
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
ViewIBY_FNDCPT_PAYER_ALL_INSTRS_V

APPS.AP_EXPENSE_FEED_DISTS_V is not referenced by any database object