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


VIEW: APPS.POBV_SCHEDULED_DISTRIBUTIONS

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

View Type

A Business Intelligence System view


This shows accounting distribution and requisition information for a planned purchase order scheduled 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
PLANNED_RELEASE_ID NUMBER


RELEASE_NUMBER NUMBER
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)

SET_OF_BOOKS_ID NUMBER
Yes
CHARGE_ACCOUNT_ID NUMBER


BUDGET_ACCOUNT_ID NUMBER


ACCRUAL_ACCOUNT_ID NUMBER


VARIANCE_ACCOUNT_ID NUMBER


DEST_CHARGE_ACCOUNT_ID NUMBER

DEST_VARIANCE_ACCOUNT_ID NUMBER

DELIVER_TO_PERSON_ID NUMBER (9)

DELIVER_TO_LOCATION_ID NUMBER


DESTINATION_ORGANIZATION_ID NUMBER


DESTINATION_SUBINVENTORY VARCHAR2 (10)

REQUISITION_DISTRIBUTION_ID NUMBER


PROJECT_ID NUMBER


TASK_ID NUMBER


EXPENDITURE_ORGANIZATION_ID NUMBER


BOM_RESOURCE_ID NUMBER


WIP_ENTITY_ID NUMBER


WIP_LINE_ID NUMBER


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

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
,      PLANNED_RELEASE_ID
,      RELEASE_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
,      SET_OF_BOOKS_ID
,      CHARGE_ACCOUNT_ID
,      BUDGET_ACCOUNT_ID
,      ACCRUAL_ACCOUNT_ID
,      VARIANCE_ACCOUNT_ID
,      DEST_CHARGE_ACCOUNT_ID
,      DEST_VARIANCE_ACCOUNT_ID
,      DELIVER_TO_PERSON_ID
,      DELIVER_TO_LOCATION_ID
,      DESTINATION_ORGANIZATION_ID
,      DESTINATION_SUBINVENTORY
,      REQUISITION_DISTRIBUTION_ID
,      PROJECT_ID
,      TASK_ID
,      EXPENDITURE_ORGANIZATION_ID
,      BOM_RESOURCE_ID
,      WIP_ENTITY_ID
,      WIP_LINE_ID
,      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
,      QUANTITY_FINANCED
,      AMOUNT_FINANCED
,      QUANTITY_RECOUPED
,      AMOUNT_RECOUPED
,      RETAINAGE_WITHHELD_AMOUNT
,      RETAINAGE_RELEASED_AMOUNT
,      TAX_ATTRIBUTE_UPDATE_CODE
FROM APPS.POBV_SCHEDULED_DISTRIBUTIONS;

Dependencies

[top of page]

APPS.POBV_SCHEDULED_DISTRIBUTIONS references the following:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS
SynonymPO_DISTRIBUTIONS_ALL
SynonymPO_HEADERS_ALL
SynonymPO_LINES_ALL
SynonymPO_LINE_LOCATIONS_ALL
SynonymPO_RELEASES_ALL

APPS.POBV_SCHEDULED_DISTRIBUTIONS is not referenced by any database object