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


VIEW: APPS.POFV_PLAN_PO_DISTRIBUTIONS

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

View Type

A Business Intelligence System view


This shows accounting distribution and requisition information for a planned purchase order shipment.


[View Source]

Columns
Name Datatype Length Mandatory Comments
PO_DISTRIBUTION_ID NUMBER
Yes
DISTRIBUTION_NUMBER NUMBER
Yes
PO_SHIPMENT_ID NUMBER


SHIPMENT_NUMBER NUMBER


PO_LINE_ID NUMBER


LINE_NUMBER NUMBER
Yes
PLANNED_PO_ID NUMBER
Yes
PLANNED_PO_DOCUMENT_NUMBER VARCHAR2 (20) Yes
OPERATING_UNIT_ID NUMBER


OPERATING_UNIT_NAME VARCHAR2 (240) Yes
ORDERED_QUANTITY NUMBER


DELIVERED_QUANTITY NUMBER


CANCELLED_QUANTITY NUMBER


BILLED_QUANTITY NUMBER


BILLED_AMOUNT NUMBER


CURRENCY_CONVERSION_RATE NUMBER


CURRENCY_CONVERSION_RATE_DATE DATE


GL_CANCEL_DATE DATE


GL_CLOSED_DATE DATE


_LA:ACCRUE_ON_RECEIPT_FLAG CHAR (68)

_LA:ACCRUED_FLAG CHAR (58)

_LA:PREVENT_ENCUMBRANCE_FLAG CHAR (70)

_LA:ENCUMBERED_FLAG CHAR (61)

ENCUMBERED_AMOUNT NUMBER


GL_ENCUMBERED_DATE DATE


GL_ENCUMBERED_PERIOD_NAME VARCHAR2 (15)

UNENCUMBERED_AMOUNT NUMBER


UNENCUMBERED_QUANTITY NUMBER


_LA:FUNDS_CHECK_FAILURE_TYPE CHAR (74)

_LA:DESTINATION_TYPE CHAR (77)

PROJECT_EXPENDITURE_TYPE VARCHAR2 (30)

EXPENDITURE_ITEM_DATE DATE


USSGL_TRANSACTION_CODE VARCHAR2 (30)

_DF CHAR (26)

SET_OF_BOOKS_ID NUMBER
Yes
SET_OF_BOOKS_NAME VARCHAR2 (30) Yes
CHARGE_ACCOUNT_ID NUMBER


_KF:ACCOUNT_NUM:CHARGE:_CO CHAR (16)

BUDGET_ACCOUNT_ID NUMBER


_KF:ACCOUNT_NUM:BUDGET:_CO CHAR (16)

ACCRUAL_ACCOUNT_ID NUMBER


_KF:ACCOUNT_NUM:ACCRUAL:_CO CHAR (16)

VARIANCE_ACCOUNT_ID NUMBER


_KF:ACCOUNT_NUM:VARIANCE:_CO CHAR (16)

DEST_CHARGE_ACCOUNT_ID NUMBER

_KF:ACCOUNT_NUM:DST_CHRG:_CO CHAR (16)
DEST_VARIANCE_ACCOUNT_ID NUMBER

_KF:ACCOUNT_NUM:DST_VAR:_CO CHAR (16)
DELIVER_TO_PERSON_ID NUMBER (9)

DELIVER_TO_PERSON VARCHAR2 (240)

DELIVER_TO_LOCATION_ID NUMBER


DELIVER_TO_LOCATION VARCHAR2 (60)

DESTINATION_ORGANIZATION_ID NUMBER


DESTINATION_ORGANIZATION_CODE VARCHAR2 (3)

DESTINATION_ORGANIZATION_NAME VARCHAR2 (240)

DESTINATION_SUBINVENTORY VARCHAR2 (10)

REQUISITION_DISTRIBUTION_ID NUMBER


REQ_DOCUMENT_NUMBER VARCHAR2 (20)

REQ_LINE_NUMBER NUMBER


REQ_DISTRIBUTION_NUMBER NUMBER


PROJECT_ID NUMBER


PROJECT_NAME VARCHAR2 (30)

TASK_ID NUMBER


TASK_NUMBER VARCHAR2 (25)

EXPENDITURE_ORGANIZATION_ID NUMBER


EXPENDITURE_ORGANIZATION_CODE VARCHAR2 (3)

EXPENDITURE_ORGANIZATION_NAME VARCHAR2 (240)

BILL_OF_MATERIAL_RESOURCE_ID NUMBER


BILL_OF_MATERIAL_RESOURCE VARCHAR2 (10)

WIP_ENTITY_ID NUMBER


WIP_JOB_NAME VARCHAR2 (240)

WIP_LINE_ID NUMBER


WIP_LINE_CODE VARCHAR2 (10)

WIP_REPETITIVE_SCHEDULE_ID NUMBER


WIP_OPERATION_SEQUENCE_NUMBER NUMBER


WIP_RESOURCE_SEQUENCE_NUMBER NUMBER


CREATED_DATE DATE


CREATED_BY NUMBER

Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATED_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
OKE_CONTRACT_LINE_ID NUMBER

OKE_CONTRACT_DELIVERABLE_ID NUMBER

OKE_CONTRACT_LINE_NUM VARCHAR2 (150)
OKE_CONTRACT_DELIVERABLE_NUM VARCHAR2 (150)
QUANTITY_FINANCED NUMBER

Quantity Financed
AMOUNT_FINANCED NUMBER

Amount Financed
QUANTITY_RECOUPED NUMBER

Quantity Recouped
AMOUNT_RECOUPED NUMBER

Amount Recouped
RETAINAGE_WITHHELD_AMOUNT NUMBER

Retainage Withheld Amount
RETAINAGE_RELEASED_AMOUNT NUMBER

Retainage Released Amount
TAX_ATTRIBUTE_UPDATE_CODE VARCHAR2 (15)
Tax Attribute Update Code
Query Text

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


SELECT PO_DISTRIBUTION_ID
,      DISTRIBUTION_NUMBER
,      PO_SHIPMENT_ID
,      SHIPMENT_NUMBER
,      PO_LINE_ID
,      LINE_NUMBER
,      PLANNED_PO_ID
,      PLANNED_PO_DOCUMENT_NUMBER
,      OPERATING_UNIT_ID
,      OPERATING_UNIT_NAME
,      ORDERED_QUANTITY
,      DELIVERED_QUANTITY
,      CANCELLED_QUANTITY
,      BILLED_QUANTITY
,      BILLED_AMOUNT
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_RATE_DATE
,      GL_CANCEL_DATE
,      GL_CLOSED_DATE
,      _LA:ACCRUE_ON_RECEIPT_FLAG
,      _LA:ACCRUED_FLAG
,      _LA:PREVENT_ENCUMBRANCE_FLAG
,      _LA:ENCUMBERED_FLAG
,      ENCUMBERED_AMOUNT
,      GL_ENCUMBERED_DATE
,      GL_ENCUMBERED_PERIOD_NAME
,      UNENCUMBERED_AMOUNT
,      UNENCUMBERED_QUANTITY
,      _LA:FUNDS_CHECK_FAILURE_TYPE
,      _LA:DESTINATION_TYPE
,      PROJECT_EXPENDITURE_TYPE
,      EXPENDITURE_ITEM_DATE
,      USSGL_TRANSACTION_CODE
,      _DF
,      SET_OF_BOOKS_ID
,      SET_OF_BOOKS_NAME
,      CHARGE_ACCOUNT_ID
,      _KF:ACCOUNT_NUM:CHARGE:_CO
,      BUDGET_ACCOUNT_ID
,      _KF:ACCOUNT_NUM:BUDGET:_CO
,      ACCRUAL_ACCOUNT_ID
,      _KF:ACCOUNT_NUM:ACCRUAL:_CO
,      VARIANCE_ACCOUNT_ID
,      _KF:ACCOUNT_NUM:VARIANCE:_CO
,      DEST_CHARGE_ACCOUNT_ID
,      _KF:ACCOUNT_NUM:DST_CHRG:_CO
,      DEST_VARIANCE_ACCOUNT_ID
,      _KF:ACCOUNT_NUM:DST_VAR:_CO
,      DELIVER_TO_PERSON_ID
,      DELIVER_TO_PERSON
,      DELIVER_TO_LOCATION_ID
,      DELIVER_TO_LOCATION
,      DESTINATION_ORGANIZATION_ID
,      DESTINATION_ORGANIZATION_CODE
,      DESTINATION_ORGANIZATION_NAME
,      DESTINATION_SUBINVENTORY
,      REQUISITION_DISTRIBUTION_ID
,      REQ_DOCUMENT_NUMBER
,      REQ_LINE_NUMBER
,      REQ_DISTRIBUTION_NUMBER
,      PROJECT_ID
,      PROJECT_NAME
,      TASK_ID
,      TASK_NUMBER
,      EXPENDITURE_ORGANIZATION_ID
,      EXPENDITURE_ORGANIZATION_CODE
,      EXPENDITURE_ORGANIZATION_NAME
,      BILL_OF_MATERIAL_RESOURCE_ID
,      BILL_OF_MATERIAL_RESOURCE
,      WIP_ENTITY_ID
,      WIP_JOB_NAME
,      WIP_LINE_ID
,      WIP_LINE_CODE
,      WIP_REPETITIVE_SCHEDULE_ID
,      WIP_OPERATION_SEQUENCE_NUMBER
,      WIP_RESOURCE_SEQUENCE_NUMBER
,      CREATED_DATE
,      CREATED_BY
,      LAST_UPDATED_DATE
,      LAST_UPDATED_BY
,      OKE_CONTRACT_LINE_ID
,      OKE_CONTRACT_DELIVERABLE_ID
,      OKE_CONTRACT_LINE_NUM
,      OKE_CONTRACT_DELIVERABLE_NUM
,      QUANTITY_FINANCED
,      AMOUNT_FINANCED
,      QUANTITY_RECOUPED
,      AMOUNT_RECOUPED
,      RETAINAGE_WITHHELD_AMOUNT
,      RETAINAGE_RELEASED_AMOUNT
,      TAX_ATTRIBUTE_UPDATE_CODE
FROM APPS.POFV_PLAN_PO_DISTRIBUTIONS;

Dependencies

[top of page]

APPS.POFV_PLAN_PO_DISTRIBUTIONS references the following:

SchemaAPPS
SynonymBOM_RESOURCES
SynonymGL_CODE_COMBINATIONS
ViewGL_SETS_OF_BOOKS
SynonymHR_ALL_ORGANIZATION_UNITS
PL/SQL PackageHR_GENERAL - show dependent code
ViewHR_LOCATIONS
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
SynonymMTL_PARAMETERS
SynonymMTL_SECONDARY_INVENTORIES
SynonymOKC_K_LINES_B
SynonymOKE_K_DELIVERABLES_B
SynonymPA_PROJECTS_ALL
SynonymPA_TASKS
ViewPER_PEOPLE_F
SynonymPO_DISTRIBUTIONS_ALL
SynonymPO_HEADERS_ALL
SynonymPO_LINES_ALL
SynonymPO_LINE_LOCATIONS_ALL
SynonymPO_REQUISITION_HEADERS_ALL
SynonymPO_REQUISITION_LINES_ALL
SynonymPO_REQ_DISTRIBUTIONS_ALL
SynonymWIP_ENTITIES
SynonymWIP_LINES
SynonymWIP_OPERATIONS
SynonymWIP_OPERATION_RESOURCES

APPS.POFV_PLAN_PO_DISTRIBUTIONS is not referenced by any database object