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

TABLE: RLM.RLM_INTERFACE_HEADERS_ALL

Object Details
Object Name: RLM_INTERFACE_HEADERS_ALL
Object Type: TABLE
Owner: RLM
FND Design Data: TableRLM.RLM_INTERFACE_HEADERS_ALL
Subobject Name:
Status: VALID


This table stores the header level details of the Release Management
schedules. It has details pertaining to the specific schedule and customer
level information. EDI Gateway will feed into this table for the demand
transactions of Planning, Shipping and Sequenced Schedules.
Scope: public
Lifecycle: active
Display Name: Release Management Headers Interface
Product: RLM
Category: BUSINESS_ENTITY RLM_SCHEDULE


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
RLM_HEADERS_INTERFACE_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnHEADER_ID
RLM_INTERFACE_HEADERS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSCHEDULE_HEADER_ID
RLM_INTERFACE_HEADERS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnECE_TP_LOCATION_CODE_EXT
RLM_INTERFACE_HEADERS_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCUSTOMER_ID
RLM_INTERFACE_HEADERS_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSCHEDULE_REFERENCE_NUM
RLM_INTERFACE_HEADERS_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSCHED_HORIZON_START_DATE
RLM_INTERFACE_HEADERS_N6 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCUST_NAME_EXT
Columns
Name Datatype Length Mandatory Comments
HEADER_ID NUMBER
Yes Sequence Generated Unique Identifier
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 (30)
Trading Partner designator Cross Reference
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.
CUSTOMER_ID NUMBER

Customer Identifier. FK to RA_CUSTOMERS.
ECE_PRIMARY_ADDRESS_ID NUMBER

Customer Primary Address ID populated by EDI Gateway code conversion of external Trading Partner Location Code. FK to RA_ADDRESSES.
ECE_TP_LOCATION_CODE_EXT VARCHAR2 (35)
For EDI transactions only, external Trading Partner Location Code assigned to the location in the EDI Gateway Common Control Record .
ECE_TP_TRANSLATOR_CODE VARCHAR2 (35)
For EDI transactions only, EDI Gateway Trading Partner Code assigned to the transaction in the EDI Gateway Common Control Record .
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.
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.
SCHEDULE_HEADER_ID NUMBER

Schedule header unique identifier. FK to RLM_SCHEDULE_HEADERS
SCHEDULE_TYPE VARCHAR2 (30)
Schedule Type: Planning, Shipping or Sequenced. Validated against FND_LOOKUPS.LOOKUP_TYPE = RLM_SCHEDULE_TYPE.
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.
SCHED_HORIZON_END_DATE DATE

Schedule horizon end date (to be derived based on demand contained within the schedule if not specified)
SCHED_HORIZON_START_DATE DATE

Schedule horizon start date (to be derived based on demand contained within the schedule if not specified)
SCHEDULE_PURPOSE VARCHAR2 (30)
Schedule purpose code, i.e. Original, Replace, Cancellation, etc. Validated against FND_LOOKUPS.LOOKUP_TYPE =RLM_SCHEDULE_PURPOSE
SCHEDULE_PURPOSE_EXT VARCHAR2 (30)
External value from which SCHEDULE_PURPOSE was derived in EDI Gateway Code Conversion.
SCHEDULE_REFERENCE_NUM VARCHAR2 (35)
Customer assigned schedule reference or release number
SCHEDULE_SOURCE VARCHAR2 (30)
EDI or manual transaction source for this schedule, i.e. 830, 862, 866, DELFOR, MANUAL, etc.
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
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
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
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
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
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
BUCKET_END_DATE DATE

For future use
BUCKET_START_DATE DATE

For future use
FLEX_BUCKET_CODE VARCHAR2 (30)
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
CUST_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 (240)
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 (35)
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
SUPPLIER_COUNTRY_EXT VARCHAR2 (3)
For future use
Query Text

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


SELECT HEADER_ID
,      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
,      CUSTOMER_ID
,      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
,      PROCESS_STATUS
,      SCHEDULE_HEADER_ID
,      SCHEDULE_TYPE
,      SCHEDULE_TYPE_EXT
,      SCHED_GENERATION_DATE
,      SCHED_HORIZON_END_DATE
,      SCHED_HORIZON_START_DATE
,      SCHEDULE_PURPOSE
,      SCHEDULE_PURPOSE_EXT
,      SCHEDULE_REFERENCE_NUM
,      SCHEDULE_SOURCE
,      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
,      CUST_ADDRESS_5_EXT
,      CUST_ADDRESS_6_EXT
,      CUST_ADDRESS_7_EXT
,      CUST_ADDRESS_8_EXT
,      CUST_ADDRESS_9_EXT
,      ONE_TIME_CUST_FLAG_EXT
,      CURRENCY_EXT
,      TAX_EXEMPT_FLAG_EXT
,      TAX_ID_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
,      CUST_FAX_EXT
,      CUST_REGION_EXT
,      CUST_TAX_JURISDICTION_EXT
,      CUST_TEL_EXT
,      CUST_URL_EXT
,      ORIGINAL_DOCUMENT_DATE
,      RESP_DOCUMENT_DATE
,      DOCUMENT_DESCRIPTION
,      DOCUMENT_REV_NUM
,      RESP_SCHEDULE_ID
,      RESP_DOCUMENT_REV_NUM
,      BUCKET_END_DATE
,      BUCKET_START_DATE
,      FLEX_BUCKET_CODE
,      SUPPLIER_NAME_EXT
,      ONE_TIME_SUPPLIER_FLAG_EXT
,      SUPPLIER_ID
,      SUPPLIER_CURRENCY_EXT
,      SUPPLIER_DESCRIPTION_EXT
,      CUST_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_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
,      SUPPLIER_COUNTRY_EXT
FROM RLM.RLM_INTERFACE_HEADERS_ALL;

Dependencies

[top of page]

RLM.RLM_INTERFACE_HEADERS_ALL does not reference any database object

RLM.RLM_INTERFACE_HEADERS_ALL is referenced by following:

SchemaAPPS
SynonymRLM_INTERFACE_HEADERS
SynonymRLM_INTERFACE_HEADERS_ALL