[Home] [Help] [Dependency Information]

VIEW: APPS.RLM_SCHEDULE_ITEMS_V

Object Details

Object Name:	RLM_SCHEDULE_ITEMS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	RLM.RLM_SCHEDULE_ITEMS_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

Query Text

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

SELECT SCHEDULE_ITEM_NUM
,      ITEM_DESCRIPTION_EXT
,      HEADER_ID
,      ORIGIN_TABLE
,      CUST_SHIP_FROM_ORG_EXT
,      CUST_SHIP_TO_EXT
,      CUSTOMER_ITEM_EXT
,      CUSTOMER_ITEM_ID
,      INVENTORY_ITEM_ID
,      SUPPLIER_ITEM_EXT
,      CUST_ASSIGNED_ID_EXT
,      COUNTRY_OF_ORIGIN_EXT
,      COMMODITY_EXT
,      CUST_MODEL_NUMBER_EXT
,      ITEM_ENG_CNG_LVL_EXT
,      CUSTOMER_ITEM_REVISION
,      ITEM_RELEASE_STATUS_EXT
,      ITEM_MEASUREMENTS_EXT
,      SHIP_DEL_PATTERN_EXT
,      SHIP_DEL_RULE_NAME
,      SHIP_DEL_TIME_CODE_EXT
,      CUST_PO_NUMBER
,      CUST_PO_DATE
,      CUST_PO_RELEASE_NUM
,      CUST_PO_LINE_NUM
,      CUST_CONTRACT_NUM_EXT
,      IMPORT_LICENSE_EXT
,      IMPORT_LICENSE_DATE_EXT
,      LETTER_CREDIT_EXT
,      LETTER_CREDIT_EXPDT_EXT
,      CUST_ITEM_PRICE_EXT
,      CUST_ITEM_PRICE_UOM_EXT
,      PACK_UNITS_PER_PACK_EXT
,      PACK_SIZE_EXT
,      PACK_UOM_CODE_EXT
,      HAZARD_CODE_QUAL_EXT
,      HAZARD_CODE_EXT
,      HAZARD_DESCRIPTION_EXT
,      HANDLING_CODE_EXT
,      RETURN_CONTAINER_EXT
,      SHIP_LABEL_INFO_LINE_1
,      SHIP_LABEL_INFO_LINE_2
,      SHIP_LABEL_INFO_LINE_3
,      SHIP_LABEL_INFO_LINE_4
,      SHIP_LABEL_INFO_LINE_5
,      SHIP_LABEL_INFO_LINE_6
,      SHIP_LABEL_INFO_LINE_7
,      SHIP_LABEL_INFO_LINE_8
,      SHIP_LABEL_INFO_LINE_9
,      SHIP_LABEL_INFO_LINE_10
,      CUST_BILL_TO_EXT
,      CUST_INTRMD_SHIP_TO_EXT
,      OTHER_NAME_CODE_1
,      OTHER_NAME_VALUE_1
,      OTHER_NAME_CODE_2
,      OTHER_NAME_VALUE_2
,      ITEM_REF_CODE_1
,      ITEM_REF_VALUE_1
,      ITEM_REF_CODE_2
,      ITEM_REF_VALUE_2
,      ITEM_REF_CODE_3
,      ITEM_REF_VALUE_3
,      ITEM_CONTACT_CODE_1
,      ITEM_CONTACT_VALUE_1
,      ITEM_CONTACT_CODE_2
,      ITEM_CONTACT_VALUE_2
,      SHIP_FROM_NAME_EXT
,      SHIP_FROM_ADDRESS_1_EXT
,      SHIP_FROM_ADDRESS_2_EXT
,      SHIP_FROM_ADDRESS_3_EXT
,      SHIP_FROM_ADDRESS_4_EXT
,      SHIP_FROM_CITY_EXT
,      SHIP_FROM_COUNTY_EXT
,      SHIP_FROM_POSTAL_CD_EXT
,      SHIP_FROM_PROVINCE_EXT
,      SHIP_FROM_STATE_EXT
,      SHIP_FROM_COUNTRY_EXT
,      SHIP_FROM_ORG_ID
,      SHIP_TO_NAME_EXT
,      SHIP_TO_ADDRESS_1_EXT
,      SHIP_TO_ADDRESS_2_EXT
,      SHIP_TO_ADDRESS_3_EXT
,      SHIP_TO_ADDRESS_4_EXT
,      SHIP_TO_CITY_EXT
,      SHIP_TO_COUNTY_EXT
,      SHIP_TO_POSTAL_CD_EXT
,      SHIP_TO_PROVINCE_EXT
,      SHIP_TO_STATE_EXT
,      SHIP_TO_COUNTRY_EXT
,      SHIP_TO_ADDRESS_ID
,      SHIP_TO_ORG_ID
,      INVOICE_TO_ORG_ID
,      INTMED_SHIP_TO_ORG_ID
,      DELIVER_TO_ORG_ID
,      BILL_TO_NAME_EXT
,      BILL_TO_ADDRESS_1_EXT
,      BILL_TO_ADDRESS_2_EXT
,      BILL_TO_ADDRESS_3_EXT
,      BILL_TO_ADDRESS_4_EXT
,      BILL_TO_CITY_EXT
,      BILL_TO_COUNTY_EXT
,      BILL_TO_POSTAL_CD_EXT
,      BILL_TO_PROVINCE_EXT
,      BILL_TO_STATE_EXT
,      BILL_TO_COUNTRY_EXT
,      BILL_TO_ADDRESS_ID
,      INTRMD_ST_NAME_EXT
,      INTRMD_ST_ADDRESS_1_EXT
,      INTRMD_ST_ADDRESS_2_EXT
,      INTRMD_ST_ADDRESS_3_EXT
,      INTRMD_ST_ADDRESS_4_EXT
,      INTRMD_ST_CITY_EXT
,      INTRMD_ST_COUNTY_EXT
,      INTRMD_ST_POSTAL_CD_EXT
,      INTRMD_ST_PROVINCE_EXT
,      INTRMD_ST_STATE_EXT
,      INTRMD_ST_COUNTRY_EXT
,      ITEM_NOTE_TEXT
,      INDUSTRY_ATTRIBUTE1
,      INTRMD_SHIP_TO_ID
,      CUSTOMER_DOCK_CODE
,      CARRIER_QUALIFIER_EXT
,      CARRIER_ID_CODE_EXT
,      TRANSIT_TIME_QUAL_EXT
,      TRANSIT_TIME_EXT
,      TRANSPORT_LOC_QUAL_EXT
,      TRANSPORT_METHOD_EXT
,      TRANSPORT_LOCATION_EXT
,      WEIGHT_QUALIFIER_EXT
,      WEIGHT_EXT
,      WEIGHT_UOM_EXT
,      ROUTING_DESC_EXT
,      ROUTING_SEQ_CODE_EXT
,      EQUIPMENT_CODE_EXT
,      EQUIPMENT_NUMBER_EXT
,      CUST_ASSEMBLY_EXT
,      CUST_MANUFACTURER_EXT
,      CUST_MODEL_SERIAL_NUMBER
,      CUST_ORDER_NUM_EXT
,      CUST_PROCESS_NUM_EXT
,      CUST_PRODUCTION_LINE
,      CUST_PRODUCTION_SEQ_NUM
,      CUST_SET_NUM_EXT
,      CUSTOMER_JOB
,      LADING_QUANTITY_EXT
,      PRIME_CONTRCTR_PART_EXT
,      SHIP_TO_CUSTOMER_ID
,      ORG_ID
FROM APPS.RLM_SCHEDULE_ITEMS_V;

Dependencies

[top of page]

APPS

RLM_INTERFACE_LINES_ALL

RLM_SCHEDULE_INTERFACE_HDR_V

RLM_SCHEDULE_LINES_ALL

APPS.RLM_SCHEDULE_ITEMS_V is not referenced by any database object