eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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;