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


VIEW: APPS.OE_PO_ENTER_RECEIPTS_V

Object Details
Object Name: OE_PO_ENTER_RECEIPTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewONT.OE_PO_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)
SOURCE_TYPE_CODE CHAR (8)
RECEIPT_SOURCE_CODE CHAR (8)
ORDER_TYPE_CODE VARCHAR2 (30)
ORDER_TYPE VARCHAR2 (30) Yes
PO_HEADER_ID NUMBER

PO_NUMBER VARCHAR2 (0)
PO_LINE_ID NUMBER

PO_LINE_NUMBER NUMBER

PO_LINE_LOCATION_ID NUMBER

PO_SHIPMENT_NUMBER NUMBER

PO_RELEASE_ID NUMBER

PO_RELEASE_NUMBER NUMBER

REQ_HEADER_ID NUMBER

REQ_NUMBER VARCHAR2 (0)
REQ_LINE_ID NUMBER

REQ_LINE NUMBER

REQ_DISTRIBUTION_ID NUMBER

RCV_SHIPMENT_HEADER_ID NUMBER

RCV_SHIPMENT_NUMBER VARCHAR2 (0)
RCV_SHIPMENT_LINE_ID NUMBER

RCV_LINE_NUMBER NUMBER

FROM_ORGANIZATION_ID NUMBER

TO_ORGANIZATION_ID NUMBER

VENDOR_ID NUMBER

SOURCE VARCHAR2 (360) Yes
VENDOR_SITE_ID NUMBER

OUTSIDE_OPERATION_FLAG VARCHAR2 (0)
ITEM_ID NUMBER
Yes
PRIMARY_UOM VARCHAR2 (25) Yes
PRIMARY_UOM_CLASS VARCHAR2 (10) Yes
ITEM_ALLOWED_UNITS_LOOKUP_CODE NUMBER

ITEM_LOCATOR_CONTROL NUMBER

RESTRICT_LOCATORS_CODE VARCHAR2 (1)
RESTRICT_SUBINVENTORIES_CODE VARCHAR2 (1)
SHELF_LIFE_CODE NUMBER

SHELF_LIFE_DAYS NUMBER

SERIAL_NUMBER_CONTROL_CODE NUMBER

LOT_CONTROL_CODE NUMBER

ITEM_REV_CONTROL_FLAG_TO VARCHAR2 (1)
ITEM_REV_CONTROL_FLAG_FROM VARCHAR2 (0)
ITEM_NUMBER VARCHAR2 (40)
ITEM_REVISION VARCHAR2 (3)
ITEM_DESCRIPTION VARCHAR2 (240)
ITEM_CATEGORY_ID NUMBER

HAZARD_CLASS VARCHAR2 (0)
UN_NUMBER VARCHAR2 (0)
VENDOR_ITEM_NUMBER VARCHAR2 (0)
SHIP_TO_LOCATION_ID NUMBER

SHIP_TO_LOCATION VARCHAR2 (0)
PACKING_SLIP VARCHAR2 (0)
ROUTING_ID NUMBER

ROUTING_NAME VARCHAR2 (0)
NEED_BY_DATE DATE

EXPECTED_RECEIPT_DATE DATE

ORDERED_QTY NUMBER

ORDERED_UOM VARCHAR2 (25) Yes
USSGL_TRANSACTION_CODE VARCHAR2 (0)
GOVERNMENT_CONTEXT VARCHAR2 (0)
INSPECTION_REQUIRED_FLAG VARCHAR2 (1)
RECEIPT_REQUIRED_FLAG CHAR (1)
ENFORCE_SHIP_TO_LOCATION_CODE CHAR (1)
UNIT_PRICE NUMBER

CURRENCY_CODE VARCHAR2 (15)
CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
CURRENCY_CONVERSION_DATE DATE

CURRENCY_CONVERSION_RATE NUMBER

NOTE_TO_RECEIVER VARCHAR2 (2000)
DESTINATION_TYPE_CODE VARCHAR2 (0)
DELIVER_TO_PERSON_ID NUMBER

DELIVER_TO_LOCATION_ID NUMBER

DESTINATION_SUBINVENTORY VARCHAR2 (0)
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (240)
ATTRIBUTE2 VARCHAR2 (240)
ATTRIBUTE3 VARCHAR2 (240)
ATTRIBUTE4 VARCHAR2 (240)
ATTRIBUTE5 VARCHAR2 (240)
ATTRIBUTE6 VARCHAR2 (240)
ATTRIBUTE7 VARCHAR2 (240)
ATTRIBUTE8 VARCHAR2 (240)
ATTRIBUTE9 VARCHAR2 (240)
ATTRIBUTE10 VARCHAR2 (240)
ATTRIBUTE11 VARCHAR2 (240)
ATTRIBUTE12 VARCHAR2 (240)
ATTRIBUTE13 VARCHAR2 (240)
ATTRIBUTE14 VARCHAR2 (240)
ATTRIBUTE15 VARCHAR2 (240)
CLOSED_CODE VARCHAR2 (0)
ASN_TYPE VARCHAR2 (0)
BILL_OF_LADING VARCHAR2 (0)
SHIPPED_DATE DATE

FREIGHT_CARRIER_CODE VARCHAR2 (0)
WAYBILL_AIRBILL_NUM VARCHAR2 (0)
FREIGHT_BILL_NUM VARCHAR2 (0)
VENDOR_LOT_NUM VARCHAR2 (0)
CONTAINER_NUM VARCHAR2 (0)
TRUCK_NUM VARCHAR2 (0)
BAR_CODE_LABEL VARCHAR2 (0)
RATE_TYPE_DISPLAY VARCHAR2 (0)
MATCH_OPTION VARCHAR2 (0)
COUNTRY_OF_ORIGIN_CODE VARCHAR2 (0)
OE_ORDER_HEADER_ID NUMBER
Yes
OE_ORDER_LINE_ID NUMBER
Yes
OE_ORDER_NUM NUMBER
Yes
OE_ORDER_LINE_NUM NUMBER
Yes
OE_ORDER_SHIP_NUM NUMBER
Yes
CUSTOMER_ITEM_NUM VARCHAR2 (50)
CUSTOMER_ID NUMBER (15) Yes
CUSTOMER_SITE_ID NUMBER

ORDERED_QUANTITY2 NUMBER

ORDERED_QUANTITY_UOM2 VARCHAR2 (25)
PREFERRED_GRADE VARCHAR2 (150)
ORG_ID 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_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_LINE_ID
,      OE_ORDER_NUM
,      OE_ORDER_LINE_NUM
,      OE_ORDER_SHIP_NUM
,      CUSTOMER_ITEM_NUM
,      CUSTOMER_ID
,      CUSTOMER_SITE_ID
,      ORDERED_QUANTITY2
,      ORDERED_QUANTITY_UOM2
,      PREFERRED_GRADE
,      ORG_ID
FROM APPS.OE_PO_ENTER_RECEIPTS_V;

Dependencies

[top of page]

APPS.OE_PO_ENTER_RECEIPTS_V references the following:

SchemaAPPS
SynonymHZ_CUST_ACCOUNTS
SynonymHZ_PARTIES
SynonymMTL_CUSTOMER_ITEMS
SynonymMTL_SYSTEM_ITEMS
SynonymMTL_SYSTEM_ITEMS_TL
SynonymMTL_UNITS_OF_MEASURE_TL
SynonymOE_ORDER_HEADERS_ALL
SynonymOE_ORDER_LINES_ALL
PL/SQL PackageOE_SYS_PARAMETERS - show dependent code
SynonymOE_TRANSACTION_TYPES_ALL
SynonymOE_TRANSACTION_TYPES_TL
APPS.OE_PO_ENTER_RECEIPTS_V is referenced by following:

SchemaAPPS
Package BodyINV_RCV_TXN_MATCH - show dependent code
ViewRCV_ENTER_RECEIPTS_RMA_V
Package BodyRCV_RMA_TRANSACTIONS - show dependent code