[Home] [Help] [Dependency Information]

VIEW: APPS.JAI_RCV_ACCT_DIST_V

Object Details

Object Name:	JAI_RCV_ACCT_DIST_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	JA.JAI_RCV_ACCT_DIST_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

Query Text

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

SELECT PO_NUMBER
,      CODE_COMBINATION_ID
,      ITEM_ID
,      TRANSACTION_ID
,      ACCOUNTING_DATE
,      PRIMARY_QUANTITY
,      PRIMARY_UOM
,      PO_UNIT_PRICE
,      DELIVER_TO_LOCATION
,      CURRENCY_CODE
,      REQUISITION_LINE_NUMBER
,      LINE_NUMBER
,      RECEIPT_NUMBER
,      ITEM_REVISION
,      CATEGORY_ID
,      ITEM_DESCRIPTION
,      DESTINATION_TYPE
,      TRANSACTION_TYPE
,      LOCATION_ID
,      SUBINVENTORY
,      ORGANIZATION_ID
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_DATE
,      CURRENCY_CONVERSION_RATE
,      PO_REVISION_NUM
,      QUANTITY
,      DEPARTMENT_CODE
,      SOURCE_DOC_UNIT_OF_MEASURE
,      SOURCE_DOC_QUANTITY
,      TOTAL_SOURCE_DOC_QUANTITY
,      SHIPMENT_NUMBER
,      PACKING_SLIP
,      VENDOR_ID
,      LOCATOR_ID
,      WIP_ENTITY_ID
,      WIP_LINE_ID
,      WIP_REPETITIVE_SCHEDULE_ID
,      WIP_OPERATION_SEQ_NUM
,      WIP_RESOURCE_SEQ_NUM
,      BOM_RESOURCE_ID
,      ENTERED_DR
,      ENTERED_CR
,      FROM_TYPE
FROM APPS.JAI_RCV_ACCT_DIST_V;

Dependencies

[top of page]

APPS

FND_GLOBAL - show dependent code

GL_CODE_COMBINATIONS

HR_GENERAL - show dependent code

HR_LOCATIONS

JAI_RCV_SUBLED_ENTRIES

PO_HEADERS

PO_LINES

PO_LOOKUP_CODES

PO_REQUISITION_LINES

RCV_SHIPMENT_HEADERS

RCV_SHIPMENT_LINES

RCV_TRANSACTIONS

APPS.JAI_RCV_ACCT_DIST_V is not referenced by any database object