[Home] [Help] [Dependency Information]
Object Name: | RLM_SCHEDULE_ITEMS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | RLM.RLM_SCHEDULE_ITEMS_V |
Subobject Name: | |
Status: | VALID |
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.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SCHEDULE_ITEM_NUM | NUMBER | |||
ITEM_DESCRIPTION_EXT | VARCHAR2 | (80) | ||
HEADER_ID | NUMBER | |||
ORIGIN_TABLE | VARCHAR2 | (9) | ||
CUST_SHIP_FROM_ORG_EXT | VARCHAR2 | (80) | ||
CUST_SHIP_TO_EXT | VARCHAR2 | (35) | ||
CUSTOMER_ITEM_EXT | VARCHAR2 | (50) | ||
CUSTOMER_ITEM_ID | NUMBER | |||
INVENTORY_ITEM_ID | NUMBER | |||
SUPPLIER_ITEM_EXT | VARCHAR2 | (35) | ||
CUST_ASSIGNED_ID_EXT | VARCHAR2 | (20) | ||
COUNTRY_OF_ORIGIN_EXT | VARCHAR2 | (35) | ||
COMMODITY_EXT | VARCHAR2 | (35) | ||
CUST_MODEL_NUMBER_EXT | VARCHAR2 | (35) | ||
ITEM_ENG_CNG_LVL_EXT | VARCHAR2 | (35) | ||
CUSTOMER_ITEM_REVISION | VARCHAR2 | (3) | ||
ITEM_RELEASE_STATUS_EXT | VARCHAR2 | (3) | ||
ITEM_MEASUREMENTS_EXT | VARCHAR2 | (240) | ||
SHIP_DEL_PATTERN_EXT | VARCHAR2 | (3) | ||
SHIP_DEL_RULE_NAME | VARCHAR2 | (30) | ||
SHIP_DEL_TIME_CODE_EXT | VARCHAR2 | (3) | ||
CUST_PO_NUMBER | VARCHAR2 | (50) | ||
CUST_PO_DATE | DATE | |||
CUST_PO_RELEASE_NUM | VARCHAR2 | (35) | ||
CUST_PO_LINE_NUM | VARCHAR2 | (35) | ||
CUST_CONTRACT_NUM_EXT | VARCHAR2 | (35) | ||
IMPORT_LICENSE_EXT | VARCHAR2 | (35) | ||
IMPORT_LICENSE_DATE_EXT | DATE | |||
LETTER_CREDIT_EXT | VARCHAR2 | (35) | ||
LETTER_CREDIT_EXPDT_EXT | DATE | |||
CUST_ITEM_PRICE_EXT | NUMBER | |||
CUST_ITEM_PRICE_UOM_EXT | VARCHAR2 | (3) | ||
PACK_UNITS_PER_PACK_EXT | NUMBER | |||
PACK_SIZE_EXT | NUMBER | |||
PACK_UOM_CODE_EXT | VARCHAR2 | (3) | ||
HAZARD_CODE_QUAL_EXT | VARCHAR2 | (3) | ||
HAZARD_CODE_EXT | VARCHAR2 | (10) | ||
HAZARD_DESCRIPTION_EXT | VARCHAR2 | (80) | ||
HANDLING_CODE_EXT | VARCHAR2 | (3) | ||
RETURN_CONTAINER_EXT | VARCHAR2 | (35) | ||
SHIP_LABEL_INFO_LINE_1 | VARCHAR2 | (80) | ||
SHIP_LABEL_INFO_LINE_2 | VARCHAR2 | (80) | ||
SHIP_LABEL_INFO_LINE_3 | VARCHAR2 | (80) | ||
SHIP_LABEL_INFO_LINE_4 | VARCHAR2 | (80) | ||
SHIP_LABEL_INFO_LINE_5 | VARCHAR2 | (80) | ||
SHIP_LABEL_INFO_LINE_6 | VARCHAR2 | (80) | ||
SHIP_LABEL_INFO_LINE_7 | VARCHAR2 | (80) | ||
SHIP_LABEL_INFO_LINE_8 | VARCHAR2 | (80) | ||
SHIP_LABEL_INFO_LINE_9 | VARCHAR2 | (80) | ||
SHIP_LABEL_INFO_LINE_10 | VARCHAR2 | (80) | ||
CUST_BILL_TO_EXT | VARCHAR2 | (35) | ||
CUST_INTRMD_SHIP_TO_EXT | VARCHAR2 | (35) | ||
OTHER_NAME_CODE_1 | VARCHAR2 | (3) | ||
OTHER_NAME_VALUE_1 | VARCHAR2 | (80) | ||
OTHER_NAME_CODE_2 | VARCHAR2 | (3) | ||
OTHER_NAME_VALUE_2 | VARCHAR2 | (80) | ||
ITEM_REF_CODE_1 | VARCHAR2 | (3) | ||
ITEM_REF_VALUE_1 | VARCHAR2 | (35) | ||
ITEM_REF_CODE_2 | VARCHAR2 | (3) | ||
ITEM_REF_VALUE_2 | VARCHAR2 | (35) | ||
ITEM_REF_CODE_3 | VARCHAR2 | (3) | ||
ITEM_REF_VALUE_3 | VARCHAR2 | (35) | ||
ITEM_CONTACT_CODE_1 | VARCHAR2 | (3) | ||
ITEM_CONTACT_VALUE_1 | VARCHAR2 | (80) | ||
ITEM_CONTACT_CODE_2 | VARCHAR2 | (3) | ||
ITEM_CONTACT_VALUE_2 | VARCHAR2 | (80) | ||
SHIP_FROM_NAME_EXT | VARCHAR2 | (60) | ||
SHIP_FROM_ADDRESS_1_EXT | VARCHAR2 | (35) | ||
SHIP_FROM_ADDRESS_2_EXT | VARCHAR2 | (35) | ||
SHIP_FROM_ADDRESS_3_EXT | VARCHAR2 | (35) | ||
SHIP_FROM_ADDRESS_4_EXT | VARCHAR2 | (35) | ||
SHIP_FROM_CITY_EXT | VARCHAR2 | (30) | ||
SHIP_FROM_COUNTY_EXT | VARCHAR2 | (25) | ||
SHIP_FROM_POSTAL_CD_EXT | VARCHAR2 | (15) | ||
SHIP_FROM_PROVINCE_EXT | VARCHAR2 | (10) | ||
SHIP_FROM_STATE_EXT | VARCHAR2 | (10) | ||
SHIP_FROM_COUNTRY_EXT | VARCHAR2 | (3) | ||
SHIP_FROM_ORG_ID | NUMBER | |||
SHIP_TO_NAME_EXT | VARCHAR2 | (60) | ||
SHIP_TO_ADDRESS_1_EXT | VARCHAR2 | (35) | ||
SHIP_TO_ADDRESS_2_EXT | VARCHAR2 | (35) | ||
SHIP_TO_ADDRESS_3_EXT | VARCHAR2 | (35) | ||
SHIP_TO_ADDRESS_4_EXT | VARCHAR2 | (35) | ||
SHIP_TO_CITY_EXT | VARCHAR2 | (30) | ||
SHIP_TO_COUNTY_EXT | VARCHAR2 | (25) | ||
SHIP_TO_POSTAL_CD_EXT | VARCHAR2 | (15) | ||
SHIP_TO_PROVINCE_EXT | VARCHAR2 | (10) | ||
SHIP_TO_STATE_EXT | VARCHAR2 | (10) | ||
SHIP_TO_COUNTRY_EXT | VARCHAR2 | (3) | ||
SHIP_TO_ADDRESS_ID | NUMBER | |||
SHIP_TO_ORG_ID | NUMBER | |||
INVOICE_TO_ORG_ID | NUMBER | |||
INTMED_SHIP_TO_ORG_ID | NUMBER | |||
DELIVER_TO_ORG_ID | NUMBER | |||
BILL_TO_NAME_EXT | VARCHAR2 | (60) | ||
BILL_TO_ADDRESS_1_EXT | VARCHAR2 | (35) | ||
BILL_TO_ADDRESS_2_EXT | VARCHAR2 | (35) | ||
BILL_TO_ADDRESS_3_EXT | VARCHAR2 | (35) | ||
BILL_TO_ADDRESS_4_EXT | VARCHAR2 | (35) | ||
BILL_TO_CITY_EXT | VARCHAR2 | (30) | ||
BILL_TO_COUNTY_EXT | VARCHAR2 | (25) | ||
BILL_TO_POSTAL_CD_EXT | VARCHAR2 | (15) | ||
BILL_TO_PROVINCE_EXT | VARCHAR2 | (10) | ||
BILL_TO_STATE_EXT | VARCHAR2 | (10) | ||
BILL_TO_COUNTRY_EXT | VARCHAR2 | (3) | ||
BILL_TO_ADDRESS_ID | NUMBER | |||
INTRMD_ST_NAME_EXT | VARCHAR2 | (60) | ||
INTRMD_ST_ADDRESS_1_EXT | VARCHAR2 | (35) | ||
INTRMD_ST_ADDRESS_2_EXT | VARCHAR2 | (35) | ||
INTRMD_ST_ADDRESS_3_EXT | VARCHAR2 | (35) | ||
INTRMD_ST_ADDRESS_4_EXT | VARCHAR2 | (35) | ||
INTRMD_ST_CITY_EXT | VARCHAR2 | (30) | ||
INTRMD_ST_COUNTY_EXT | VARCHAR2 | (25) | ||
INTRMD_ST_POSTAL_CD_EXT | VARCHAR2 | (15) | ||
INTRMD_ST_PROVINCE_EXT | VARCHAR2 | (10) | ||
INTRMD_ST_STATE_EXT | VARCHAR2 | (10) | ||
INTRMD_ST_COUNTRY_EXT | VARCHAR2 | (3) | ||
ITEM_NOTE_TEXT | VARCHAR2 | (4000) | ||
INDUSTRY_ATTRIBUTE1 | VARCHAR2 | (150) | ||
INTRMD_SHIP_TO_ID | NUMBER | |||
CUSTOMER_DOCK_CODE | VARCHAR2 | (50) | ||
CARRIER_QUALIFIER_EXT | VARCHAR2 | (3) | ||
CARRIER_ID_CODE_EXT | VARCHAR2 | (35) | ||
TRANSIT_TIME_QUAL_EXT | VARCHAR2 | (3) | ||
TRANSIT_TIME_EXT | VARCHAR2 | (22) | ||
TRANSPORT_LOC_QUAL_EXT | VARCHAR2 | (3) | ||
TRANSPORT_METHOD_EXT | VARCHAR2 | (3) | ||
TRANSPORT_LOCATION_EXT | VARCHAR2 | (35) | ||
WEIGHT_QUALIFIER_EXT | VARCHAR2 | (3) | ||
WEIGHT_EXT | NUMBER | |||
WEIGHT_UOM_EXT | VARCHAR2 | (3) | ||
ROUTING_DESC_EXT | VARCHAR2 | (35) | ||
ROUTING_SEQ_CODE_EXT | VARCHAR2 | (3) | ||
EQUIPMENT_CODE_EXT | VARCHAR2 | (3) | ||
EQUIPMENT_NUMBER_EXT | VARCHAR2 | (35) | ||
CUST_ASSEMBLY_EXT | VARCHAR2 | (30) | ||
CUST_MANUFACTURER_EXT | VARCHAR2 | (35) | ||
CUST_MODEL_SERIAL_NUMBER | VARCHAR2 | (35) | ||
CUST_ORDER_NUM_EXT | VARCHAR2 | (35) | ||
CUST_PROCESS_NUM_EXT | VARCHAR2 | (35) | ||
CUST_PRODUCTION_LINE | VARCHAR2 | (50) | ||
CUST_PRODUCTION_SEQ_NUM | VARCHAR2 | (35) | ||
CUST_SET_NUM_EXT | VARCHAR2 | (35) | ||
CUSTOMER_JOB | VARCHAR2 | (50) | ||
LADING_QUANTITY_EXT | NUMBER | |||
PRIME_CONTRCTR_PART_EXT | VARCHAR2 | (35) | ||
SHIP_TO_CUSTOMER_ID | NUMBER | Related Ship To Customer ID | ||
ORG_ID | NUMBER | Operating Unit ID |
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;
APPS.RLM_SCHEDULE_ITEMS_V is not referenced by any database object
|
|
|