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


VIEW: APPS.POFV_RECEIVING_TRANSACTIONS

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

View Type

A Business Intelligence System view


This shows transactions recording physical and/or logical movement of a set of goods or services into, within, or out of the receiving-inspection business unit.


[View Source]

Columns
Name Datatype Length Mandatory Comments
TRANSACTION_ID NUMBER
Yes
_LA:TRANSACTION_TYPE CHAR (76)

TRANSACTION_DATE DATE
Yes
TRANSACTION_QUANTITY NUMBER


COMMENTS VARCHAR2 (240)

CURRENCY_CONVERSION_RATE NUMBER


CURRENCY_CONVERSION_RATE_DATE DATE


_LA:DESTINATION_TYPE CHAR (81)

INSPECTION_QUALITY VARCHAR2 (25)

_LA:INSPECTION_STATUS CHAR (79)

INVOICE_STATUS VARCHAR2 (25)

PRIMARY_QUANTITY NUMBER


SOURCE_DOCUMENT_QUANTITY NUMBER


PURCHASE_ORDER_UNIT_PRICE NUMBER


_LA:RECEIPT_EXCEPTION_FLAG CHAR (68)

RMA_REFERENCE_NUMBER VARCHAR2 (30)

_LA:SOURCE_DOCUMENT_TYPE CHAR (89)

SUBSTITUTE_UNORDERED_INDICATOR VARCHAR2 (25)

SUPPLIER_LOT_NUMBER VARCHAR2 (30)

_LA:USER_ENTERED_FLAG CHAR (63)

TRANSACTION_REASON_NAME VARCHAR2 (30)
_DF CHAR (26)

SHIPMENT_ID NUMBER
Yes
SHIPMENT_NUMBER VARCHAR2 (30)

SHIPMENT_LINE_ID NUMBER
Yes
SHIPMENT_LINE_NUMBER NUMBER
Yes
INVENTORY_TRANSACTION_ID NUMBER


TRANSACTION_UNIT_OF_MEASURE VARCHAR2 (25)

TRANSACTION_UOM_CLASS VARCHAR2 (10) Yes
TRANSACTION_UOM_DESCRIPTION VARCHAR2 (50)

PRIMARY_UNIT_OF_MEASURE VARCHAR2 (25)

PRIMARY_UOM_CLASS VARCHAR2 (10)

PRIMARY_UOM_DESCRIPTION VARCHAR2 (50)

SOURCE_DOC_UNIT_OF_MEASURE VARCHAR2 (25)

SOURCE_DOC_UOM_CLASS VARCHAR2 (10)

SOURCE_DOC_UOM_DESCRIPTION VARCHAR2 (50)

RECEIVER_ID NUMBER (9)

RECEIVER_EMPLOYEE_NUMBER VARCHAR2 (30)

RECEIVER_NAME VARCHAR2 (240)

PARENT_TRANSACTION_ID NUMBER


_LA:PARENT_TRANSACTION_TYPE CHAR (76)

OPERATING_UNIT_ID NUMBER


OPERATING_UNIT_NAME VARCHAR2 (240)

PURCHASE_ORDER_ID NUMBER


PURCHASE_ORDER_NUMBER VARCHAR2 (20)

_LA:PURCHASE_ORDER_TYPE CHAR (72)

PO_RELEASE_ID NUMBER


PO_RELEASE_NUMBER NUMBER


PO_LINE_ID NUMBER


PO_LINE_NUMBER NUMBER


PO_SHIPMENT_ID NUMBER


PO_SHIPMENT_NUMBER NUMBER


_LA:PO_SHIPMENT_TYPE CHAR (66)

PO_DISTRIBUTION_ID NUMBER


PO_DISTRIBUTION_NUMBER NUMBER


REQUISITION_LINE_ID NUMBER


REQUISITION_DOCUMENT_NUMBER VARCHAR2 (20)

REQUISITION_LINE_NUMBER NUMBER


REQ_DISTRIBUTION_ID NUMBER


REQ_DISTRIBUTION_NUMBER NUMBER


CURRENCY_CODE VARCHAR2 (15)

CURRENCY VARCHAR2 (80)

CURRENCY_CONVERSION_RATE_TYPE VARCHAR2 (30)

RATE_TYPE_NAME VARCHAR2 (30)

RATE_TYPE_DESCRIPTION VARCHAR2 (240)

RECEIVING_ROUTING_ID NUMBER


RECEIVING_ROUTING_NAME VARCHAR2 (80)

DELIVER_TO_PERSON_ID NUMBER (9)

DELIVER_TO_PERSON VARCHAR2 (240)

DELIVER_TO_LOCATION_ID NUMBER


DELIVER_TO_LOCATION VARCHAR2 (60)

SUPPLIER_ID NUMBER


SUPPLIER_NAME VARCHAR2 (240)

SUPPLIER_SITE_ID NUMBER


SUPPLIER_SITE VARCHAR2 (15)

DESTINATION_ORGANIZATION_ID NUMBER


DESTINATION_ORGANIZATION_CODE VARCHAR2 (3)

DESTINATION_ORGANIZATION_NAME VARCHAR2 (240)

DESTINATION_SUBINVENTORY VARCHAR2 (10)

DESTINATION_LOCATOR_ID NUMBER


DESTINATION_LOCATOR VARCHAR2 (50)

BILL_OF_MATERIAL_RESOURCE_ID NUMBER


BILL_OF_MATERIAL_RESOURCE VARCHAR2 (10)

WIP_DEPARTMENT_CODE VARCHAR2 (10)

WIP_DEPARTMENT_NAME VARCHAR2 (240)

WIP_ENTITY_ID NUMBER


WIP_JOB_NAME VARCHAR2 (240)

WIP_LINE_ID NUMBER


WIP_LINE_CODE VARCHAR2 (10)

WIP_OPERATION_SEQUENCE_NUMBER NUMBER


WIP_REPETITIVE_SCHEDULE_ID NUMBER


WIP_RESOURCE_SEQUENCE_NUMBER NUMBER


INVOICE_ID NUMBER


INVOICE_NUMBER VARCHAR2 (50)

CREATED_DATE DATE
Yes
CREATED_BY NUMBER
Yes 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).
MVT_STAT_STATUS VARCHAR2 (30)
QUANTITY_BILLED NUMBER

AMOUNT_BILLED NUMBER

_LA:MATCH_FLAG CHAR (56)
MATCH_OPTION VARCHAR2 (25)
SECONDARY_QUANTITY NUMBER

SECONDARY_UNIT_OF_MEASURE VARCHAR2 (25)
SECONDARY_UOM_CODE VARCHAR2 (3)
QC_GRADE VARCHAR2 (150)
DROP_SHIP_FLAG VARCHAR2 (1)
Indicates whether the Shipment has a backing Sales Order Line.
SALES_ORDER_UPDATE_DATE DATE

The date/time when any of referenced data elements on the backing Sales Order Line is updated.
_LA:PA_ADDITION_FLAG CHAR (62)
_LA:CONSIGNED_FLAG CHAR (60)
Query Text

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


SELECT TRANSACTION_ID
,      _LA:TRANSACTION_TYPE
,      TRANSACTION_DATE
,      TRANSACTION_QUANTITY
,      COMMENTS
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_RATE_DATE
,      _LA:DESTINATION_TYPE
,      INSPECTION_QUALITY
,      _LA:INSPECTION_STATUS
,      INVOICE_STATUS
,      PRIMARY_QUANTITY
,      SOURCE_DOCUMENT_QUANTITY
,      PURCHASE_ORDER_UNIT_PRICE
,      _LA:RECEIPT_EXCEPTION_FLAG
,      RMA_REFERENCE_NUMBER
,      _LA:SOURCE_DOCUMENT_TYPE
,      SUBSTITUTE_UNORDERED_INDICATOR
,      SUPPLIER_LOT_NUMBER
,      _LA:USER_ENTERED_FLAG
,      TRANSACTION_REASON_NAME
,      _DF
,      SHIPMENT_ID
,      SHIPMENT_NUMBER
,      SHIPMENT_LINE_ID
,      SHIPMENT_LINE_NUMBER
,      INVENTORY_TRANSACTION_ID
,      TRANSACTION_UNIT_OF_MEASURE
,      TRANSACTION_UOM_CLASS
,      TRANSACTION_UOM_DESCRIPTION
,      PRIMARY_UNIT_OF_MEASURE
,      PRIMARY_UOM_CLASS
,      PRIMARY_UOM_DESCRIPTION
,      SOURCE_DOC_UNIT_OF_MEASURE
,      SOURCE_DOC_UOM_CLASS
,      SOURCE_DOC_UOM_DESCRIPTION
,      RECEIVER_ID
,      RECEIVER_EMPLOYEE_NUMBER
,      RECEIVER_NAME
,      PARENT_TRANSACTION_ID
,      _LA:PARENT_TRANSACTION_TYPE
,      OPERATING_UNIT_ID
,      OPERATING_UNIT_NAME
,      PURCHASE_ORDER_ID
,      PURCHASE_ORDER_NUMBER
,      _LA:PURCHASE_ORDER_TYPE
,      PO_RELEASE_ID
,      PO_RELEASE_NUMBER
,      PO_LINE_ID
,      PO_LINE_NUMBER
,      PO_SHIPMENT_ID
,      PO_SHIPMENT_NUMBER
,      _LA:PO_SHIPMENT_TYPE
,      PO_DISTRIBUTION_ID
,      PO_DISTRIBUTION_NUMBER
,      REQUISITION_LINE_ID
,      REQUISITION_DOCUMENT_NUMBER
,      REQUISITION_LINE_NUMBER
,      REQ_DISTRIBUTION_ID
,      REQ_DISTRIBUTION_NUMBER
,      CURRENCY_CODE
,      CURRENCY
,      CURRENCY_CONVERSION_RATE_TYPE
,      RATE_TYPE_NAME
,      RATE_TYPE_DESCRIPTION
,      RECEIVING_ROUTING_ID
,      RECEIVING_ROUTING_NAME
,      DELIVER_TO_PERSON_ID
,      DELIVER_TO_PERSON
,      DELIVER_TO_LOCATION_ID
,      DELIVER_TO_LOCATION
,      SUPPLIER_ID
,      SUPPLIER_NAME
,      SUPPLIER_SITE_ID
,      SUPPLIER_SITE
,      DESTINATION_ORGANIZATION_ID
,      DESTINATION_ORGANIZATION_CODE
,      DESTINATION_ORGANIZATION_NAME
,      DESTINATION_SUBINVENTORY
,      DESTINATION_LOCATOR_ID
,      DESTINATION_LOCATOR
,      BILL_OF_MATERIAL_RESOURCE_ID
,      BILL_OF_MATERIAL_RESOURCE
,      WIP_DEPARTMENT_CODE
,      WIP_DEPARTMENT_NAME
,      WIP_ENTITY_ID
,      WIP_JOB_NAME
,      WIP_LINE_ID
,      WIP_LINE_CODE
,      WIP_OPERATION_SEQUENCE_NUMBER
,      WIP_REPETITIVE_SCHEDULE_ID
,      WIP_RESOURCE_SEQUENCE_NUMBER
,      INVOICE_ID
,      INVOICE_NUMBER
,      CREATED_DATE
,      CREATED_BY
,      LAST_UPDATED_DATE
,      LAST_UPDATED_BY
,      MVT_STAT_STATUS
,      QUANTITY_BILLED
,      AMOUNT_BILLED
,      _LA:MATCH_FLAG
,      MATCH_OPTION
,      SECONDARY_QUANTITY
,      SECONDARY_UNIT_OF_MEASURE
,      SECONDARY_UOM_CODE
,      QC_GRADE
,      DROP_SHIP_FLAG
,      SALES_ORDER_UPDATE_DATE
,      _LA:PA_ADDITION_FLAG
,      _LA:CONSIGNED_FLAG
FROM APPS.POFV_RECEIVING_TRANSACTIONS;

Dependencies

[top of page]

APPS.POFV_RECEIVING_TRANSACTIONS references the following:

SchemaAPPS
SynonymAP_INVOICES_ALL
SynonymBOM_DEPARTMENTS
SynonymBOM_RESOURCES
ViewFND_CURRENCIES_VL
SynonymGL_DAILY_CONVERSION_TYPES
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_ITEM_LOCATIONS
SynonymMTL_MATERIAL_TRANSACTIONS
SynonymMTL_PARAMETERS
SynonymMTL_SECONDARY_INVENTORIES
SynonymMTL_TRANSACTION_REASONS
SynonymMTL_UNITS_OF_MEASURE
ViewPER_PEOPLE_F
SynonymPO_DISTRIBUTIONS_ALL
SynonymPO_HEADERS_ALL
SynonymPO_LINES_ALL
SynonymPO_LINE_LOCATIONS_ALL
SynonymPO_RELEASES_ALL
SynonymPO_REQUISITION_HEADERS_ALL
SynonymPO_REQUISITION_LINES_ALL
SynonymPO_REQ_DISTRIBUTIONS_ALL
ViewPO_VENDORS
ViewPO_VENDOR_SITES_ALL
ViewRCV_ROUTING_HEADERS
SynonymRCV_SHIPMENT_HEADERS
SynonymRCV_SHIPMENT_LINES
SynonymRCV_TRANSACTIONS
SynonymWIP_ENTITIES
SynonymWIP_LINES
SynonymWIP_OPERATIONS
SynonymWIP_OPERATION_RESOURCES

APPS.POFV_RECEIVING_TRANSACTIONS is not referenced by any database object