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


VIEW: APPS.PO_DISTRIBUTIONS_INQ_V

Object Details
Object Name: PO_DISTRIBUTIONS_INQ_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPO.PO_DISTRIBUTIONS_INQ_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)

AMOUNT_BILLED NUMBER


DESTINATION_CONTEXT VARCHAR2 (30)

DESTINATION_SUBINVENTORY VARCHAR2 (10)

DISTRIBUTION_NUM NUMBER


ENCUMBERED_AMOUNT NUMBER


EXPENDITURE_ITEM_DATE DATE


EXPENDITURE_TYPE VARCHAR2 (30)

GL_CANCELLED_DATE DATE


GL_CLOSED_DATE DATE


GL_ENCUMBERED_DATE DATE


GL_ENCUMBERED_PERIOD_NAME VARCHAR2 (15)

GOVERNMENT_CONTEXT VARCHAR2 (30)

PROJECT_ACCOUNTING_CONTEXT VARCHAR2 (30)

QUANTITY_BILLED NUMBER


QUANTITY_CANCELLED NUMBER


QUANTITY_DELIVERED NUMBER


QUANTITY_ORDERED NUMBER


RATE NUMBER


RATE_DATE DATE


REQ_HEADER_REFERENCE_NUM VARCHAR2 (25)

REQ_LINE_REFERENCE_NUM VARCHAR2 (25)

UNENCUMBERED_AMOUNT NUMBER


UNENCUMBERED_QUANTITY NUMBER


WIP_OPERATION_SEQ_NUM NUMBER


WIP_RESOURCE_SEQ_NUM NUMBER


ACCRUAL_ACCOUNT_ID NUMBER


BOM_RESOURCE_ID NUMBER


BUDGET_ACCOUNT_ID NUMBER


CODE_COMBINATION_ID NUMBER


DELIVER_TO_LOCATION_ID NUMBER


DELIVER_TO_PERSON_ID NUMBER (9)

DESTINATION_ORGANIZATION_ID NUMBER


EXPENDITURE_ORGANIZATION_ID NUMBER


LINE_LOCATION_ID NUMBER


PO_DISTRIBUTION_ID NUMBER


PO_HEADER_ID NUMBER


PO_LINE_ID NUMBER


PO_RELEASE_ID NUMBER


PROJECT_ID NUMBER


REQ_DISTRIBUTION_ID NUMBER


SET_OF_BOOKS_ID NUMBER


SOURCE_DISTRIBUTION_ID NUMBER


TASK_ID NUMBER


VARIANCE_ACCOUNT_ID NUMBER


WIP_ENTITY_ID NUMBER


WIP_LINE_ID NUMBER


WIP_REPETITIVE_SCHEDULE_ID NUMBER


DESTINATION_TYPE_CODE VARCHAR2 (25)

FAILED_FUNDS_LOOKUP_CODE VARCHAR2 (25)

USSGL_TRANSACTION_CODE VARCHAR2 (30)

ACCRUED_FLAG VARCHAR2 (1)

ACCRUE_ON_RECEIPT_FLAG VARCHAR2 (1)

ENCUMBERED_FLAG VARCHAR2 (1)

PREVENT_ENCUMBRANCE_FLAG VARCHAR2 (1)

CREATED_BY NUMBER

Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER

Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
PROGRAM_APPLICATION_ID NUMBER

Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER

Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
REQUEST_ID NUMBER

Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
ATTRIBUTE_CATEGORY VARCHAR2 (30)
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
REQ_DISTRIBUTION_NUM NUMBER


ONLINE_REQ VARCHAR2 (1)

REQ_LINE_NUM VARCHAR2 (40)

REQUISITION_HEADER_ID NUMBER


REQ_NUM VARCHAR2 (25)

DELIVER_TO_LOCATION VARCHAR2 (0)

DESTINATION_TYPE VARCHAR2 (0)

DESTINATION_ORGANIZATION VARCHAR2 (0)

PROJECT VARCHAR2 (0)

TASK VARCHAR2 (0)

EXPENDITURE_ORGANIZATION VARCHAR2 (0)

WIP_ENTITY VARCHAR2 (240)

WIP_LINE VARCHAR2 (0)

BOM_RESOURCE VARCHAR2 (0)

BOM_RESOURCE_UNIT VARCHAR2 (0)

PO_NUM VARCHAR2 (20)

TYPE_LOOKUP_CODE VARCHAR2 (25)

RELEASE_NUM NUMBER


RELEASE_TYPE VARCHAR2 (25)

AGENT_ID NUMBER (9)

VENDOR_ID NUMBER


VENDOR_NAME VARCHAR2 (0)
VENDOR_SITE_ID NUMBER


VENDOR_SITE_CODE VARCHAR2 (0)

BILL_TO_LOCATION_ID NUMBER


BILL_TO_LOCATION VARCHAR2 (0)

CURRENCY_CODE VARCHAR2 (15)

AUTHORIZATION_STATUS VARCHAR2 (25)

REVISION_NUM NUMBER


DOC_TYPE_NAME VARCHAR2 (80)

AUTHORIZATION_STATUS_DSP VARCHAR2 (0)

ORDER_DATE DATE


APPROVED_DATE DATE


REVISED_DATE DATE


TERMS_NAME VARCHAR2 (0)

ACCEPTANCE_DUE_DATE DATE


LINE_NUM NUMBER


LINE_TYPE_ID NUMBER


LINE_TYPE VARCHAR2 (25)

ITEM_ID NUMBER


ITEM_REVISION VARCHAR2 (3)

ITEM_DESCRIPTION VARCHAR2 (240)

CATEGORY_ID NUMBER


CONTRACT_NUM VARCHAR2 (25)

UNIT_MEAS_LOOKUP_CODE VARCHAR2 (25)

VENDOR_PRODUCT_NUM VARCHAR2 (25)

SHIPMENT_NUM NUMBER


SHIP_TO_LOCATION VARCHAR2 (0)

NEED_BY_DATE DATE


PRICE_OVERRIDE NUMBER


TAXABLE_FLAG VARCHAR2 (1)

SHIP_TO_ORGANIZATION VARCHAR2 (0)

SHIPMENT_TYPE VARCHAR2 (25)

SHIPMENT_TYPE_DSP VARCHAR2 (0)

CLOSED_CODE VARCHAR2 (30)

CLOSED_CODE_DSP VARCHAR2 (0)

CLOSED_DATE DATE


CLOSED_BY NUMBER

MATCHING_TYPE VARCHAR2 (5)

END_ITEM_UNIT_NUMBER VARCHAR2 (30)
RECOVERY_RATE NUMBER

OKE_CONTRACT_LINE_ID NUMBER

OKE_CONTRACT_DELIVERABLE_ID NUMBER

VMI_FLAG VARCHAR2 (1)
Is set to Y if this is a distribution for a VMI shipment
CONSIGNED_CONSUMPTION_FLAG VARCHAR2 (1)
Consigned Consumption Flag
CONSIGNED_FLAG VARCHAR2 (1)
Consigned Flag
CONTRACT_ID NUMBER

Contract PA reference on a line. Applicable on Standard PO only. Foreign key to PO_HEADER_ID in PO_HEADERS_ALL
AMOUNT_ORDERED NUMBER

Amount Ordered
AMOUNT_DELIVERED NUMBER

Amount Delivered
AMOUNT_CANCELLED NUMBER

Amount Cancelled
INVOICE_ADJUSTMENT_FLAG VARCHAR2 (1)
Flag to indicate invoice adjustment
AWARD_ID NUMBER (15)
Award identifier. References GMS_AWARD_DISTRIBUTIONS.award_set_id.
REQUESTING_ORG_ID NUMBER

Requesting Operating Unit ID
ORG_ID NUMBER

Organization identifier
OWNING_ORG_ID NUMBER

DEST_CHARGE_ACCOUNT_ID NUMBER

Destination Charge Account ID
DEST_VARIANCE_ACCOUNT_ID NUMBER

Destination Variance Account ID
SECURITY_LEVEL_CODE VARCHAR2 (25)
STYLE_ID NUMBER

Identifies the Purchasing Style associated with the document
Query Text

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


SELECT ROW_ID
,      AMOUNT_BILLED
,      DESTINATION_CONTEXT
,      DESTINATION_SUBINVENTORY
,      DISTRIBUTION_NUM
,      ENCUMBERED_AMOUNT
,      EXPENDITURE_ITEM_DATE
,      EXPENDITURE_TYPE
,      GL_CANCELLED_DATE
,      GL_CLOSED_DATE
,      GL_ENCUMBERED_DATE
,      GL_ENCUMBERED_PERIOD_NAME
,      GOVERNMENT_CONTEXT
,      PROJECT_ACCOUNTING_CONTEXT
,      QUANTITY_BILLED
,      QUANTITY_CANCELLED
,      QUANTITY_DELIVERED
,      QUANTITY_ORDERED
,      RATE
,      RATE_DATE
,      REQ_HEADER_REFERENCE_NUM
,      REQ_LINE_REFERENCE_NUM
,      UNENCUMBERED_AMOUNT
,      UNENCUMBERED_QUANTITY
,      WIP_OPERATION_SEQ_NUM
,      WIP_RESOURCE_SEQ_NUM
,      ACCRUAL_ACCOUNT_ID
,      BOM_RESOURCE_ID
,      BUDGET_ACCOUNT_ID
,      CODE_COMBINATION_ID
,      DELIVER_TO_LOCATION_ID
,      DELIVER_TO_PERSON_ID
,      DESTINATION_ORGANIZATION_ID
,      EXPENDITURE_ORGANIZATION_ID
,      LINE_LOCATION_ID
,      PO_DISTRIBUTION_ID
,      PO_HEADER_ID
,      PO_LINE_ID
,      PO_RELEASE_ID
,      PROJECT_ID
,      REQ_DISTRIBUTION_ID
,      SET_OF_BOOKS_ID
,      SOURCE_DISTRIBUTION_ID
,      TASK_ID
,      VARIANCE_ACCOUNT_ID
,      WIP_ENTITY_ID
,      WIP_LINE_ID
,      WIP_REPETITIVE_SCHEDULE_ID
,      DESTINATION_TYPE_CODE
,      FAILED_FUNDS_LOOKUP_CODE
,      USSGL_TRANSACTION_CODE
,      ACCRUED_FLAG
,      ACCRUE_ON_RECEIPT_FLAG
,      ENCUMBERED_FLAG
,      PREVENT_ENCUMBRANCE_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      REQ_DISTRIBUTION_NUM
,      ONLINE_REQ
,      REQ_LINE_NUM
,      REQUISITION_HEADER_ID
,      REQ_NUM
,      DELIVER_TO_LOCATION
,      DESTINATION_TYPE
,      DESTINATION_ORGANIZATION
,      PROJECT
,      TASK
,      EXPENDITURE_ORGANIZATION
,      WIP_ENTITY
,      WIP_LINE
,      BOM_RESOURCE
,      BOM_RESOURCE_UNIT
,      PO_NUM
,      TYPE_LOOKUP_CODE
,      RELEASE_NUM
,      RELEASE_TYPE
,      AGENT_ID
,      VENDOR_ID
,      VENDOR_NAME
,      VENDOR_SITE_ID
,      VENDOR_SITE_CODE
,      BILL_TO_LOCATION_ID
,      BILL_TO_LOCATION
,      CURRENCY_CODE
,      AUTHORIZATION_STATUS
,      REVISION_NUM
,      DOC_TYPE_NAME
,      AUTHORIZATION_STATUS_DSP
,      ORDER_DATE
,      APPROVED_DATE
,      REVISED_DATE
,      TERMS_NAME
,      ACCEPTANCE_DUE_DATE
,      LINE_NUM
,      LINE_TYPE_ID
,      LINE_TYPE
,      ITEM_ID
,      ITEM_REVISION
,      ITEM_DESCRIPTION
,      CATEGORY_ID
,      CONTRACT_NUM
,      UNIT_MEAS_LOOKUP_CODE
,      VENDOR_PRODUCT_NUM
,      SHIPMENT_NUM
,      SHIP_TO_LOCATION
,      NEED_BY_DATE
,      PRICE_OVERRIDE
,      TAXABLE_FLAG
,      SHIP_TO_ORGANIZATION
,      SHIPMENT_TYPE
,      SHIPMENT_TYPE_DSP
,      CLOSED_CODE
,      CLOSED_CODE_DSP
,      CLOSED_DATE
,      CLOSED_BY
,      MATCHING_TYPE
,      END_ITEM_UNIT_NUMBER
,      RECOVERY_RATE
,      OKE_CONTRACT_LINE_ID
,      OKE_CONTRACT_DELIVERABLE_ID
,      VMI_FLAG
,      CONSIGNED_CONSUMPTION_FLAG
,      CONSIGNED_FLAG
,      CONTRACT_ID
,      AMOUNT_ORDERED
,      AMOUNT_DELIVERED
,      AMOUNT_CANCELLED
,      INVOICE_ADJUSTMENT_FLAG
,      AWARD_ID
,      REQUESTING_ORG_ID
,      ORG_ID
,      OWNING_ORG_ID
,      DEST_CHARGE_ACCOUNT_ID
,      DEST_VARIANCE_ACCOUNT_ID
,      SECURITY_LEVEL_CODE
,      STYLE_ID
FROM APPS.PO_DISTRIBUTIONS_INQ_V;

Dependencies

[top of page]

APPS.PO_DISTRIBUTIONS_INQ_V references the following:

SchemaAPPS
SynonymPO_DISTRIBUTIONS_ALL
SynonymPO_DOCUMENT_TYPES_ALL_B
SynonymPO_DOCUMENT_TYPES_ALL_TL
SynonymPO_DOC_STYLE_HEADERS
SynonymPO_HEADERS_ALL
SynonymPO_LINES_ALL
SynonymPO_LINE_LOCATIONS_ALL
SynonymPO_LINE_TYPES_TL
SynonymPO_RELEASES_ALL
SynonymPO_REQUISITION_HEADERS_ALL
SynonymPO_REQUISITION_LINES_ALL
SynonymPO_REQ_DISTRIBUTIONS_ALL
SynonymPO_SYSTEM_PARAMETERS
SynonymWIP_ENTITIES

APPS.PO_DISTRIBUTIONS_INQ_V is not referenced by any database object