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


VIEW: APPS.PO_DISTS_REF_V

Object Details
Object Name: PO_DISTS_REF_V
Object Type: VIEW
Owner: APPS
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
PO_DISTRIBUTION_ID NUMBER
Yes Document distribution unique identifier. Primary key for this table.
PO_DISTRIBUTION_NUMBER NUMBER
Yes Distribution number
PO_DISTRIBUTION_TYPE VARCHAR2 (25)
-- FPJ Encumbrance Rewrite project
PO_LINE_LOCATION_ID NUMBER

Document shipment schedule unique identifier. References PO_LINES_LOCATIONS_ALL.LINE_LOCATION_ID.
PO_SHIPMENT_NUMBER NUMBER

Shipment line number
PO_LINE_ID NUMBER

Document line unique identifier. References PO_LINES_ALL.PO_LINE_ID.
PO_HEADER_ID NUMBER
Yes Document header unique identifier. References PO_HEADERS_ALL.PO_HEADER_ID.
GL_DATE DATE

Date the distribution was encumbered
TRX_FLOW_HEADER_ID NUMBER

Transaction flow header identifier(References MTL_TRANSACTION_FLOW_HEADERS.header_id)
DESTINATION_TYPE_CODE VARCHAR2 (25)
Final destination of the purchased items
SUBINVENTORY_BUDGET_ACCOUNT NUMBER

Account to encumber items requested by subinventory
DISTRIBUTION_CHARGE_ACCOUNT NUMBER

Unique identifier for the General Ledger charge account. References GL_CODE_COMBINATIONS.CODE_COMBINATION_ID.
BUDGET_ACCOUNT NUMBER

Unique identifier for the General Ledger budget account. References GL_CODE_COMBINATIONS.CODE_COMBINATION_ID.
PO_BUDGET_ACCOUNT NUMBER

PO Budget Account
ORG_BUDGET_ACCOUNT NUMBER

Encumbrance account
EXPENSE_AP_ACCRUAL_ACCOUNT NUMBER

Unique identifier of the Receipt accrual General Ledger account
INV_AP_ACCRUAL_ACCOUNT NUMBER

Accounts payable accrual account
INV_IPV_ACCOUNT NUMBER

Invoice price variance account
ORG_EXPENSE_ACCOUNT NUMBER

Expense account
ORG_MATERIAL_ACCOUNT NUMBER

Inventory material account
DROP_SHIPMENT VARCHAR2 (1)
PLANNED_PO_DISTRIBUTION_ID NUMBER

PROJECT_ID NUMBER

PROJECT_NAME VARCHAR2 (30)
TASK_ID NUMBER

TASK_NAME VARCHAR2 (20)
EXPENDITURE_ORGANIZATION_ID NUMBER

EXPENDITURE_ORG VARCHAR2 (240) Yes
EXPENDITURE_TYPE VARCHAR2 (30)
PDR_EXPENDITURE_ITEM_DATE DATE

AWARD_ID NUMBER (15)
AWARD_NUMBER VARCHAR2 (15)
DESTINATION_SUBINVENTORY VARCHAR2 (10)
DELIVER_TO_LOCATION_ID NUMBER

DELIVER_TO_LOCATION_NAME VARCHAR2 (4000)
DELIVER_TO_PERSON_ID NUMBER (9)
DELIVER_TO_PERSON VARCHAR2 (240)
ACCRUE_ON_RECEIPT_FLAG VARCHAR2 (1)
PREVENT_ENCUMBRANCE_FLAG VARCHAR2 (1)
RESERVED_FLAG VARCHAR2 (1)
POD_ATTRIBUTE_CATEGORY VARCHAR2 (30)
POD_ATTRIBUTE1 VARCHAR2 (150)
POD_ATTRIBUTE2 VARCHAR2 (150)
POD_ATTRIBUTE3 VARCHAR2 (150)
POD_ATTRIBUTE4 VARCHAR2 (150)
POD_ATTRIBUTE5 VARCHAR2 (150)
POD_ATTRIBUTE6 VARCHAR2 (150)
POD_ATTRIBUTE7 VARCHAR2 (150)
POD_ATTRIBUTE8 VARCHAR2 (150)
POD_ATTRIBUTE9 VARCHAR2 (150)
POD_ATTRIBUTE10 VARCHAR2 (150)
POD_ATTRIBUTE11 VARCHAR2 (150)
POD_ATTRIBUTE12 VARCHAR2 (150)
POD_ATTRIBUTE13 VARCHAR2 (150)
POD_ATTRIBUTE14 VARCHAR2 (150)
POD_ATTRIBUTE15 VARCHAR2 (150)
ORG_ID NUMBER

Organization identifier
OPERATING_UNIT_NAME VARCHAR2 (240) Yes
SHIP_TO_ORGANIZATION_ID NUMBER

SHIP_TO_ORGANIZATION_CODE VARCHAR2 (3)
DESTINATION_ORGANIZATION_ID NUMBER

DESTINATION_ORGANIZATION_CODE VARCHAR2 (3)
WIP_ENTITY_ID NUMBER

WIP_ENTITY_NAME VARCHAR2 (240)
WIP_LINE_ID NUMBER

WIP_OPERATION_SEQ_NUM NUMBER

WIP_REPETITIVE_SCHEDULE_ID NUMBER

BOM_RESOURCE_ID NUMBER

RESOURCE_CODE VARCHAR2 (10)
LEDGER_ID NUMBER
Yes
LEDGER_CURRENCY VARCHAR2 (15) Yes
ENTERED_CURRENCY_CODE VARCHAR2 (15)
CURRENCY_CONVERSION_DATE DATE

CURRENCY_CONVERSION_RATE NUMBER

CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
PO_CURRENCY_CONVERSION_DATE DATE

PO_CURRENCY_CONVERSION_RATE NUMBER

PO_CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
QUANTITY_ORDERED NUMBER

QUANTITY_DELIVERED NUMBER

QUANTITY_RECEIVED NUMBER

QUANTITY_ACCEPTED NUMBER

QUANTITY_REJECTED NUMBER

QUANTITY_BILLED NUMBER

QUANTITY_CANCELLED NUMBER

QUANTITY_FINANCED NUMBER

UNIT_PRICE NUMBER

AMOUNT_DELIVERED NUMBER

ACCOUNTED_AMOUNT_DELIVERED NUMBER

AMOUNT_ORDERED NUMBER

ACCOUNTED_AMOUNT_ORDERED NUMBER

AMOUNT_RECEIVED NUMBER

AMOUNT_ACCEPTED NUMBER

AMOUNT_REJECTED NUMBER

AMOUNT_BILLED NUMBER

ACCOUNTED_AMOUNT_BILLED NUMBER

AMOUNT_CANCELLED NUMBER

AMOUNT_FINANCED NUMBER

AMOUNT_TO_ENCUMBER NUMBER

Query Text

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


SELECT PO_DISTRIBUTION_ID
,      PO_DISTRIBUTION_NUMBER
,      PO_DISTRIBUTION_TYPE
,      PO_LINE_LOCATION_ID
,      PO_SHIPMENT_NUMBER
,      PO_LINE_ID
,      PO_HEADER_ID
,      GL_DATE
,      TRX_FLOW_HEADER_ID
,      DESTINATION_TYPE_CODE
,      SUBINVENTORY_BUDGET_ACCOUNT
,      DISTRIBUTION_CHARGE_ACCOUNT
,      BUDGET_ACCOUNT
,      PO_BUDGET_ACCOUNT
,      ORG_BUDGET_ACCOUNT
,      EXPENSE_AP_ACCRUAL_ACCOUNT
,      INV_AP_ACCRUAL_ACCOUNT
,      INV_IPV_ACCOUNT
,      ORG_EXPENSE_ACCOUNT
,      ORG_MATERIAL_ACCOUNT
,      DROP_SHIPMENT
,      PLANNED_PO_DISTRIBUTION_ID
,      PROJECT_ID
,      PROJECT_NAME
,      TASK_ID
,      TASK_NAME
,      EXPENDITURE_ORGANIZATION_ID
,      EXPENDITURE_ORG
,      EXPENDITURE_TYPE
,      PDR_EXPENDITURE_ITEM_DATE
,      AWARD_ID
,      AWARD_NUMBER
,      DESTINATION_SUBINVENTORY
,      DELIVER_TO_LOCATION_ID
,      DELIVER_TO_LOCATION_NAME
,      DELIVER_TO_PERSON_ID
,      DELIVER_TO_PERSON
,      ACCRUE_ON_RECEIPT_FLAG
,      PREVENT_ENCUMBRANCE_FLAG
,      RESERVED_FLAG
,      POD_ATTRIBUTE_CATEGORY
,      POD_ATTRIBUTE1
,      POD_ATTRIBUTE2
,      POD_ATTRIBUTE3
,      POD_ATTRIBUTE4
,      POD_ATTRIBUTE5
,      POD_ATTRIBUTE6
,      POD_ATTRIBUTE7
,      POD_ATTRIBUTE8
,      POD_ATTRIBUTE9
,      POD_ATTRIBUTE10
,      POD_ATTRIBUTE11
,      POD_ATTRIBUTE12
,      POD_ATTRIBUTE13
,      POD_ATTRIBUTE14
,      POD_ATTRIBUTE15
,      ORG_ID
,      OPERATING_UNIT_NAME
,      SHIP_TO_ORGANIZATION_ID
,      SHIP_TO_ORGANIZATION_CODE
,      DESTINATION_ORGANIZATION_ID
,      DESTINATION_ORGANIZATION_CODE
,      WIP_ENTITY_ID
,      WIP_ENTITY_NAME
,      WIP_LINE_ID
,      WIP_OPERATION_SEQ_NUM
,      WIP_REPETITIVE_SCHEDULE_ID
,      BOM_RESOURCE_ID
,      RESOURCE_CODE
,      LEDGER_ID
,      LEDGER_CURRENCY
,      ENTERED_CURRENCY_CODE
,      CURRENCY_CONVERSION_DATE
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_TYPE
,      PO_CURRENCY_CONVERSION_DATE
,      PO_CURRENCY_CONVERSION_RATE
,      PO_CURRENCY_CONVERSION_TYPE
,      QUANTITY_ORDERED
,      QUANTITY_DELIVERED
,      QUANTITY_RECEIVED
,      QUANTITY_ACCEPTED
,      QUANTITY_REJECTED
,      QUANTITY_BILLED
,      QUANTITY_CANCELLED
,      QUANTITY_FINANCED
,      UNIT_PRICE
,      AMOUNT_DELIVERED
,      ACCOUNTED_AMOUNT_DELIVERED
,      AMOUNT_ORDERED
,      ACCOUNTED_AMOUNT_ORDERED
,      AMOUNT_RECEIVED
,      AMOUNT_ACCEPTED
,      AMOUNT_REJECTED
,      AMOUNT_BILLED
,      ACCOUNTED_AMOUNT_BILLED
,      AMOUNT_CANCELLED
,      AMOUNT_FINANCED
,      AMOUNT_TO_ENCUMBER
FROM APPS.PO_DISTS_REF_V;

Dependencies

[top of page]

APPS.PO_DISTS_REF_V references the following:

SchemaAPPS
SynonymBOM_RESOURCES
PL/SQL PackageFND_PROFILE - show dependent code
ViewGL_SETS_OF_BOOKS
SynonymGMS_AWARDS_ALL
SynonymHR_ALL_ORGANIZATION_UNITS_TL
ViewHR_EMPLOYEES
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
SynonymMTL_PARAMETERS
SynonymMTL_SECONDARY_INVENTORIES
SynonymPA_PROJECTS_ALL
SynonymPA_TASKS
SynonymPO_DISTRIBUTIONS_ALL
SynonymPO_HEADERS_ALL
SynonymPO_LINES_ALL
SynonymPO_LINE_LOCATIONS_ALL
PL/SQL PackagePO_LOCATIONS_S - show dependent code
SynonymPO_SYSTEM_PARAMETERS_ALL
SynonymWIP_ENTITIES
APPS.PO_DISTS_REF_V is referenced by following:

SchemaAPPS
Package BodyXLA_00201_AAD_S_000004_BC_PKG - show dependent code
Package BodyXLA_00201_AAD_S_000005_BC_PKG - show dependent code
Package BodyXLA_00707_AAD_S_000002_PKG - show dependent code
Package BodyXLA_00707_AAD_S_000005_BC_PKG - show dependent code
Package BodyXLA_00707_AAD_S_000005_PKG - show dependent code
Package BodyXLA_00707_AAD_S_000007_BC_PKG - show dependent code
Package BodyXLA_00707_AAD_S_000007_PKG - show dependent code
Package BodyXLA_00707_AAD_S_000019_PKG - show dependent code
Package BodyXLA_00707_AAD_S_000020_BC_PKG - show dependent code
Package BodyXLA_00707_AAD_S_000020_PKG - show dependent code