[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | RLM_INTERFACE_LINES_ALL# |
|---|---|
| Object Type: | VIEW |
| Owner: | RLM |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| LINE_ID | NUMBER | Yes | ||
| HEADER_ID | NUMBER | Yes | ||
| AGREEMENT_ID | NUMBER | |||
| ATO_DATA_TYPE | VARCHAR2 | (30) | ||
| 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_ADDRESS_ID | NUMBER | |||
| INVOICE_TO_ORG_ID | NUMBER | |||
| BILL_TO_CITY_EXT | VARCHAR2 | (30) | ||
| BILL_TO_COUNTRY_EXT | VARCHAR2 | (3) | ||
| BILL_TO_COUNTY_EXT | VARCHAR2 | (25) | ||
| BILL_TO_NAME_EXT | VARCHAR2 | (60) | ||
| BILL_TO_POSTAL_CD_EXT | VARCHAR2 | (15) | ||
| BILL_TO_PROVINCE_EXT | VARCHAR2 | (10) | ||
| BILL_TO_SITE_USE_ID | NUMBER | |||
| BILL_TO_STATE_EXT | VARCHAR2 | (10) | ||
| CARRIER_ID_CODE_EXT | VARCHAR2 | (35) | ||
| CARRIER_QUALIFIER_EXT | VARCHAR2 | (3) | ||
| COMMODITY_EXT | VARCHAR2 | (35) | ||
| COUNTRY_OF_ORIGIN_EXT | VARCHAR2 | (35) | ||
| CUST_ASSEMBLY_EXT | VARCHAR2 | (30) | ||
| CUST_ASSIGNED_ID_EXT | VARCHAR2 | (20) | ||
| CUST_BILL_TO_EXT | VARCHAR2 | (35) | ||
| CUST_CONTRACT_NUM_EXT | VARCHAR2 | (35) | ||
| CUSTOMER_DOCK_CODE | VARCHAR2 | (50) | ||
| CUST_INTRMD_SHIP_TO_EXT | VARCHAR2 | (35) | ||
| CUST_ITEM_PRICE_EXT | NUMBER | |||
| CUST_ITEM_PRICE_UOM_EXT | VARCHAR2 | (3) | ||
| CUSTOMER_ITEM_REVISION | VARCHAR2 | (3) | ||
| CUSTOMER_JOB | VARCHAR2 | (50) | ||
| CUST_MANUFACTURER_EXT | VARCHAR2 | (35) | ||
| CUST_MODEL_NUMBER_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) | ||
| CUST_SHIP_FROM_ORG_EXT | VARCHAR2 | (80) | ||
| CUST_SHIP_TO_EXT | VARCHAR2 | (35) | ||
| CUST_UOM_EXT | VARCHAR2 | (10) | ||
| CUSTOMER_ITEM_EXT | VARCHAR2 | (50) | ||
| CUSTOMER_ITEM_ID | NUMBER | |||
| REQUEST_DATE | DATE | |||
| SCHEDULE_DATE | DATE | |||
| DATE_TYPE_CODE | VARCHAR2 | (30) | ||
| DATE_TYPE_CODE_EXT | VARCHAR2 | (30) | ||
| DELIVERY_LEAD_TIME | NUMBER | |||
| END_DATE_TIME | DATE | |||
| EQUIPMENT_CODE_EXT | VARCHAR2 | (3) | ||
| EQUIPMENT_NUMBER_EXT | VARCHAR2 | (35) | ||
| HANDLING_CODE_EXT | VARCHAR2 | (3) | ||
| HAZARD_CODE_EXT | VARCHAR2 | (10) | ||
| HAZARD_CODE_QUAL_EXT | VARCHAR2 | (3) | ||
| HAZARD_DESCRIPTION_EXT | VARCHAR2 | (80) | ||
| IMPORT_LICENSE_DATE_EXT | DATE | |||
| IMPORT_LICENSE_EXT | VARCHAR2 | (35) | ||
| INDUSTRY_ATTRIBUTE1 | VARCHAR2 | (150) | ||
| INDUSTRY_ATTRIBUTE10 | VARCHAR2 | (150) | ||
| INDUSTRY_ATTRIBUTE11 | VARCHAR2 | (150) | ||
| INDUSTRY_ATTRIBUTE12 | VARCHAR2 | (150) | ||
| INDUSTRY_ATTRIBUTE13 | VARCHAR2 | (150) | ||
| INDUSTRY_ATTRIBUTE14 | VARCHAR2 | (150) | ||
| INDUSTRY_ATTRIBUTE15 | VARCHAR2 | (150) | ||
| INDUSTRY_ATTRIBUTE2 | VARCHAR2 | (150) | ||
| INDUSTRY_ATTRIBUTE3 | VARCHAR2 | (150) | ||
| INDUSTRY_ATTRIBUTE4 | VARCHAR2 | (150) | ||
| INDUSTRY_ATTRIBUTE5 | VARCHAR2 | (150) | ||
| INDUSTRY_ATTRIBUTE6 | VARCHAR2 | (150) | ||
| INDUSTRY_ATTRIBUTE7 | VARCHAR2 | (150) | ||
| INDUSTRY_ATTRIBUTE8 | VARCHAR2 | (150) | ||
| INDUSTRY_ATTRIBUTE9 | VARCHAR2 | (150) | ||
| INDUSTRY_CONTEXT | VARCHAR2 | (30) | ||
| INTRMD_SHIP_TO_ID | NUMBER | |||
| SHIP_TO_ORG_ID | NUMBER | |||
| 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_COUNTRY_EXT | VARCHAR2 | (3) | ||
| INTRMD_ST_COUNTY_EXT | VARCHAR2 | (25) | ||
| INTRMD_ST_NAME_EXT | VARCHAR2 | (60) | ||
| INTRMD_ST_POSTAL_CD_EXT | VARCHAR2 | (15) | ||
| INTRMD_ST_PROVINCE_EXT | VARCHAR2 | (10) | ||
| INTRMD_ST_STATE_EXT | VARCHAR2 | (10) | ||
| INTRMD_ST_SITE_USE_ID | NUMBER | |||
| INVENTORY_ITEM_ID | NUMBER | |||
| INVENTORY_ITEM_SEGMENT1 | VARCHAR2 | (40) | ||
| INVENTORY_ITEM_SEGMENT10 | VARCHAR2 | (40) | ||
| INVENTORY_ITEM_SEGMENT11 | VARCHAR2 | (40) | ||
| INVENTORY_ITEM_SEGMENT12 | VARCHAR2 | (40) | ||
| INVENTORY_ITEM_SEGMENT13 | VARCHAR2 | (40) | ||
| INVENTORY_ITEM_SEGMENT14 | VARCHAR2 | (40) | ||
| INVENTORY_ITEM_SEGMENT15 | VARCHAR2 | (40) | ||
| INVENTORY_ITEM_SEGMENT16 | VARCHAR2 | (40) | ||
| INVENTORY_ITEM_SEGMENT17 | VARCHAR2 | (40) | ||
| INVENTORY_ITEM_SEGMENT18 | VARCHAR2 | (40) | ||
| INVENTORY_ITEM_SEGMENT19 | VARCHAR2 | (40) | ||
| INVENTORY_ITEM_SEGMENT2 | VARCHAR2 | (40) | ||
| INVENTORY_ITEM_SEGMENT20 | VARCHAR2 | (40) | ||
| INVENTORY_ITEM_SEGMENT3 | VARCHAR2 | (40) | ||
| INVENTORY_ITEM_SEGMENT4 | VARCHAR2 | (40) | ||
| INVENTORY_ITEM_SEGMENT5 | VARCHAR2 | (40) | ||
| INVENTORY_ITEM_SEGMENT6 | VARCHAR2 | (40) | ||
| INVENTORY_ITEM_SEGMENT7 | VARCHAR2 | (40) | ||
| INVENTORY_ITEM_SEGMENT8 | VARCHAR2 | (40) | ||
| INVENTORY_ITEM_SEGMENT9 | VARCHAR2 | (40) | ||
| ITEM_CONTACT_CODE_1 | VARCHAR2 | (3) | ||
| ITEM_CONTACT_CODE_2 | VARCHAR2 | (3) | ||
| ITEM_CONTACT_VALUE_1 | VARCHAR2 | (80) | ||
| ITEM_CONTACT_VALUE_2 | VARCHAR2 | (80) | ||
| ITEM_DESCRIPTION_EXT | VARCHAR2 | (80) | ||
| ITEM_DETAIL_QUANTITY | NUMBER | |||
| ITEM_DETAIL_REF_CODE_1 | VARCHAR2 | (3) | ||
| ITEM_DETAIL_REF_CODE_2 | VARCHAR2 | (3) | ||
| ITEM_DETAIL_REF_CODE_3 | VARCHAR2 | (3) | ||
| ITEM_DETAIL_REF_VALUE_1 | VARCHAR2 | (35) | ||
| ITEM_DETAIL_REF_VALUE_2 | VARCHAR2 | (35) | ||
| ITEM_DETAIL_REF_VALUE_3 | VARCHAR2 | (35) | ||
| ITEM_DETAIL_SUBTYPE | VARCHAR2 | (30) | ||
| ITEM_DETAIL_SUBTYPE_EXT | VARCHAR2 | (30) | ||
| ITEM_DETAIL_TYPE | VARCHAR2 | (30) | ||
| ITEM_DETAIL_TYPE_EXT | VARCHAR2 | (30) | ||
| ITEM_ENG_CNG_LVL_EXT | VARCHAR2 | (35) | ||
| ITEM_MEASUREMENTS_EXT | VARCHAR2 | (240) | ||
| ITEM_NOTE_TEXT | VARCHAR2 | (4000) | ||
| ITEM_REF_CODE_1 | VARCHAR2 | (3) | ||
| ITEM_REF_CODE_2 | VARCHAR2 | (3) | ||
| ITEM_REF_CODE_3 | VARCHAR2 | (3) | ||
| ITEM_REF_VALUE_1 | VARCHAR2 | (35) | ||
| ITEM_REF_VALUE_2 | VARCHAR2 | (35) | ||
| ITEM_REF_VALUE_3 | VARCHAR2 | (35) | ||
| ITEM_RELEASE_STATUS_EXT | VARCHAR2 | (3) | ||
| LADING_QUANTITY_EXT | NUMBER | |||
| LETTER_CREDIT_EXPDT_EXT | DATE | |||
| LETTER_CREDIT_EXT | VARCHAR2 | (35) | ||
| LINE_REFERENCE | VARCHAR2 | (50) | ||
| LINK_TO_LINE_REF | VARCHAR2 | (50) | ||
| ORDER_HEADER_ID | NUMBER | |||
| ORG_ID | NUMBER | |||
| OTHER_NAME_CODE_1 | VARCHAR2 | (3) | ||
| OTHER_NAME_CODE_2 | VARCHAR2 | (3) | ||
| OTHER_NAME_VALUE_1 | VARCHAR2 | (80) | ||
| OTHER_NAME_VALUE_2 | VARCHAR2 | (80) | ||
| PACK_SIZE_EXT | NUMBER | |||
| PACK_UNITS_PER_PACK_EXT | NUMBER | |||
| PACK_UOM_CODE_EXT | VARCHAR2 | (3) | ||
| PACKAGING_CODE_EXT | VARCHAR2 | (10) | ||
| PARENT_LINK_LINE_REF | VARCHAR2 | (50) | ||
| PRICE_LIST_ID | NUMBER | |||
| PRIMARY_QUANTITY | NUMBER | |||
| PRIMARY_UOM_CODE | VARCHAR2 | (3) | ||
| PRIME_CONTRCTR_PART_EXT | VARCHAR2 | (35) | ||
| PROCESS_STATUS | NUMBER | |||
| CUST_PO_RELEASE_NUM | VARCHAR2 | (35) | ||
| CUST_PO_DATE | DATE | |||
| CUST_PO_LINE_NUM | VARCHAR2 | (35) | ||
| CUST_PO_NUMBER | VARCHAR2 | (50) | ||
| QTY_TYPE_CODE | VARCHAR2 | (30) | ||
| QTY_TYPE_CODE_EXT | VARCHAR2 | (30) | ||
| RETURN_CONTAINER_EXT | VARCHAR2 | (35) | ||
| SCHEDULE_LINE_ID | NUMBER | |||
| ROUTING_DESC_EXT | VARCHAR2 | (35) | ||
| ROUTING_SEQ_CODE_EXT | VARCHAR2 | (3) | ||
| SCHEDULE_ITEM_NUM | NUMBER | |||
| SHIP_DEL_PATTERN_EXT | VARCHAR2 | (3) | ||
| SHIP_DEL_TIME_CODE_EXT | VARCHAR2 | (3) | ||
| SHIP_DEL_RULE_NAME | VARCHAR2 | (30) | ||
| 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_COUNTRY_EXT | VARCHAR2 | (3) | ||
| SHIP_FROM_COUNTY_EXT | VARCHAR2 | (25) | ||
| SHIP_FROM_NAME_EXT | VARCHAR2 | (60) | ||
| SHIP_FROM_ORG_ID | NUMBER | |||
| SHIP_FROM_POSTAL_CD_EXT | VARCHAR2 | (15) | ||
| SHIP_FROM_PROVINCE_EXT | VARCHAR2 | (10) | ||
| SHIP_FROM_STATE_EXT | VARCHAR2 | (10) | ||
| SHIP_LABEL_INFO_LINE_1 | VARCHAR2 | (80) | ||
| SHIP_LABEL_INFO_LINE_10 | 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_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_ADDRESS_ID | NUMBER | |||
| DELIVER_TO_ORG_ID | NUMBER | |||
| SHIP_TO_CITY_EXT | VARCHAR2 | (30) | ||
| SHIP_TO_COUNTRY_EXT | VARCHAR2 | (3) | ||
| SHIP_TO_COUNTY_EXT | VARCHAR2 | (25) | ||
| SHIP_TO_NAME_EXT | VARCHAR2 | (60) | ||
| SHIP_TO_POSTAL_CD_EXT | VARCHAR2 | (15) | ||
| SHIP_TO_PROVINCE_EXT | VARCHAR2 | (10) | ||
| SHIP_TO_SITE_USE_ID | NUMBER | |||
| SHIP_TO_STATE_EXT | VARCHAR2 | (10) | ||
| START_DATE_TIME | DATE | |||
| SUBLINE_ASSIGNED_ID_EXT | VARCHAR2 | (20) | ||
| SUBLINE_CONFIG_CODE_EXT | VARCHAR2 | (3) | ||
| SUBLINE_CUST_ITEM_EXT | VARCHAR2 | (50) | ||
| SUBLINE_CUST_ITEM_ID | NUMBER | |||
| SUBLINE_MODEL_NUM_EXT | VARCHAR2 | (35) | ||
| SUBLINE_QUANTITY | NUMBER | |||
| SUBLINE_UOM_CODE | VARCHAR2 | (3) | ||
| SUPPLIER_ITEM_EXT | VARCHAR2 | (35) | ||
| TRANSIT_TIME_EXT | VARCHAR2 | (22) | ||
| TRANSIT_TIME_QUAL_EXT | VARCHAR2 | (3) | ||
| TRANSPORT_LOC_QUAL_EXT | VARCHAR2 | (3) | ||
| TRANSPORT_LOCATION_EXT | VARCHAR2 | (35) | ||
| TRANSPORT_METHOD_EXT | VARCHAR2 | (3) | ||
| UOM_CODE | VARCHAR2 | (3) | ||
| WEIGHT_EXT | NUMBER | |||
| WEIGHT_QUALIFIER_EXT | VARCHAR2 | (3) | ||
| WEIGHT_UOM_EXT | VARCHAR2 | (3) | ||
| FBO_CONFIGURATION_KEY_1 | VARCHAR2 | (35) | ||
| FBO_CONFIGURATION_KEY_2 | VARCHAR2 | (35) | ||
| FBO_CONFIGURATION_KEY_3 | VARCHAR2 | (35) | ||
| FBO_CONFIGURATION_KEY_4 | VARCHAR2 | (35) | ||
| FBO_CONFIGURATION_KEY_5 | VARCHAR2 | (35) | ||
| MATCH_KEY_ACROSS | VARCHAR2 | (150) | ||
| MATCH_KEY_WITHIN | VARCHAR2 | (150) | ||
| CRITICAL_KEY_ATTRIBUTES | VARCHAR2 | (150) | ||
| LAST_UPDATE_DATE | DATE | Yes | ||
| LAST_UPDATED_BY | NUMBER | Yes | ||
| CREATION_DATE | DATE | Yes | ||
| CREATED_BY | NUMBER | Yes | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
| ATTRIBUTE1 | VARCHAR2 | (150) | ||
| ATTRIBUTE2 | VARCHAR2 | (150) | ||
| ATTRIBUTE3 | VARCHAR2 | (150) | ||
| ATTRIBUTE4 | VARCHAR2 | (150) | ||
| ATTRIBUTE5 | VARCHAR2 | (150) | ||
| ATTRIBUTE6 | VARCHAR2 | (150) | ||
| ATTRIBUTE7 | VARCHAR2 | (150) | ||
| ATTRIBUTE8 | VARCHAR2 | (150) | ||
| ATTRIBUTE9 | VARCHAR2 | (150) | ||
| ATTRIBUTE10 | VARCHAR2 | (150) | ||
| ATTRIBUTE11 | VARCHAR2 | (150) | ||
| ATTRIBUTE12 | VARCHAR2 | (150) | ||
| ATTRIBUTE13 | VARCHAR2 | (150) | ||
| ATTRIBUTE14 | VARCHAR2 | (150) | ||
| ATTRIBUTE15 | VARCHAR2 | (150) | ||
| LAST_UPDATE_LOGIN | NUMBER | |||
| REQUEST_ID | NUMBER | |||
| PROGRAM_APPLICATION_ID | NUMBER | |||
| PROGRAM_ID | NUMBER | |||
| PROGRAM_UPDATE_DATE | DATE | |||
| TP_ATTRIBUTE1 | VARCHAR2 | (150) | ||
| TP_ATTRIBUTE2 | VARCHAR2 | (150) | ||
| TP_ATTRIBUTE3 | VARCHAR2 | (150) | ||
| TP_ATTRIBUTE4 | VARCHAR2 | (150) | ||
| TP_ATTRIBUTE5 | VARCHAR2 | (150) | ||
| TP_ATTRIBUTE6 | VARCHAR2 | (150) | ||
| TP_ATTRIBUTE7 | VARCHAR2 | (150) | ||
| TP_ATTRIBUTE8 | VARCHAR2 | (150) | ||
| TP_ATTRIBUTE9 | VARCHAR2 | (150) | ||
| TP_ATTRIBUTE10 | VARCHAR2 | (150) | ||
| TP_ATTRIBUTE11 | VARCHAR2 | (150) | ||
| TP_ATTRIBUTE12 | VARCHAR2 | (150) | ||
| TP_ATTRIBUTE13 | VARCHAR2 | (150) | ||
| TP_ATTRIBUTE14 | VARCHAR2 | (150) | ||
| TP_ATTRIBUTE15 | VARCHAR2 | (150) | ||
| TP_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
| LINE_NUMBER | NUMBER | |||
| INTMED_SHIP_TO_ORG_ID | NUMBER | |||
| LINE_SOURCE | VARCHAR2 | (30) | ||
| PREFERRED_GRADE | VARCHAR2 | (4) | ||
| CUST_PRODUCTION_SEQ_NUM_BEG | VARCHAR2 | (35) | ||
| CUST_PRODUCTION_SEQ_NUM_END | VARCHAR2 | (35) | ||
| ITEM_DETAIL_QUANTITY_MIN_EXT | NUMBER | |||
| ITEM_DETAIL_QUANTITY_MAX_EXT | NUMBER | |||
| ITEM_DETAIL_QUANTITY_PRIOR_EXT | NUMBER | |||
| REQUIREMENT_PRIORITY_EXT | NUMBER | |||
| PROJECT_NUMBER_EXT | VARCHAR2 | (50) | ||
| RESP_LINE_NUMBER | VARCHAR2 | (35) | ||
| TASK_NUMBER_EXT | VARCHAR2 | (50) | ||
| UPC_EXT | VARCHAR2 | (50) | ||
| ITEM_ENG_CNG_LVL_DATE_EXT | DATE | |||
| AUTHORIZATION_CODE_EXT | VARCHAR2 | (50) | ||
| PACKAGING_DESC_EXT | VARCHAR2 | (80) | ||
| BILL_TO_ADDRESS_5_EXT | VARCHAR2 | (35) | ||
| BILL_TO_ADDRESS_6_EXT | VARCHAR2 | (35) | ||
| BILL_TO_ADDRESS_7_EXT | VARCHAR2 | (35) | ||
| BILL_TO_ADDRESS_8_EXT | VARCHAR2 | (35) | ||
| BILL_TO_ADDRESS_9_EXT | VARCHAR2 | (35) | ||
| ONE_TIME_BILL_TO_FLAG_EXT | VARCHAR2 | (35) | ||
| BILL_TO_DESCRIPTION_EXT | VARCHAR2 | (50) | ||
| BILL_TO_FAX_EXT | VARCHAR2 | (35) | ||
| BILL_TO_REGION_EXT | VARCHAR2 | (35) | ||
| BILL_TO_JURISDICTION_EXT | VARCHAR2 | (35) | ||
| BILL_TO_TEL_EXT | VARCHAR2 | (35) | ||
| INTRMD_ST_ADDRESS_5_EXT | VARCHAR2 | (35) | ||
| INTRMD_ST_ADDRESS_6_EXT | VARCHAR2 | (35) | ||
| INTRMD_ST_ADDRESS_7_EXT | VARCHAR2 | (35) | ||
| INTRMD_ST_ADDRESS_8_EXT | VARCHAR2 | (35) | ||
| INTRMD_ST_ADDRESS_9_EXT | VARCHAR2 | (35) | ||
| ONE_TIME_INTRMD_ST_FLAG_EXT | VARCHAR2 | (35) | ||
| INTRMD_ST_DESCRIPTION_EXT | VARCHAR2 | (50) | ||
| INTRMD_ST_FAX_EXT | VARCHAR2 | (35) | ||
| INTRMD_ST_REGION_EXT | VARCHAR2 | (35) | ||
| INTRMD_ST_JURISDICTION_EXT | VARCHAR2 | (35) | ||
| INTRMD_ST_TEL_EXT | VARCHAR2 | (35) | ||
| SHIP_TO_ADDRESS_5_EXT | VARCHAR2 | (35) | ||
| SHIP_TO_ADDRESS_6_EXT | VARCHAR2 | (35) | ||
| SHIP_TO_ADDRESS_7_EXT | VARCHAR2 | (35) | ||
| SHIP_TO_ADDRESS_8_EXT | VARCHAR2 | (35) | ||
| SHIP_TO_ADDRESS_9_EXT | VARCHAR2 | (35) | ||
| ONE_TIME_SHIP_TO_FLAG_EXT | VARCHAR2 | (35) | ||
| SHIP_TO_DESCRIPTION_EXT | VARCHAR2 | (50) | ||
| SHIP_TO_FAX_EXT | VARCHAR2 | (35) | ||
| SHIP_TO_REGION_EXT | VARCHAR2 | (35) | ||
| SHIP_TO_JURISDICTION_EXT | VARCHAR2 | (35) | ||
| SHIP_TO_TEL_EXT | VARCHAR2 | (35) | ||
| SHIP_FROM_ADDRESS_5_EXT | VARCHAR2 | (35) | ||
| SHIP_FROM_ADDRESS_6_EXT | VARCHAR2 | (35) | ||
| SHIP_FROM_ADDRESS_7_EXT | VARCHAR2 | (35) | ||
| SHIP_FROM_ADDRESS_8_EXT | VARCHAR2 | (35) | ||
| SHIP_FROM_ADDRESS_9_EXT | VARCHAR2 | (35) | ||
| ONE_TIME_SHIP_FROM_FLAG_EXT | VARCHAR2 | (35) | ||
| SHIP_FROM_DESCRIPTION_EXT | VARCHAR2 | (50) | ||
| SHIP_FROM_FAX_EXT | VARCHAR2 | (35) | ||
| SHIP_FROM_REGION_EXT | VARCHAR2 | (35) | ||
| SHIP_FROM_JURISDICTION_EXT | VARCHAR2 | (35) | ||
| SHIP_FROM_TEL_EXT | VARCHAR2 | (35) | ||
| FLEX_BKT_CODE | VARCHAR2 | (30) | ||
| FLEX_BKT_FLAG | VARCHAR2 | (2) | ||
| BLANKET_NUMBER | NUMBER | |||
| DSP_CHILD_PROCESS_INDEX | NUMBER | |||
| SHIP_TO_CUSTOMER_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT LINE_ID
, HEADER_ID
, AGREEMENT_ID
, ATO_DATA_TYPE
, BILL_TO_ADDRESS_1_EXT
, BILL_TO_ADDRESS_2_EXT
, BILL_TO_ADDRESS_3_EXT
, BILL_TO_ADDRESS_4_EXT
, BILL_TO_ADDRESS_ID
, INVOICE_TO_ORG_ID
, BILL_TO_CITY_EXT
, BILL_TO_COUNTRY_EXT
, BILL_TO_COUNTY_EXT
, BILL_TO_NAME_EXT
, BILL_TO_POSTAL_CD_EXT
, BILL_TO_PROVINCE_EXT
, BILL_TO_SITE_USE_ID
, BILL_TO_STATE_EXT
, CARRIER_ID_CODE_EXT
, CARRIER_QUALIFIER_EXT
, COMMODITY_EXT
, COUNTRY_OF_ORIGIN_EXT
, CUST_ASSEMBLY_EXT
, CUST_ASSIGNED_ID_EXT
, CUST_BILL_TO_EXT
, CUST_CONTRACT_NUM_EXT
, CUSTOMER_DOCK_CODE
, CUST_INTRMD_SHIP_TO_EXT
, CUST_ITEM_PRICE_EXT
, CUST_ITEM_PRICE_UOM_EXT
, CUSTOMER_ITEM_REVISION
, CUSTOMER_JOB
, CUST_MANUFACTURER_EXT
, CUST_MODEL_NUMBER_EXT
, CUST_MODEL_SERIAL_NUMBER
, CUST_ORDER_NUM_EXT
, CUST_PROCESS_NUM_EXT
, CUST_PRODUCTION_LINE
, CUST_PRODUCTION_SEQ_NUM
, CUST_SET_NUM_EXT
, CUST_SHIP_FROM_ORG_EXT
, CUST_SHIP_TO_EXT
, CUST_UOM_EXT
, CUSTOMER_ITEM_EXT
, CUSTOMER_ITEM_ID
, REQUEST_DATE
, SCHEDULE_DATE
, DATE_TYPE_CODE
, DATE_TYPE_CODE_EXT
, DELIVERY_LEAD_TIME
, END_DATE_TIME
, EQUIPMENT_CODE_EXT
, EQUIPMENT_NUMBER_EXT
, HANDLING_CODE_EXT
, HAZARD_CODE_EXT
, HAZARD_CODE_QUAL_EXT
, HAZARD_DESCRIPTION_EXT
, IMPORT_LICENSE_DATE_EXT
, IMPORT_LICENSE_EXT
, INDUSTRY_ATTRIBUTE1
, INDUSTRY_ATTRIBUTE10
, INDUSTRY_ATTRIBUTE11
, INDUSTRY_ATTRIBUTE12
, INDUSTRY_ATTRIBUTE13
, INDUSTRY_ATTRIBUTE14
, INDUSTRY_ATTRIBUTE15
, INDUSTRY_ATTRIBUTE2
, INDUSTRY_ATTRIBUTE3
, INDUSTRY_ATTRIBUTE4
, INDUSTRY_ATTRIBUTE5
, INDUSTRY_ATTRIBUTE6
, INDUSTRY_ATTRIBUTE7
, INDUSTRY_ATTRIBUTE8
, INDUSTRY_ATTRIBUTE9
, INDUSTRY_CONTEXT
, INTRMD_SHIP_TO_ID
, SHIP_TO_ORG_ID
, 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_COUNTRY_EXT
, INTRMD_ST_COUNTY_EXT
, INTRMD_ST_NAME_EXT
, INTRMD_ST_POSTAL_CD_EXT
, INTRMD_ST_PROVINCE_EXT
, INTRMD_ST_STATE_EXT
, INTRMD_ST_SITE_USE_ID
, INVENTORY_ITEM_ID
, INVENTORY_ITEM_SEGMENT1
, INVENTORY_ITEM_SEGMENT10
, INVENTORY_ITEM_SEGMENT11
, INVENTORY_ITEM_SEGMENT12
, INVENTORY_ITEM_SEGMENT13
, INVENTORY_ITEM_SEGMENT14
, INVENTORY_ITEM_SEGMENT15
, INVENTORY_ITEM_SEGMENT16
, INVENTORY_ITEM_SEGMENT17
, INVENTORY_ITEM_SEGMENT18
, INVENTORY_ITEM_SEGMENT19
, INVENTORY_ITEM_SEGMENT2
, INVENTORY_ITEM_SEGMENT20
, INVENTORY_ITEM_SEGMENT3
, INVENTORY_ITEM_SEGMENT4
, INVENTORY_ITEM_SEGMENT5
, INVENTORY_ITEM_SEGMENT6
, INVENTORY_ITEM_SEGMENT7
, INVENTORY_ITEM_SEGMENT8
, INVENTORY_ITEM_SEGMENT9
, ITEM_CONTACT_CODE_1
, ITEM_CONTACT_CODE_2
, ITEM_CONTACT_VALUE_1
, ITEM_CONTACT_VALUE_2
, ITEM_DESCRIPTION_EXT
, ITEM_DETAIL_QUANTITY
, ITEM_DETAIL_REF_CODE_1
, ITEM_DETAIL_REF_CODE_2
, ITEM_DETAIL_REF_CODE_3
, ITEM_DETAIL_REF_VALUE_1
, ITEM_DETAIL_REF_VALUE_2
, ITEM_DETAIL_REF_VALUE_3
, ITEM_DETAIL_SUBTYPE
, ITEM_DETAIL_SUBTYPE_EXT
, ITEM_DETAIL_TYPE
, ITEM_DETAIL_TYPE_EXT
, ITEM_ENG_CNG_LVL_EXT
, ITEM_MEASUREMENTS_EXT
, ITEM_NOTE_TEXT
, ITEM_REF_CODE_1
, ITEM_REF_CODE_2
, ITEM_REF_CODE_3
, ITEM_REF_VALUE_1
, ITEM_REF_VALUE_2
, ITEM_REF_VALUE_3
, ITEM_RELEASE_STATUS_EXT
, LADING_QUANTITY_EXT
, LETTER_CREDIT_EXPDT_EXT
, LETTER_CREDIT_EXT
, LINE_REFERENCE
, LINK_TO_LINE_REF
, ORDER_HEADER_ID
, ORG_ID
, OTHER_NAME_CODE_1
, OTHER_NAME_CODE_2
, OTHER_NAME_VALUE_1
, OTHER_NAME_VALUE_2
, PACK_SIZE_EXT
, PACK_UNITS_PER_PACK_EXT
, PACK_UOM_CODE_EXT
, PACKAGING_CODE_EXT
, PARENT_LINK_LINE_REF
, PRICE_LIST_ID
, PRIMARY_QUANTITY
, PRIMARY_UOM_CODE
, PRIME_CONTRCTR_PART_EXT
, PROCESS_STATUS
, CUST_PO_RELEASE_NUM
, CUST_PO_DATE
, CUST_PO_LINE_NUM
, CUST_PO_NUMBER
, QTY_TYPE_CODE
, QTY_TYPE_CODE_EXT
, RETURN_CONTAINER_EXT
, SCHEDULE_LINE_ID
, ROUTING_DESC_EXT
, ROUTING_SEQ_CODE_EXT
, SCHEDULE_ITEM_NUM
, SHIP_DEL_PATTERN_EXT
, SHIP_DEL_TIME_CODE_EXT
, SHIP_DEL_RULE_NAME
, 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_COUNTRY_EXT
, SHIP_FROM_COUNTY_EXT
, SHIP_FROM_NAME_EXT
, SHIP_FROM_ORG_ID
, SHIP_FROM_POSTAL_CD_EXT
, SHIP_FROM_PROVINCE_EXT
, SHIP_FROM_STATE_EXT
, SHIP_LABEL_INFO_LINE_1
, SHIP_LABEL_INFO_LINE_10
, 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_TO_ADDRESS_1_EXT
, SHIP_TO_ADDRESS_2_EXT
, SHIP_TO_ADDRESS_3_EXT
, SHIP_TO_ADDRESS_4_EXT
, SHIP_TO_ADDRESS_ID
, DELIVER_TO_ORG_ID
, SHIP_TO_CITY_EXT
, SHIP_TO_COUNTRY_EXT
, SHIP_TO_COUNTY_EXT
, SHIP_TO_NAME_EXT
, SHIP_TO_POSTAL_CD_EXT
, SHIP_TO_PROVINCE_EXT
, SHIP_TO_SITE_USE_ID
, SHIP_TO_STATE_EXT
, START_DATE_TIME
, SUBLINE_ASSIGNED_ID_EXT
, SUBLINE_CONFIG_CODE_EXT
, SUBLINE_CUST_ITEM_EXT
, SUBLINE_CUST_ITEM_ID
, SUBLINE_MODEL_NUM_EXT
, SUBLINE_QUANTITY
, SUBLINE_UOM_CODE
, SUPPLIER_ITEM_EXT
, TRANSIT_TIME_EXT
, TRANSIT_TIME_QUAL_EXT
, TRANSPORT_LOC_QUAL_EXT
, TRANSPORT_LOCATION_EXT
, TRANSPORT_METHOD_EXT
, UOM_CODE
, WEIGHT_EXT
, WEIGHT_QUALIFIER_EXT
, WEIGHT_UOM_EXT
, FBO_CONFIGURATION_KEY_1
, FBO_CONFIGURATION_KEY_2
, FBO_CONFIGURATION_KEY_3
, FBO_CONFIGURATION_KEY_4
, FBO_CONFIGURATION_KEY_5
, MATCH_KEY_ACROSS
, MATCH_KEY_WITHIN
, CRITICAL_KEY_ATTRIBUTES
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, TP_ATTRIBUTE1
, TP_ATTRIBUTE2
, TP_ATTRIBUTE3
, TP_ATTRIBUTE4
, TP_ATTRIBUTE5
, TP_ATTRIBUTE6
, TP_ATTRIBUTE7
, TP_ATTRIBUTE8
, TP_ATTRIBUTE9
, TP_ATTRIBUTE10
, TP_ATTRIBUTE11
, TP_ATTRIBUTE12
, TP_ATTRIBUTE13
, TP_ATTRIBUTE14
, TP_ATTRIBUTE15
, TP_ATTRIBUTE_CATEGORY
, LINE_NUMBER
, INTMED_SHIP_TO_ORG_ID
, LINE_SOURCE
, PREFERRED_GRADE
, CUST_PRODUCTION_SEQ_NUM_BEG
, CUST_PRODUCTION_SEQ_NUM_END
, ITEM_DETAIL_QUANTITY_MIN_EXT
, ITEM_DETAIL_QUANTITY_MAX_EXT
, ITEM_DETAIL_QUANTITY_PRIOR_EXT
, REQUIREMENT_PRIORITY_EXT
, PROJECT_NUMBER_EXT
, RESP_LINE_NUMBER
, TASK_NUMBER_EXT
, UPC_EXT
, ITEM_ENG_CNG_LVL_DATE_EXT
, AUTHORIZATION_CODE_EXT
, PACKAGING_DESC_EXT
, BILL_TO_ADDRESS_5_EXT
, BILL_TO_ADDRESS_6_EXT
, BILL_TO_ADDRESS_7_EXT
, BILL_TO_ADDRESS_8_EXT
, BILL_TO_ADDRESS_9_EXT
, ONE_TIME_BILL_TO_FLAG_EXT
, BILL_TO_DESCRIPTION_EXT
, BILL_TO_FAX_EXT
, BILL_TO_REGION_EXT
, BILL_TO_JURISDICTION_EXT
, BILL_TO_TEL_EXT
, INTRMD_ST_ADDRESS_5_EXT
, INTRMD_ST_ADDRESS_6_EXT
, INTRMD_ST_ADDRESS_7_EXT
, INTRMD_ST_ADDRESS_8_EXT
, INTRMD_ST_ADDRESS_9_EXT
, ONE_TIME_INTRMD_ST_FLAG_EXT
, INTRMD_ST_DESCRIPTION_EXT
, INTRMD_ST_FAX_EXT
, INTRMD_ST_REGION_EXT
, INTRMD_ST_JURISDICTION_EXT
, INTRMD_ST_TEL_EXT
, SHIP_TO_ADDRESS_5_EXT
, SHIP_TO_ADDRESS_6_EXT
, SHIP_TO_ADDRESS_7_EXT
, SHIP_TO_ADDRESS_8_EXT
, SHIP_TO_ADDRESS_9_EXT
, ONE_TIME_SHIP_TO_FLAG_EXT
, SHIP_TO_DESCRIPTION_EXT
, SHIP_TO_FAX_EXT
, SHIP_TO_REGION_EXT
, SHIP_TO_JURISDICTION_EXT
, SHIP_TO_TEL_EXT
, SHIP_FROM_ADDRESS_5_EXT
, SHIP_FROM_ADDRESS_6_EXT
, SHIP_FROM_ADDRESS_7_EXT
, SHIP_FROM_ADDRESS_8_EXT
, SHIP_FROM_ADDRESS_9_EXT
, ONE_TIME_SHIP_FROM_FLAG_EXT
, SHIP_FROM_DESCRIPTION_EXT
, SHIP_FROM_FAX_EXT
, SHIP_FROM_REGION_EXT
, SHIP_FROM_JURISDICTION_EXT
, SHIP_FROM_TEL_EXT
, FLEX_BKT_CODE
, FLEX_BKT_FLAG
, BLANKET_NUMBER
, DSP_CHILD_PROCESS_INDEX
, SHIP_TO_CUSTOMER_ID
FROM RLM.RLM_INTERFACE_LINES_ALL#;
RLM
RLM_INTERFACE_LINES_ALL
APPS
RLM_INTERFACE_LINES
RLM_INTERFACE_LINES_ALL
|
|
|
|