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

VIEW: APPS.INL_IR_SOURCE_LINES_V

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

View Type

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


This view shows expected receipts from Internal Requisition.


[View Source]

Columns
Name Datatype Length Mandatory Comments
LINE_CHKBOX CHAR (1)
Line Checkbox
SOURCE_TYPE_CODE VARCHAR2 (8)
Source Type Code
RECEIPT_SOURCE_CODE VARCHAR2 (25)
Receipt Source Code
ORDER_TYPE_CODE VARCHAR2 (30)
Order Type Code
ORDER_TYPE VARCHAR2 (30)
Order Type
PO_HEADER_ID NUMBER

PO Header Identifier
PO_NUMBER VARCHAR2 (20)
PO Number
PO_LINE_ID NUMBER

PO Line Identifier
PO_LINE_NUMBER NUMBER

PO Line Number
PO_LINE_LOCATION_ID NUMBER

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 (20)
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 (30)
Receiving Shipment Number
RCV_SHIPMENT_LINE_ID NUMBER

Receiving Shipment Line Identifier
RCV_LINE_NUMBER NUMBER

Receiving Line Number
FROM_ORGANIZATION_ID NUMBER

From Organization Identifier
TO_ORGANIZATION_ID NUMBER

Destination Inventory Organization Identifier
VENDOR_ID NUMBER

Vendor Identifier
SOURCE VARCHAR2 (360)
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_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 (1)
Inventory Item Revision Control Flag From
ITEM_NUMBER VARCHAR2 (40)
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 Identifier
PACKING_SLIP VARCHAR2 (25)
Packing Slip
ROUTING_ID NUMBER

Routing Identifier
ROUTING_NAME VARCHAR2 (80)
Routing Name
NEED_BY_DATE DATE

Need By Date
EXPECTED_RECEIPT_DATE DATE

Expected Arrival Date
ORDERED_QTY NUMBER

Ordered Quantity
ORDERED_UOM VARCHAR2 (25)
Ordered Unit of Measure
USSGL_TRANSACTION_CODE VARCHAR2 (30)
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 (25)
Destination Type
DELIVER_TO_PERSON_ID NUMBER

Deliver to Person Identifier
DELIVER_TO_LOCATION_ID NUMBER

Deliver to Location Identifier
DESTINATION_SUBINVENTORY VARCHAR2 (10)
Destination Subinventory
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (240)
Descriptive flexfield segment
CLOSED_CODE VARCHAR2 (30)
Closed Code
ASN_TYPE VARCHAR2 (25)
ASN Type
BILL_OF_LADING VARCHAR2 (25)
Bill of Lading
SHIPPED_DATE DATE

Shipped Date
FREIGHT_CARRIER_CODE VARCHAR2 (25)
Freight Carrier Code
WAYBILL_AIRBILL_NUM VARCHAR2 (20)
Waybill/Airbill Number
FREIGHT_BILL_NUM VARCHAR2 (35)
Freight Bill Number
VENDOR_LOT_NUM VARCHAR2 (30)
Vendor Lot Number
CONTAINER_NUM VARCHAR2 (35)
Container Number
TRUCK_NUM VARCHAR2 (35)
Truck Number
BAR_CODE_LABEL VARCHAR2 (35)
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 (50)
Customer Item Number
PLL_NOTE_TO_RECEIVER VARCHAR2 (2000)
PO Shipment Note to Receiver
SECONDARY_ORDERED_QTY NUMBER

Secondary Ordered Quantity
SECONDARY_ORDERED_UOM VARCHAR2 (25)
Secondary Ordered Unit of Measure
QC_GRADE VARCHAR2 (150)
QC Grade
LPN_ID NUMBER

LPN Identifier
SECONDARY_DEFAULT_IND VARCHAR2 (30)
Secondary Default
ORG_ID NUMBER

Organization identifier
OE_ORDER_SHIP_NUM NUMBER

OE Order Shipment Number
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_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
FROM APPS.INL_IR_SOURCE_LINES_V;

Dependencies

[top of page]

APPS.INL_IR_SOURCE_LINES_V references the following:

SchemaAPPS
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
ViewINL_ENTER_RECEIPTS_V
PL/SQL PackageOE_SYS_PARAMETERS - show dependent code

APPS.INL_IR_SOURCE_LINES_V is not referenced by any database object