[Home] [Help] [Dependency Information]
Object Name: | POFV_RECEIVING_TRANSACTIONS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PO.POFV_RECEIVING_TRANSACTIONS |
Subobject Name: | |
Status: | VALID |
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.
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) |
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;
APPS.POFV_RECEIVING_TRANSACTIONS is not referenced by any database object
|
|
|