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.INL_ENTER_RECEIPTS_PO_V

Object Details

Object Name:	INL_ENTER_RECEIPTS_PO_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	INL.INL_ENTER_RECEIPTS_PO_V
Subobject Name:
Status:	VALID

View Type

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

A supplementary view used to simplify UI coding (Cloned from RCV_ENTER_RECEIPTS_PO_V).

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
LINE_CHKBOX	CHAR	(1)		Line Checkbox
SOURCE_TYPE_CODE	CHAR	(6)		Source Type Code
RECEIPT_SOURCE_CODE	CHAR	(6)		Receipt Source Code
ORDER_TYPE_CODE	CHAR	(2)		Order Type Code
ORDER_TYPE	VARCHAR2	(25)	Yes	Order Type
PO_HEADER_ID	NUMBER		Yes	PO Header Identifier
PO_NUMBER	VARCHAR2	(20)	Yes	PO Number
PO_LINE_ID	NUMBER		Yes	PO Line Identifier
PO_LINE_NUMBER	NUMBER		Yes	PO Line Number
PO_LINE_LOCATION_ID	NUMBER		Yes	PO Shipment Identifier
PO_SHIPMENT_NUMBER	NUMBER			PO Shipment Number
PO_RELEASE_ID	NUMBER			PO Release Identifier
PO_RELEASE_NUMBER	NUMBER			PO Release Number
REQ_HEADER_ID	NUMBER			Requisition Header Identifier
REQ_NUMBER	VARCHAR2	(0)		Requisition Number
REQ_LINE_ID	NUMBER			Requisition Line Identifier
REQ_LINE	NUMBER			Requisition Line
REQ_DISTRIBUTION_ID	NUMBER			Requisition Distribution Identifier
RCV_SHIPMENT_HEADER_ID	NUMBER			Receiving Shipment Header Identifier
RCV_SHIPMENT_NUMBER	VARCHAR2	(0)		Receiving Shipment Number
RCV_SHIPMENT_LINE_ID	NUMBER			Receiving Shipment Line Identifier
RCV_LINE_NUMBER	NUMBER			Receiving Line Number
FROM_ORGANIZATION_ID	NUMBER		Yes	From Organization Identifier
TO_ORGANIZATION_ID	NUMBER			Destination Inventory Organization Identifier
VENDOR_ID	NUMBER			Vendor Identifier
SOURCE	VARCHAR2	(240)		Source
VENDOR_SITE_ID	NUMBER			Vendor Site Identifier
OUTSIDE_OPERATION_FLAG	VARCHAR2	(1)		Outside Operation Flag
ITEM_ID	NUMBER			Inventory Item Identifier
PRIMARY_UOM	VARCHAR2	(25)		Primary Unit of Measure
PRIMARY_UOM_CLASS	VARCHAR2	(10)		Primary Unit of Measure Class
ITEM_ALLOWED_UNITS_LOOKUP_CODE	NUMBER			Inventory Item Allowed Units
ITEM_LOCATOR_CONTROL	NUMBER			Inventory Item Locator Control
RESTRICT_LOCATORS_CODE	VARCHAR2	(1)		Restrict Locators Code
RESTRICT_SUBINVENTORIES_CODE	VARCHAR2	(1)		Restrict Subinventories Code
SHELF_LIFE_CODE	NUMBER			Shelf Life Code
SHELF_LIFE_DAYS	NUMBER			Shelf Life Days
SERIAL_NUMBER_CONTROL_CODE	NUMBER			Serial Number Control Code
LOT_CONTROL_CODE	NUMBER			Lot Control Code
ITEM_REV_CONTROL_FLAG_TO	VARCHAR2	(1)		Inventory Item Revision Control Flag To
ITEM_REV_CONTROL_FLAG_FROM	VARCHAR2	(0)		Inventory Item Revision Control Flag From
ITEM_NUMBER	VARCHAR2	(0)		Inventory Item Number
ITEM_REVISION	VARCHAR2	(3)		Inventory Item Revision
ITEM_DESCRIPTION	VARCHAR2	(240)		Inventory Item Description
ITEM_CATEGORY_ID	NUMBER			Inventory Item Category Identifier
HAZARD_CLASS	VARCHAR2	(40)		Hazard Class
UN_NUMBER	VARCHAR2	(25)		UN Number
VENDOR_ITEM_NUMBER	VARCHAR2	(25)		Vendor Item Number
SHIP_TO_LOCATION_ID	NUMBER			Ship To Location Identifier
SHIP_TO_LOCATION	VARCHAR2	(60)		Ship To Location
PACKING_SLIP	VARCHAR2	(0)		Packing Slip
ROUTING_ID	NUMBER			Routing Identifier
ROUTING_NAME	VARCHAR2	(80)		Routing Name
NEED_BY_DATE	DATE			Need By Date
EXPECTED_RECEIPT_DATE	DATE			Expecte Arrival Date
ORDERED_QTY	NUMBER			Ordered Quantity
ORDERED_UOM	VARCHAR2	(25)		Ordered Unit of Measure
USSGL_TRANSACTION_CODE	VARCHAR2	(0)		USSGL Transaction Code
GOVERNMENT_CONTEXT	VARCHAR2	(30)		Government Context
INSPECTION_REQUIRED_FLAG	VARCHAR2	(1)		Inspection Required Flag
RECEIPT_REQUIRED_FLAG	VARCHAR2	(1)		Receipt Required Flag
ENFORCE_SHIP_TO_LOCATION_CODE	VARCHAR2	(25)		Enforce Ship to Location Code
UNIT_PRICE	NUMBER			Unit Price
CURRENCY_CODE	VARCHAR2	(15)		Currency Code
CURRENCY_CONVERSION_TYPE	VARCHAR2	(30)		Currency Conversion Type
CURRENCY_CONVERSION_DATE	DATE			Currency Conversion Date
CURRENCY_CONVERSION_RATE	NUMBER			Currency Conversion Rate
NOTE_TO_RECEIVER	VARCHAR2	(480)		Note to Receiver
DESTINATION_TYPE_CODE	VARCHAR2	(0)		Destination Type
DELIVER_TO_PERSON_ID	NUMBER			Deliver to Person Identifier
DELIVER_TO_LOCATION_ID	NUMBER			Deliver to Location Identifier
DESTINATION_SUBINVENTORY	VARCHAR2	(0)		Destination Subinventory
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure definition column.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
CLOSED_CODE	VARCHAR2	(30)		Closed Code
ASN_TYPE	VARCHAR2	(0)		ASN Type
BILL_OF_LADING	VARCHAR2	(0)		Bill Of Lading Number
SHIPPED_DATE	DATE			Shipped Date
FREIGHT_CARRIER_CODE	VARCHAR2	(0)		Freight Carrier Code
WAYBILL_AIRBILL_NUM	VARCHAR2	(0)		Waybill/Airbill Number
FREIGHT_BILL_NUM	VARCHAR2	(0)		Freight Bill Number
VENDOR_LOT_NUM	VARCHAR2	(0)		Vendor Lot Number
CONTAINER_NUM	VARCHAR2	(0)		Container Number
TRUCK_NUM	VARCHAR2	(0)		Truck Number
BAR_CODE_LABEL	VARCHAR2	(0)		Bar Code Label
RATE_TYPE_DISPLAY	VARCHAR2	(30)		Rate Type Display
MATCH_OPTION	VARCHAR2	(25)		Match Option
COUNTRY_OF_ORIGIN_CODE	VARCHAR2	(2)		Country of Origin
OE_ORDER_HEADER_ID	NUMBER			OE Order Header Identifier
OE_ORDER_NUM	NUMBER			OE Order Number
OE_ORDER_LINE_ID	NUMBER			OE Order Line Identifier
OE_ORDER_LINE_NUM	NUMBER			OE Order Line Number
CUSTOMER_ID	NUMBER			Customer Identifier
CUSTOMER_SITE_ID	NUMBER			Customer Site Identifier
CUSTOMER_ITEM_NUM	VARCHAR2	(0)		Customer Item Number
PLL_NOTE_TO_RECEIVER	VARCHAR2	(480)		PO Shipment Note to Receiver
SECONDARY_ORDERED_QTY	NUMBER			Ordered Quantity in Secondary unit of measure
SECONDARY_ORDERED_UOM	VARCHAR2	(25)		Ordered items secondary unit of measure
QC_GRADE	VARCHAR2	(150)		QC Grade
LPN_ID	NUMBER			LPN Identifier
SECONDARY_DEFAULT_IND	VARCHAR2	(30)		Secondary Default
ORG_ID	NUMBER			Operating Unit Identifier
OE_ORDER_SHIP_NUM	NUMBER			OE Order Shipment Number
LCM_SHIPMENT_LINE_ID	NUMBER			Shipment Line Identifier
UNIT_LANDED_COST	NUMBER			Unit Landed Cost
LCM_SHIPMENT_FLAG	VARCHAR2	(1)		"Y" or "N" flag indicating whether a given Shipment is enabled for LCM

Query Text

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


SELECT LINE_CHKBOX
,      SOURCE_TYPE_CODE
,      RECEIPT_SOURCE_CODE
,      ORDER_TYPE_CODE
,      ORDER_TYPE
,      PO_HEADER_ID
,      PO_NUMBER
,      PO_LINE_ID
,      PO_LINE_NUMBER
,      PO_LINE_LOCATION_ID
,      PO_SHIPMENT_NUMBER
,      PO_RELEASE_ID
,      PO_RELEASE_NUMBER
,      REQ_HEADER_ID
,      REQ_NUMBER
,      REQ_LINE_ID
,      REQ_LINE
,      REQ_DISTRIBUTION_ID
,      RCV_SHIPMENT_HEADER_ID
,      RCV_SHIPMENT_NUMBER
,      RCV_SHIPMENT_LINE_ID
,      RCV_LINE_NUMBER
,      FROM_ORGANIZATION_ID
,      TO_ORGANIZATION_ID
,      VENDOR_ID
,      SOURCE
,      VENDOR_SITE_ID
,      OUTSIDE_OPERATION_FLAG
,      ITEM_ID
,      PRIMARY_UOM
,      PRIMARY_UOM_CLASS
,      ITEM_ALLOWED_UNITS_LOOKUP_CODE
,      ITEM_LOCATOR_CONTROL
,      RESTRICT_LOCATORS_CODE
,      RESTRICT_SUBINVENTORIES_CODE
,      SHELF_LIFE_CODE
,      SHELF_LIFE_DAYS
,      SERIAL_NUMBER_CONTROL_CODE
,      LOT_CONTROL_CODE
,      ITEM_REV_CONTROL_FLAG_TO
,      ITEM_REV_CONTROL_FLAG_FROM
,      ITEM_NUMBER
,      ITEM_REVISION
,      ITEM_DESCRIPTION
,      ITEM_CATEGORY_ID
,      HAZARD_CLASS
,      UN_NUMBER
,      VENDOR_ITEM_NUMBER
,      SHIP_TO_LOCATION_ID
,      SHIP_TO_LOCATION
,      PACKING_SLIP
,      ROUTING_ID
,      ROUTING_NAME
,      NEED_BY_DATE
,      EXPECTED_RECEIPT_DATE
,      ORDERED_QTY
,      ORDERED_UOM
,      USSGL_TRANSACTION_CODE
,      GOVERNMENT_CONTEXT
,      INSPECTION_REQUIRED_FLAG
,      RECEIPT_REQUIRED_FLAG
,      ENFORCE_SHIP_TO_LOCATION_CODE
,      UNIT_PRICE
,      CURRENCY_CODE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_DATE
,      CURRENCY_CONVERSION_RATE
,      NOTE_TO_RECEIVER
,      DESTINATION_TYPE_CODE
,      DELIVER_TO_PERSON_ID
,      DELIVER_TO_LOCATION_ID
,      DESTINATION_SUBINVENTORY
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CLOSED_CODE
,      ASN_TYPE
,      BILL_OF_LADING
,      SHIPPED_DATE
,      FREIGHT_CARRIER_CODE
,      WAYBILL_AIRBILL_NUM
,      FREIGHT_BILL_NUM
,      VENDOR_LOT_NUM
,      CONTAINER_NUM
,      TRUCK_NUM
,      BAR_CODE_LABEL
,      RATE_TYPE_DISPLAY
,      MATCH_OPTION
,      COUNTRY_OF_ORIGIN_CODE
,      OE_ORDER_HEADER_ID
,      OE_ORDER_NUM
,      OE_ORDER_LINE_ID
,      OE_ORDER_LINE_NUM
,      CUSTOMER_ID
,      CUSTOMER_SITE_ID
,      CUSTOMER_ITEM_NUM
,      PLL_NOTE_TO_RECEIVER
,      SECONDARY_ORDERED_QTY
,      SECONDARY_ORDERED_UOM
,      QC_GRADE
,      LPN_ID
,      SECONDARY_DEFAULT_IND
,      ORG_ID
,      OE_ORDER_SHIP_NUM
,      LCM_SHIPMENT_LINE_ID
,      UNIT_LANDED_COST
,      LCM_SHIPMENT_FLAG
FROM APPS.INL_ENTER_RECEIPTS_PO_V;

Dependencies

[top of page]

APPS.INL_ENTER_RECEIPTS_PO_V references the following:

APPS: GL_DAILY_CONVERSION_TYPES; HR_LOCATIONS_ALL_TL; MTL_SYSTEM_ITEMS; MTL_UNITS_OF_MEASURE; PO_HAZARD_CLASSES_TL; PO_HEADERS_ALL; PO_LINES_ALL; PO_LINE_LOCATIONS; PO_LINE_TYPES_B; PO_RELEASES_ALL; PO_UN_NUMBERS_TL; PO_VENDORS; RCV_ROUTING_HEADERS

APPS.INL_ENTER_RECEIPTS_PO_V is referenced by following:

APPS: INL_ENTER_RECEIPTS_V; INL_SHIPMENT_PVT - show dependent code