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


VIEW: APPS.POFV_SCHEDULED_SHIPMENTS

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

View Type

A Business Intelligence System view


This shows scheduling information for a planned purchase order release. Scheduling information includes information such as quantity and ship-to location.


[View Source]

Columns
Name Datatype Length Mandatory Comments
PO_SHIPMENT_ID NUMBER
Yes
SHIPMENT_NUMBER NUMBER


PO_LINE_ID NUMBER
Yes
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
ACTUAL_PRICE NUMBER


NEED_BY_DATE DATE


PROMISED_DATE DATE


LATEST_ACCEPTABLE_DATE DATE


ORDERED_QUANTITY NUMBER


SHIPPED_QUANTITY NUMBER


RECEIVED_QUANTITY NUMBER


CANCELLED_QUANTITY NUMBER


ACCEPTED_QUANTITY NUMBER


REJECTED_QUANTITY NUMBER


BILLED_QUANTITY NUMBER


_LA:APPROVED_FLAG CHAR (59)

APPROVAL_DATE DATE


_LA:CANCEL_FLAG CHAR (57)

CANCEL_DATE DATE


CANCEL_REASON VARCHAR2 (240)

_LA:CLOSURE_STATUS CHAR (65)

CLOSED_DATE DATE


CLOSED_REASON VARCHAR2 (240)

_LA:FIRM_STATUS CHAR (69)

_LA:ENCUMBERED_FLAG CHAR (61)

ENCUMBERED_DATE DATE


_LA:ACCRUE_ON_RECEIPT_FLAG CHAR (68)

_LA:ALLOW_SUBSTITUTE_RECEIPT CHAR (76)

_LA:ENFORCE_SHIP_TO_LOCATION CHAR (92)

_LA:INVOICE_MATCHING CHAR (185)

QUANTITY_RECEIVED_TOLERANCE NUMBER


_LA:QTY_RECEIVED_EXCEPTION CHAR (85)

EARLY_RECEIPT_ALLOWED_DAYS NUMBER


LATE_RECEIPT_ALLOWED_DAYS NUMBER


_LA:RECEIPT_DAYS_EXCEPTION CHAR (90)

RECEIVING_CLOSE_TOLERANCE NUMBER


INVOICE_CLOSE_TOLERANCE NUMBER


_LA:TAXABLE_FLAG CHAR (58)

TAX_NAME VARCHAR2 (30)

USSGL_TRANSACTION_CODE VARCHAR2 (30)

_DF CHAR (27)

UNIT_OF_MEASURE VARCHAR2 (25)

UOM_CLASS VARCHAR2 (10)

UOM_DESCRIPTION VARCHAR2 (50)

SHIP_TO_ORGANIZATION_ID NUMBER


SHIP_TO_ORGANIZATION_CODE VARCHAR2 (3)

SHIP_TO_ORGANIZATION_NAME VARCHAR2 (240)

SHIP_TO_LOCATION_ID NUMBER


SHIP_TO_LOCATION VARCHAR2 (60)

RECEIVING_ROUTING_ID NUMBER


RECEIVING_ROUTING_NAME VARCHAR2 (80)

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).
SECONDARY_QUANTITY NUMBER

SECONDARY_UNIT_OF_MEASURE VARCHAR2 (25)
PREFERRED_GRADE VARCHAR2 (150)
FINAL_MATCH_FLAG VARCHAR2 (1)
This flag indicates if the shipment is finally matched by AP invoice.
SHIPMENT_CLOSED_DATE DATE

CLOSED_FOR_RECEIVING_DATE DATE

CLOSED_FOR_INVOICE_DATE DATE

VALUE_BASIS VARCHAR2 (25)
Value Basis
MATCHING_BASIS VARCHAR2 (30)
Matching Basis
PAYMENT_TYPE VARCHAR2 (30)
Payment Type
DESCRIPTION VARCHAR2 (240)
Description
WORK_APPROVER_ID NUMBER

Work Approver Id
BID_PAYMENT_ID NUMBER

Bid Payment Id
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 NUMBER
Yes Tax Attribute Update Code
OUTSOURCED_ASSEMBLY VARCHAR2 (15)
Outsourced Assembly
ORIGINAL_SHIPMENT_ID NUMBER

Original Shipment Id
Query Text

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


SELECT 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
,      ACTUAL_PRICE
,      NEED_BY_DATE
,      PROMISED_DATE
,      LATEST_ACCEPTABLE_DATE
,      ORDERED_QUANTITY
,      SHIPPED_QUANTITY
,      RECEIVED_QUANTITY
,      CANCELLED_QUANTITY
,      ACCEPTED_QUANTITY
,      REJECTED_QUANTITY
,      BILLED_QUANTITY
,      _LA:APPROVED_FLAG
,      APPROVAL_DATE
,      _LA:CANCEL_FLAG
,      CANCEL_DATE
,      CANCEL_REASON
,      _LA:CLOSURE_STATUS
,      CLOSED_DATE
,      CLOSED_REASON
,      _LA:FIRM_STATUS
,      _LA:ENCUMBERED_FLAG
,      ENCUMBERED_DATE
,      _LA:ACCRUE_ON_RECEIPT_FLAG
,      _LA:ALLOW_SUBSTITUTE_RECEIPT
,      _LA:ENFORCE_SHIP_TO_LOCATION
,      _LA:INVOICE_MATCHING
,      QUANTITY_RECEIVED_TOLERANCE
,      _LA:QTY_RECEIVED_EXCEPTION
,      EARLY_RECEIPT_ALLOWED_DAYS
,      LATE_RECEIPT_ALLOWED_DAYS
,      _LA:RECEIPT_DAYS_EXCEPTION
,      RECEIVING_CLOSE_TOLERANCE
,      INVOICE_CLOSE_TOLERANCE
,      _LA:TAXABLE_FLAG
,      TAX_NAME
,      USSGL_TRANSACTION_CODE
,      _DF
,      UNIT_OF_MEASURE
,      UOM_CLASS
,      UOM_DESCRIPTION
,      SHIP_TO_ORGANIZATION_ID
,      SHIP_TO_ORGANIZATION_CODE
,      SHIP_TO_ORGANIZATION_NAME
,      SHIP_TO_LOCATION_ID
,      SHIP_TO_LOCATION
,      RECEIVING_ROUTING_ID
,      RECEIVING_ROUTING_NAME
,      CREATED_DATE
,      CREATED_BY
,      LAST_UPDATED_DATE
,      LAST_UPDATED_BY
,      SECONDARY_QUANTITY
,      SECONDARY_UNIT_OF_MEASURE
,      PREFERRED_GRADE
,      FINAL_MATCH_FLAG
,      SHIPMENT_CLOSED_DATE
,      CLOSED_FOR_RECEIVING_DATE
,      CLOSED_FOR_INVOICE_DATE
,      VALUE_BASIS
,      MATCHING_BASIS
,      PAYMENT_TYPE
,      DESCRIPTION
,      WORK_APPROVER_ID
,      BID_PAYMENT_ID
,      QUANTITY_FINANCED
,      AMOUNT_FINANCED
,      QUANTITY_RECOUPED
,      AMOUNT_RECOUPED
,      RETAINAGE_WITHHELD_AMOUNT
,      RETAINAGE_RELEASED_AMOUNT
,      TAX_ATTRIBUTE_UPDATE_CODE
,      OUTSOURCED_ASSEMBLY
,      ORIGINAL_SHIPMENT_ID
FROM APPS.POFV_SCHEDULED_SHIPMENTS;

Dependencies

[top of page]

APPS.POFV_SCHEDULED_SHIPMENTS references the following:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS
PL/SQL PackageHR_GENERAL - show dependent code
ViewHR_LOCATIONS
SynonymMTL_PARAMETERS
SynonymMTL_UNITS_OF_MEASURE
SynonymPO_HEADERS_ALL
SynonymPO_LINES_ALL
SynonymPO_LINE_LOCATIONS_ALL
SynonymPO_RELEASES_ALL
ViewRCV_ROUTING_HEADERS

APPS.POFV_SCHEDULED_SHIPMENTS is not referenced by any database object