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: ViewINL.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:

SchemaAPPS
SynonymGL_DAILY_CONVERSION_TYPES
SynonymHR_LOCATIONS_ALL_TL
SynonymMTL_SYSTEM_ITEMS
SynonymMTL_UNITS_OF_MEASURE
SynonymPO_HAZARD_CLASSES_TL
SynonymPO_HEADERS_ALL
SynonymPO_LINES_ALL
SynonymPO_LINE_LOCATIONS
SynonymPO_LINE_TYPES_B
SynonymPO_RELEASES_ALL
SynonymPO_UN_NUMBERS_TL
ViewPO_VENDORS
ViewRCV_ROUTING_HEADERS
APPS.INL_ENTER_RECEIPTS_PO_V is referenced by following:

SchemaAPPS
ViewINL_ENTER_RECEIPTS_V
Package BodyINL_SHIPMENT_PVT - show dependent code