eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.POS_RCV_REJECTED_ITEMS_V

Object Details

Object Name:	POS_RCV_REJECTED_ITEMS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PO.POS_RCV_REJECTED_ITEMS_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

This view contains the information about Rejected Items

[View Source]

Columns

Name	Datatype	Length	Comments
ORGANIZATION_ID	NUMBER		Organization Identifier
PARENT_TRANSACTION_ID	NUMBER		Parent Transaction Identifier
SHIPMENT_HEADER_ID	NUMBER		Shipment Header Identifier
SHIPMENT_LINE_ID	NUMBER		Shipment Line Identifier
TRANSACTION_ID	NUMBER		Transaction Identifier
TRANSACTION_TYPE	VARCHAR2	(25)	Transaction Type
TRANSACTION_DATE	DATE		Transaction Date
TRANSACT_QTY	NUMBER		Transaction Quantity
TRANSACT_UOM	VARCHAR2	(25)	Transaction Unit of Measure
PRIMARY_UOM	VARCHAR2	(25)	Primary Unit of Measure
PRIMARY_QUANTITY	NUMBER		Primary Quantity
QUANTITY_RECEIVED	NUMBER		Quantity Received
NET_PRIMARY_QUANTITY	NUMBER		Net Primary Quantity
ITEM_ID	NUMBER		Item Identifier
ITEM_REV	VARCHAR2	(3)	Item Rev.
ITEM_DESC	VARCHAR2	(240)	Item Description
VENDOR_ITEM_NUM	VARCHAR2	(25)	Vendor Item Number
DESTINATION_TYPE	VARCHAR2	(25)	Destination Type
PO_HEADER_ID	NUMBER		Purchase Order Header Identifier
PO_LINE_ID	NUMBER		Purchase Order Line Identifier
PO_LINE_LOCATION_ID	NUMBER		Purchase Order Line Location Identifier
PO_DISTRIBUTION_ID	NUMBER		Purchase Order Distribution Identifier
PO_RELEASE_ID	NUMBER		Purchase Order Release Identifier
ROUTING_HEADER_ID	NUMBER		Routing Header Identifier
SHIP_TO_LOCATION_ID	NUMBER		Ship-to Location Identifier
SHIP_TO_LOCATION	VARCHAR2	(60)	Ship-to Location
SHIP_TO_LOCATION_DESC	VARCHAR2	(240)	Ship-to Location
EMPLOYEE_ID	NUMBER	(9)	Employee Identifier
RECEIVER	VARCHAR2	(240)	Receiver
DELIVER_TO_LOCATION_ID	NUMBER		Deliver to Location Identifier
DELIVER_TO_LOCATION	VARCHAR2	(60)	Deliver to Location
DELIVER_TO_LOCATION_DESC	VARCHAR2	(240)	Deliver to Location Description
DELIVER_TO_PERSON_ID	NUMBER	(9)	Deliver to Person Identifier
DELIVER_TO_PERSON	VARCHAR2	(240)	Deliver to Person
SUBINVENTORY	VARCHAR2	(10)	Sub-inventory
LOCATOR_ID	NUMBER		Locator Identifier
SOURCE_DOC_CODE	VARCHAR2	(25)	Source Document Code
SOURCE_DOC_UOM	VARCHAR2	(25)	Source Document Unit of Measure
SOURCE_DOC_QTY	NUMBER		Source Document Quantity
SOURCE_TYPE	VARCHAR2	(25)	Source Type
SUPPLIER_ID	NUMBER		Supplier Identifier
SUPPLIER	VARCHAR2	(240)	Supplier
VENDOR_ID	NUMBER		Vendor Identifier
VENDOR_NAME	VARCHAR2	(240)	Vendor Name
SUPPLIER_SITE_ID	NUMBER		Supplier Site Identifier
SUPPLIER_SITE	VARCHAR2	(15)	Supplier Site
FROM_ORGANIZATION_ID	NUMBER		From Organization Identifier
WIP_ENTITY_ID	NUMBER		Work-in Process Entity Identifier
WIP_LINE_ID	NUMBER		Work-in Process Line Identifier
WIP_REPETITIVE_SCHEDULE_ID	NUMBER		Work-in Process Repetitive Schedule Identifier
WIP_OPERATION_SEQ_NUM	NUMBER		Work-in Process Operation Sequence Number
DEPARTMENT_CODE	VARCHAR2	(10)	Department Code
INSPECTION_STATUS_CODE	VARCHAR2	(25)	Inspection Status Code
INSPECTION_QUALITY_CODE	VARCHAR2	(25)	Inspection Quality Code
REASON_ID	NUMBER		Reason Identifier
COMMENTS	VARCHAR2	(240)	Comments
VENDOR_LOT_NUM	VARCHAR2	(30)	Vendor Lot Number
RMA_REFERENCE	VARCHAR2	(30)	RMA Reference
RECEIPT_EXCEPTION_FLAG	VARCHAR2	(1)	Receipt Exception Flag
CATEGORY_ID	NUMBER		Category Identifier
RECEIPT_NUM	VARCHAR2	(30)	Receipt Number
RECEIPT_DATE	DATE		Receipt Date
PO_NUM	VARCHAR2	(61)	Purchase Order Number
PO_LINE	NUMBER		Purchase Order Line
PO_SHIPMENT	NUMBER		Purchase Order Shipment
SHIPMENT_NUM	VARCHAR2	(30)	Shipment Number
BILL_OF_LADING	VARCHAR2	(25)	Bill of Lading
PACKING_SLIP	VARCHAR2	(25)	Packing Slip
FREIGHT_CARRIER	VARCHAR2	(25)	Freight Carrier
PO_RELEASE	NUMBER		Purchase Order Release
REQUISITION_NUM	VARCHAR2	(20)	Requisition Number
REQUISITION_LINE	NUMBER		Requisition Line
REQ_HEADER_ID	NUMBER		Requisition Header Identifier
REQ_LINE_ID	NUMBER		Requisition Line Identifier
ORDER_NUM	VARCHAR2	(20)	Order Number
ORDER_LINE	NUMBER		Order Line
UNIT_MEAS_LOOKUP_CODE	VARCHAR2	(25)	Unit of Measure Lookup Code
HAZARD_CLASS_ID	NUMBER		Hazard Class Identifier
UN_NUMBER_ID	NUMBER		UN Number Identifier
NEED_BY_DATE	DATE		Need-by Date
PROMISED_DATE	DATE		Promised Date
QUANTITY_ORDERED	NUMBER		Quantity Ordered
REASON	VARCHAR2	(30)	Reason
ROUTING	VARCHAR2	(80)	Routing
HAZARD	VARCHAR2	(40)	Hazard
UN_NUM	VARCHAR2	(25)	UN Number
SUPPLIER_URL	VARCHAR2	(150)	Supplier URL
ITEM_URL	VARCHAR2	(240)	Item URL
ITEM_NUM	VARCHAR2	(40)	Item Number
WAYBILL_AIRBILL_NUM	VARCHAR2	(20)	Waybill Airbill Number

Query Text

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


SELECT ORGANIZATION_ID
,      PARENT_TRANSACTION_ID
,      SHIPMENT_HEADER_ID
,      SHIPMENT_LINE_ID
,      TRANSACTION_ID
,      TRANSACTION_TYPE
,      TRANSACTION_DATE
,      TRANSACT_QTY
,      TRANSACT_UOM
,      PRIMARY_UOM
,      PRIMARY_QUANTITY
,      QUANTITY_RECEIVED
,      NET_PRIMARY_QUANTITY
,      ITEM_ID
,      ITEM_REV
,      ITEM_DESC
,      VENDOR_ITEM_NUM
,      DESTINATION_TYPE
,      PO_HEADER_ID
,      PO_LINE_ID
,      PO_LINE_LOCATION_ID
,      PO_DISTRIBUTION_ID
,      PO_RELEASE_ID
,      ROUTING_HEADER_ID
,      SHIP_TO_LOCATION_ID
,      SHIP_TO_LOCATION
,      SHIP_TO_LOCATION_DESC
,      EMPLOYEE_ID
,      RECEIVER
,      DELIVER_TO_LOCATION_ID
,      DELIVER_TO_LOCATION
,      DELIVER_TO_LOCATION_DESC
,      DELIVER_TO_PERSON_ID
,      DELIVER_TO_PERSON
,      SUBINVENTORY
,      LOCATOR_ID
,      SOURCE_DOC_CODE
,      SOURCE_DOC_UOM
,      SOURCE_DOC_QTY
,      SOURCE_TYPE
,      SUPPLIER_ID
,      SUPPLIER
,      VENDOR_ID
,      VENDOR_NAME
,      SUPPLIER_SITE_ID
,      SUPPLIER_SITE
,      FROM_ORGANIZATION_ID
,      WIP_ENTITY_ID
,      WIP_LINE_ID
,      WIP_REPETITIVE_SCHEDULE_ID
,      WIP_OPERATION_SEQ_NUM
,      DEPARTMENT_CODE
,      INSPECTION_STATUS_CODE
,      INSPECTION_QUALITY_CODE
,      REASON_ID
,      COMMENTS
,      VENDOR_LOT_NUM
,      RMA_REFERENCE
,      RECEIPT_EXCEPTION_FLAG
,      CATEGORY_ID
,      RECEIPT_NUM
,      RECEIPT_DATE
,      PO_NUM
,      PO_LINE
,      PO_SHIPMENT
,      SHIPMENT_NUM
,      BILL_OF_LADING
,      PACKING_SLIP
,      FREIGHT_CARRIER
,      PO_RELEASE
,      REQUISITION_NUM
,      REQUISITION_LINE
,      REQ_HEADER_ID
,      REQ_LINE_ID
,      ORDER_NUM
,      ORDER_LINE
,      UNIT_MEAS_LOOKUP_CODE
,      HAZARD_CLASS_ID
,      UN_NUMBER_ID
,      NEED_BY_DATE
,      PROMISED_DATE
,      QUANTITY_ORDERED
,      REASON
,      ROUTING
,      HAZARD
,      UN_NUM
,      SUPPLIER_URL
,      ITEM_URL
,      ITEM_NUM
,      WAYBILL_AIRBILL_NUM
FROM APPS.POS_RCV_REJECTED_ITEMS_V;

Dependencies

[top of page]

APPS.POS_RCV_REJECTED_ITEMS_V references the following:

APPS: FINANCIALS_SYSTEM_PARAMS_ALL; HR_GENERAL - show dependent code; HR_LOCATIONS_ALL; HR_SECURITY - show dependent code; MTL_SYSTEM_ITEMS_KFV; MTL_TRANSACTION_REASONS; ORG_ORGANIZATION_DEFINITIONS; PER_ALL_PEOPLE_F; POS_PO_RCV_QTY - show dependent code; PO_DISTRIBUTIONS_ALL; PO_HAZARD_CLASSES; PO_HEADERS_ALL; PO_LINES_ALL; PO_LINE_LOCATIONS_ALL; PO_RELEASES_ALL; PO_REQUISITION_HEADERS_ALL; PO_REQUISITION_LINES_ALL; PO_UN_NUMBERS; PO_VENDORS; PO_VENDOR_SITES_ALL; RCV_ROUTING_HEADERS; RCV_SHIPMENT_HEADERS; RCV_SHIPMENT_LINES; RCV_TRANSACTIONS

APPS.POS_RCV_REJECTED_ITEMS_V is not referenced by any database object