[Home] [Help] [Dependency Information]
Object Name: | RLM_SCHEDULE_HEADERS_ALL |
---|---|
Object Type: | TABLE |
Owner: | RLM |
FND Design Data: | RLM.RLM_SCHEDULE_HEADERS_ALL |
Subobject Name: | |
Status: | VALID |
This table stores the header level details of the Release Management schedules. It has details pertainig to the specific schedule and customer level information. Release Management demand Processor uses this table to maintain a current picture of demand schedule headers.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
RLM_SCHEDULE_HEADERS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | HEADER_ID |
RLM_SCHEDULE_HEADERS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | SCHEDULE_REFERENCE_NUM |
RLM_SCHEDULE_HEADERS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
CUSTOMER_ID
SCHEDULE_TYPE SCHED_HORIZON_START_DATE |
RLM_SCHEDULE_HEADERS_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ECE_TP_LOCATION_CODE_EXT |
RLM_SCHEDULE_HEADERS_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CUST_NAME_EXT |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
HEADER_ID | NUMBER | Yes | Schedule unique identifier | |
CUSTOMER_ID | NUMBER | Yes | Ship-to Customer unique identifier. FK to RA_CUSTOMERS | |
SCHEDULE_TYPE | VARCHAR2 | (30) | Yes | Schedule Type: Planning, Shipping or Sequenced Validated against FND_LOOKUPS.LOOKUP_TYPE = RLM_SCHEDULE_TYPE |
SCHED_HORIZON_END_DATE | DATE | Yes | Schedule horizon end date | |
SCHED_HORIZON_START_DATE | DATE | Yes | Schedule horizon start date | |
SCHEDULE_SOURCE | VARCHAR2 | (30) | Yes | EDI or manual transaction source identifier for this schedule, i.e. 830, 862, 866, DELFOR, MANUAL, etc. |
SCHEDULE_PURPOSE | VARCHAR2 | (30) | Yes | Schedule purpose code, i.e. Original, Replace, Cancellation, etc. Validated against FND_LOOKUPS.LOOKUP_TYPE = RLM_SCHEDULE_PURPOSE |
SCHEDULE_REFERENCE_NUM | VARCHAR2 | (35) | Yes | Customer assigned schedule reference or release number |
CUST_ADDRESS_1_EXT | VARCHAR2 | (35) | Customer address line 1, as sent by the customer on the N3 segment. | |
CUST_ADDRESS_2_EXT | VARCHAR2 | (35) | Customer address line 2, as sent by the customer on the N3 segment. | |
CUST_ADDRESS_3_EXT | VARCHAR2 | (35) | Customer address line 3, as sent by the customer on the N3 segment. | |
CUST_ADDRESS_4_EXT | VARCHAR2 | (35) | Customer address line 4, as sent by the customer on the N3 segment. | |
CUST_CITY_EXT | VARCHAR2 | (30) | Customer address city, as sent by the customer on the N4 segment. | |
CUST_COUNTRY_EXT | VARCHAR2 | (3) | Customer country, as sent by the customer on the N4 segment. | |
CUST_COUNTY_EXT | VARCHAR2 | (25) | Customer county, as sent by the customer on the N4 segment. | |
CUSTOMER_EXT | VARCHAR2 | (35) | Customer external value | |
CUST_NAME_EXT | VARCHAR2 | (360) | Customer Name, as sent by the customer in the N1 and/or N2 segment. | |
CUST_POSTAL_CD_EXT | VARCHAR2 | (15) | Customer address postal code,as sent by the customer on the N4 segment. | |
CUST_PROVINCE_EXT | VARCHAR2 | (10) | Customer province, as sent by the customer on the N4 segment. | |
CUST_STATE_EXT | VARCHAR2 | (10) | Customer state, as sent by the customer on the N4 segment. | |
ECE_PRIMARY_ADDRESS_ID | NUMBER | Customer Primary Address ID populated by EDI Gateway code conversion. FK to RA_ADDRESSES. | ||
ECE_TP_LOCATION_CODE_EXT | VARCHAR2 | (35) | For EDI transactions only, external Trading Partner Location Code assigned to the transaction | |
ECE_TP_TRANSLATOR_CODE | VARCHAR2 | (35) | For EDI transactions only, EDI Gateway Trading Partner Code assigned to the transaction | |
EDI_CONTROL_NUM_1 | VARCHAR2 | (15) | EDI control number 1 (ISA) assigned by the customer EDI translator for audit. | |
EDI_CONTROL_NUM_2 | VARCHAR2 | (15) | EDI control number 2 (GS) assigned by the customer EDI translator for audit. | |
EDI_CONTROL_NUM_3 | VARCHAR2 | (15) | EDI control number 3 (ST) assigned by the customer EDI translator for audit. | |
EDI_TEST_INDICATOR | VARCHAR2 | (1) | EDI Test/Production transaction indicator (T or P), assigned by the customer EDI translator. EDI Gateway rules determine the handling of test transactions within the Demand Processor. | |
HEADER_CONTACT_CODE_1 | VARCHAR2 | (3) | Contact code 1 included in customer EDI transaction (not validated) | |
HEADER_CONTACT_CODE_2 | VARCHAR2 | (3) | Contact code 2 included in customer EDI transaction (not validated) | |
HEADER_CONTACT_VALUE_1 | VARCHAR2 | (80) | Values associated with Contact code 1: concatenation of name, communication code, and communication number | |
HEADER_CONTACT_VALUE_2 | VARCHAR2 | (80) | Values associated with Contact code 2 : concatenation of name, communication code, and communication number | |
HEADER_NOTE_TEXT | VARCHAR2 | (4000) | Free form note text included in the schedule at the header level | |
HEADER_REF_CODE_1 | VARCHAR2 | (3) | Reference code 1 included in customer EDI transaction. | |
HEADER_REF_CODE_2 | VARCHAR2 | (3) | Reference code 2 included in customer EDI transaction | |
HEADER_REF_CODE_3 | VARCHAR2 | (3) | Reference code 3 included in customer EDI transaction | |
HEADER_REF_VALUE_1 | VARCHAR2 | (35) | Value associated with Reference code 1 | |
HEADER_REF_VALUE_2 | VARCHAR2 | (35) | Value associated with Reference code 2 | |
HEADER_REF_VALUE_3 | VARCHAR2 | (35) | Value associated with Reference code 3 | |
ORG_ID | NUMBER | Operating unit unique ID. FK to HR_ORGANIZATION_UNITS. | ||
SCHEDULE_TYPE_EXT | VARCHAR2 | (30) | External value from which RLM_SCHEDULE_TYPE was derived in EDI Gateway Code Conversion. | |
SCHED_GENERATION_DATE | DATE | Date customer generated either the schedule or the planning information on the schedule. | ||
SCHEDULE_PURPOSE_EXT | VARCHAR2 | (30) | External value from which SCHEDULE_PURPOSE was derived in EDI Gateway Code Conversion. | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | Yes | Standard Who column | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield context column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
REQUEST_ID | NUMBER | Standard Who column | ||
PROGRAM_APPLICATION_ID | NUMBER | Standard Who column | ||
PROGRAM_ID | NUMBER | Standard Who column | ||
PROGRAM_UPDATE_DATE | DATE | Standard Who column | ||
TP_ATTRIBUTE1 | VARCHAR2 | (150) | Trading Partner flexfield segment column | |
TP_ATTRIBUTE2 | VARCHAR2 | (150) | Trading Partner flexfield segment column | |
TP_ATTRIBUTE3 | VARCHAR2 | (150) | Trading Partner flexfield segment column | |
TP_ATTRIBUTE4 | VARCHAR2 | (150) | Trading Partner flexfield segment column | |
TP_ATTRIBUTE5 | VARCHAR2 | (150) | Trading Partner flexfield segment column | |
TP_ATTRIBUTE6 | VARCHAR2 | (150) | Trading Partner flexfield segment column | |
TP_ATTRIBUTE7 | VARCHAR2 | (150) | Trading Partner flexfield segment column | |
TP_ATTRIBUTE8 | VARCHAR2 | (150) | Trading Partner flexfield segment column | |
TP_ATTRIBUTE9 | VARCHAR2 | (150) | Trading Partner flexfield segment column | |
TP_ATTRIBUTE10 | VARCHAR2 | (150) | Trading Partner flexfield segment column | |
TP_ATTRIBUTE11 | VARCHAR2 | (150) | Trading Partner flexfield segment column | |
TP_ATTRIBUTE12 | VARCHAR2 | (150) | Trading Partner flexfield segment column | |
TP_ATTRIBUTE13 | VARCHAR2 | (150) | Trading Partner flexfield segment column | |
TP_ATTRIBUTE14 | VARCHAR2 | (150) | Trading Partner flexfield segment column | |
TP_ATTRIBUTE15 | VARCHAR2 | (150) | Trading Partner flexfield segment column | |
TP_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Trading Partner flexfield context column | |
PROCESS_STATUS | NUMBER | Indicates the current processing status of a record (1=do not process, 2=waiting to be processed, 3=in process, 4=error, 5=processed, 6='processed with error(s)' for headers with lines in-error.) | ||
INTERFACE_HEADER_ID | NUMBER | Foreign Key to SCHEDULE_HEADER_ID in interface table | ||
CUST_ADDRESS_5_EXT | VARCHAR2 | (35) | For future use | |
CUST_ADDRESS_6_EXT | VARCHAR2 | (35) | For future use | |
CUST_ADDRESS_7_EXT | VARCHAR2 | (35) | For future use | |
CUST_ADDRESS_8_EXT | VARCHAR2 | (35) | For future use | |
CUST_ADDRESS_9_EXT | VARCHAR2 | (35) | For future use | |
ORIGINAL_DOCUMENT_DATE | DATE | For future use | ||
RESP_DOCUMENT_DATE | DATE | For future use | ||
DOCUMENT_DESCRIPTION | VARCHAR2 | (50) | For future use | |
DOCUMENT_REV_NUM | VARCHAR2 | (35) | For future use | |
RESP_SCHEDULE_ID | VARCHAR2 | (35) | For future use | |
RESP_DOCUMENT_REV_NUM | VARCHAR2 | (35) | For future use | |
ONE_TIME_CUST_FLAG_EXT | VARCHAR2 | (35) | For future use | |
CURRENCY_EXT | VARCHAR2 | (35) | For future use | |
TAX_EXEMPT_FLAG_EXT | VARCHAR2 | (35) | For future use | |
TAX_ID_EXT | VARCHAR2 | (35) | For future use | |
CUST_FAX_EXT | VARCHAR2 | (35) | For future use | |
CUST_REGION_EXT | VARCHAR2 | (35) | For future use | |
CUST_TAX_JURISDICTION_EXT | VARCHAR2 | (35) | For future use | |
CUST_TEL_EXT | VARCHAR2 | (35) | For future use | |
CUST_URL_EXT | VARCHAR2 | (100) | For future use | |
HEADER_CONTACT_EMAIL_1_EXT | VARCHAR2 | (50) | For future use | |
HEADER_CONTACT_EMAIL_2_EXT | VARCHAR2 | (50) | For future use | |
HEADER_CONTACT_FAX_1_EXT | VARCHAR2 | (35) | For future use | |
HEADER_CONTACT_FAX_2_EXT | VARCHAR2 | (35) | For future use | |
HEADER_CONTACT_TEL_1_EXT | VARCHAR2 | (50) | For future use | |
HEADER_CONTACT_TEL_2_EXT | VARCHAR2 | (50) | For future use | |
BUCKET_END_DATE | DATE | For future use | ||
BUCKET_START_DATE | DATE | For future use | ||
FLEX_BUCKET_CODE | VARCHAR2 | (30) | For future use | |
CUST_DESCRIPTION_EXT | VARCHAR2 | (35) | For future use | |
SUPPLIER_NAME_EXT | VARCHAR2 | (60) | For future use | |
ONE_TIME_SUPPLIER_FLAG_EXT | VARCHAR2 | (35) | For future use | |
SUPPLIER_ID | NUMBER | For future use | ||
SUPPLIER_CURRENCY_EXT | VARCHAR2 | (35) | For future use | |
SUPPLIER_DESCRIPTION_EXT | VARCHAR2 | (35) | For future use | |
SUPPLIER_TAX_EXEMPT_FLAG_EXT | VARCHAR2 | (35) | For future use | |
SUPPLIER_TAX_ID_EXT | VARCHAR2 | (35) | For future use | |
SUPPLIER_ADDRESS_1_EXT | VARCHAR2 | (35) | For future use | |
SUPPLIER_ADDRESS_2_EXT | VARCHAR2 | (35) | For future use | |
SUPPLIER_ADDRESS_3_EXT | VARCHAR2 | (35) | For future use | |
SUPPLIER_ADDRESS_4_EXT | VARCHAR2 | (35) | For future use | |
SUPPLIER_ADDRESS_5_EXT | VARCHAR2 | (35) | For future use | |
SUPPLIER_ADDRESS_6_EXT | VARCHAR2 | (35) | For future use | |
SUPPLIER_ADDRESS_7_EXT | VARCHAR2 | (35) | For future use | |
SUPPLIER_ADDRESS_8_EXT | VARCHAR2 | (35) | For future use | |
SUPPLIER_ADDRESS_9_EXT | VARCHAR2 | (35) | For future use | |
SUPPLIER_CITY_EXT | VARCHAR2 | (30) | For future use | |
SUPPLIER_COUNTY_EXT | VARCHAR2 | (25) | For future use | |
SUPPLIER_COUNTRY_EXT | VARCHAR2 | (3) | For future use | |
SUPPLIER_FAX_EXT | VARCHAR2 | (35) | For future use | |
SUPPLIER_POSTAL_CD_EXT | VARCHAR2 | (15) | For future use | |
SUPPLIER_REGION_EXT | VARCHAR2 | (35) | For future use | |
SUPPLIER_STATE_EXT | VARCHAR2 | (10) | For future use | |
SUPPLIER_PROVINCE_EXT | VARCHAR2 | (10) | For future use | |
SUPPLIER_TAX_JURISDICTION_EXT | VARCHAR2 | (35) | For future use | |
SUPPLIER_TEL_EXT | VARCHAR2 | (35) | For future use | |
SUPPLIER_URL_EXT | VARCHAR2 | (100) | For future use | |
SUP_HEADER_CONTACT_CODE_1 | VARCHAR2 | (3) | For future use | |
SUP_HEADER_CONTACT_CODE_2 | VARCHAR2 | (3) | For future use | |
SUP_HEADER_CONTACT_VALUE_1 | VARCHAR2 | (80) | For future use | |
SUP_HEADER_CONTACT_VALUE_2 | VARCHAR2 | (80) | For future use | |
SUP_HEADER_CONTACT_EMAIL_1_EXT | VARCHAR2 | (50) | For future use | |
SUP_HEADER_CONTACT_EMAIL_2_EXT | VARCHAR2 | (50) | For future use | |
SUP_HEADER_CONTACT_FAX_1_EXT | VARCHAR2 | (35) | For future use | |
SUP_HEADER_CONTACT_FAX_2_EXT | VARCHAR2 | (35) | For future use | |
SUP_HEADER_CONTACT_TEL_1_EXT | VARCHAR2 | (50) | For future use | |
SUP_HEADER_CONTACT_TEL_2_EXT | VARCHAR2 | (50) | For future use |
Cut, paste (and edit) the following text to query this object:
SELECT HEADER_ID
, CUSTOMER_ID
, SCHEDULE_TYPE
, SCHED_HORIZON_END_DATE
, SCHED_HORIZON_START_DATE
, SCHEDULE_SOURCE
, SCHEDULE_PURPOSE
, SCHEDULE_REFERENCE_NUM
, CUST_ADDRESS_1_EXT
, CUST_ADDRESS_2_EXT
, CUST_ADDRESS_3_EXT
, CUST_ADDRESS_4_EXT
, CUST_CITY_EXT
, CUST_COUNTRY_EXT
, CUST_COUNTY_EXT
, CUSTOMER_EXT
, CUST_NAME_EXT
, CUST_POSTAL_CD_EXT
, CUST_PROVINCE_EXT
, CUST_STATE_EXT
, ECE_PRIMARY_ADDRESS_ID
, ECE_TP_LOCATION_CODE_EXT
, ECE_TP_TRANSLATOR_CODE
, EDI_CONTROL_NUM_1
, EDI_CONTROL_NUM_2
, EDI_CONTROL_NUM_3
, EDI_TEST_INDICATOR
, HEADER_CONTACT_CODE_1
, HEADER_CONTACT_CODE_2
, HEADER_CONTACT_VALUE_1
, HEADER_CONTACT_VALUE_2
, HEADER_NOTE_TEXT
, HEADER_REF_CODE_1
, HEADER_REF_CODE_2
, HEADER_REF_CODE_3
, HEADER_REF_VALUE_1
, HEADER_REF_VALUE_2
, HEADER_REF_VALUE_3
, ORG_ID
, SCHEDULE_TYPE_EXT
, SCHED_GENERATION_DATE
, SCHEDULE_PURPOSE_EXT
, 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
, PROCESS_STATUS
, INTERFACE_HEADER_ID
, CUST_ADDRESS_5_EXT
, CUST_ADDRESS_6_EXT
, CUST_ADDRESS_7_EXT
, CUST_ADDRESS_8_EXT
, CUST_ADDRESS_9_EXT
, ORIGINAL_DOCUMENT_DATE
, RESP_DOCUMENT_DATE
, DOCUMENT_DESCRIPTION
, DOCUMENT_REV_NUM
, RESP_SCHEDULE_ID
, RESP_DOCUMENT_REV_NUM
, ONE_TIME_CUST_FLAG_EXT
, CURRENCY_EXT
, TAX_EXEMPT_FLAG_EXT
, TAX_ID_EXT
, CUST_FAX_EXT
, CUST_REGION_EXT
, CUST_TAX_JURISDICTION_EXT
, CUST_TEL_EXT
, CUST_URL_EXT
, HEADER_CONTACT_EMAIL_1_EXT
, HEADER_CONTACT_EMAIL_2_EXT
, HEADER_CONTACT_FAX_1_EXT
, HEADER_CONTACT_FAX_2_EXT
, HEADER_CONTACT_TEL_1_EXT
, HEADER_CONTACT_TEL_2_EXT
, BUCKET_END_DATE
, BUCKET_START_DATE
, FLEX_BUCKET_CODE
, CUST_DESCRIPTION_EXT
, SUPPLIER_NAME_EXT
, ONE_TIME_SUPPLIER_FLAG_EXT
, SUPPLIER_ID
, SUPPLIER_CURRENCY_EXT
, SUPPLIER_DESCRIPTION_EXT
, SUPPLIER_TAX_EXEMPT_FLAG_EXT
, SUPPLIER_TAX_ID_EXT
, SUPPLIER_ADDRESS_1_EXT
, SUPPLIER_ADDRESS_2_EXT
, SUPPLIER_ADDRESS_3_EXT
, SUPPLIER_ADDRESS_4_EXT
, SUPPLIER_ADDRESS_5_EXT
, SUPPLIER_ADDRESS_6_EXT
, SUPPLIER_ADDRESS_7_EXT
, SUPPLIER_ADDRESS_8_EXT
, SUPPLIER_ADDRESS_9_EXT
, SUPPLIER_CITY_EXT
, SUPPLIER_COUNTY_EXT
, SUPPLIER_COUNTRY_EXT
, SUPPLIER_FAX_EXT
, SUPPLIER_POSTAL_CD_EXT
, SUPPLIER_REGION_EXT
, SUPPLIER_STATE_EXT
, SUPPLIER_PROVINCE_EXT
, SUPPLIER_TAX_JURISDICTION_EXT
, SUPPLIER_TEL_EXT
, SUPPLIER_URL_EXT
, SUP_HEADER_CONTACT_CODE_1
, SUP_HEADER_CONTACT_CODE_2
, SUP_HEADER_CONTACT_VALUE_1
, SUP_HEADER_CONTACT_VALUE_2
, SUP_HEADER_CONTACT_EMAIL_1_EXT
, SUP_HEADER_CONTACT_EMAIL_2_EXT
, SUP_HEADER_CONTACT_FAX_1_EXT
, SUP_HEADER_CONTACT_FAX_2_EXT
, SUP_HEADER_CONTACT_TEL_1_EXT
, SUP_HEADER_CONTACT_TEL_2_EXT
FROM RLM.RLM_SCHEDULE_HEADERS_ALL;
RLM.RLM_SCHEDULE_HEADERS_ALL does not reference any database object
RLM.RLM_SCHEDULE_HEADERS_ALL is referenced by following:
|
|
|