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

VIEW: APPS.INL_ENTER_RECEIPTS_V

Object Details
Object Name: INL_ENTER_RECEIPTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewINL.INL_ENTER_RECEIPTS_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
LINE_CHKBOX CHAR (1)
"Y" or "N" indicating whether Shipment Line is checked
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 Line Location 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

RCV Shipment Header Identifier
RCV_SHIPMENT_NUMBER VARCHAR2 (0)
RCV_SHIPMENT_LINE_ID NUMBER

RCV Shipment Line Identifier
RCV_LINE_NUMBER NUMBER

RCV Line Number
FROM_ORGANIZATION_ID NUMBER
Yes From Organization Identifier
TO_ORGANIZATION_ID NUMBER

To Organization Identifier
VENDOR_ID NUMBER

Vendor Identifier
SOURCE VARCHAR2 (240)
Vendor Name
VENDOR_SITE_ID NUMBER

Vendor Site Identifier
OUTSIDE_OPERATION_FLAG VARCHAR2 (1)
Indicates whether the PO line type is an outside operation or not
ITEM_ID NUMBER

Item Identifier
PRIMARY_UOM VARCHAR2 (25)
Primary Uom
PRIMARY_UOM_CLASS VARCHAR2 (10)
Primary Uom Class
ITEM_ALLOWED_UNITS_LOOKUP_CODE NUMBER

Allowed unit of measure conversion type
ITEM_LOCATOR_CONTROL NUMBER

Stock locator control code
RESTRICT_LOCATORS_CODE VARCHAR2 (1)
Locators restrictions type
RESTRICT_SUBINVENTORIES_CODE VARCHAR2 (1)
Subinventory restrictions type
SHELF_LIFE_CODE NUMBER

Shelf Life Code
SHELF_LIFE_DAYS NUMBER

Length of 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)
Revision Quantity Control Code
ITEM_REV_CONTROL_FLAG_FROM VARCHAR2 (0)
Revision Quantity Control Code
ITEM_NUMBER VARCHAR2 (0)
Item Number
ITEM_REVISION VARCHAR2 (3)
Item Revision
ITEM_DESCRIPTION VARCHAR2 (240)
Item Description
ITEM_CATEGORY_ID NUMBER

Item Category Identifier
HAZARD_CLASS VARCHAR2 (40)
Hazard Class
UN_NUMBER VARCHAR2 (25)
United Nations 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

Receipt routing unique identifier
ROUTING_NAME VARCHAR2 (80)
Receiving routing name
NEED_BY_DATE DATE

Need by date
EXPECTED_RECEIPT_DATE DATE

Expected Receipt Date
ORDERED_QTY NUMBER

Quantity ordered
ORDERED_UOM VARCHAR2 (25)
Unit of measure for the quantity ordered
USSGL_TRANSACTION_CODE VARCHAR2 (0)
USSGL Transaction Code
GOVERNMENT_CONTEXT VARCHAR2 (30)
USSGL descriptive flexfield context column
INSPECTION_REQUIRED_FLAG VARCHAR2 (1)
Indicates whether shipment must be inspected before the invoice is paid
RECEIPT_REQUIRED_FLAG VARCHAR2 (1)
Indicates whether shipment must be received before the invoice is paid
ENFORCE_SHIP_TO_LOCATION_CODE VARCHAR2 (25)
Describes what action is taken when the receiving location differs from the ship-to location
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)
Shipment level Note to receiver, which would hold the note to receiver info coming from req lines
DESTINATION_TYPE_CODE VARCHAR2 (0)
Destination Type Code
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)
Attribute Category
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)
Closure status of the shipment
ASN_TYPE VARCHAR2 (0)
ASN Type
BILL_OF_LADING VARCHAR2 (0)
Bill Of Lading
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)
Conversion type user defined name
MATCH_OPTION VARCHAR2 (25)
Indicator of whether the invoice for the shipment should be matched to the purchase order or the receipt
COUNTRY_OF_ORIGIN_CODE VARCHAR2 (2)
Country of manufacture for this shipment
OE_ORDER_HEADER_ID NUMBER

Order Header Identifier
OE_ORDER_NUM NUMBER

Order Number
OE_ORDER_LINE_ID NUMBER

Order Line Identifier
OE_ORDER_LINE_NUM NUMBER

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)
Shipment level Note to receiver, which would hold the note to receiver info coming from req lines
SECONDARY_ORDERED_QTY NUMBER

Secondary Quantity ordered
SECONDARY_ORDERED_UOM VARCHAR2 (25)
Secondary Unit of measure for the ordered item
QC_GRADE VARCHAR2 (150)
Preferred quality grade for the ordered item
LPN_ID NUMBER

License Plate Number Identifier of the item
SECONDARY_DEFAULT_IND VARCHAR2 (30)
Catch-Weight Support for 11.5.10
ORG_ID NUMBER

Operating Unit Identifier
OE_ORDER_SHIP_NUM NUMBER

Order Shipment Number
LCM_SHIPMENT_LINE_ID NUMBER

LCM Shipment Line Identifier
UNIT_LANDED_COST NUMBER

Unit Landed Cost
LCM_SHIPMENT_FLAG VARCHAR2 (1)
LCM Shipment Flag
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_V;

Dependencies

[top of page]

APPS.INL_ENTER_RECEIPTS_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_V is referenced by following:

SchemaAPPS
ViewINL_IR_SOURCE_LINES_V
ViewINL_PO_SOURCE_LINES_V
ViewINL_RMA_SOURCE_LINES_V
Package BodyINL_SHIPMENT_PVT - show dependent code