-- File Name : XXARJ_CREATE_ELEMENT_ENTRY.ctl
-- File Type : SQL*Loader Control file.
-- RICEW Object id :
-- Description : This SQL*Loader file is used to load data
-- from flat file to the staging table XXARJ_CREATE_ELEMENT_ENTRY
-- Maintenance History:
LOAD DATA
INFILE '/genhor12app/hc12u/uat/apps/apps_st/appl/XXARJ/12.0.0/data/XXARJ_CREATE_ELEMENT_ENTRY.csv'
APPEND
INTO TABLE XXARJ_CREATE_ELEMENT_ENTRY
TRUNCATE
FIELDS TERMINATED BY "," optionally enclosed by '"'
TRAILING NULLCOLS
( "ELEMENT_NAME" ,
"BATCH_NAME" ,
"ENTRY_TYPE" ,
"CREATOR_TYPE",
"EFFECTIVE_START_DATE" ,
"BUSINESS_GROUP_ID" ,
"EMPLOYEE_NUMBER" ,
"NEW_EMPLOYEE_NUMBER" ,
"INPUT_VALUE_1" ,
"ENTRY_VALUE_1" ,
"INPUT_VALUE_2" ,
"ENTRY_VALUE_2" ,
"INPUT_VALUE_3" ,
"ENTRY_VALUE_3" ,
"INPUT_VALUE_4" ,
"ENTRY_VALUE_4" ,
"INPUT_VALUE_5" ,
"ENTRY_VALUE_5" ,
"INPUT_VALUE_6" ,
"ENTRY_VALUE_6" ,
"INPUT_VALUE_7" ,
"ENTRY_VALUE_7" ,
"INPUT_VALUE_8" ,
"ENTRY_VALUE_8" ,
"INPUT_VALUE_9" ,
"ENTRY_VALUE_9" ,
"INPUT_VALUE_10" ,
"ENTRY_VALUE_10" ,
"INPUT_VALUE_11" ,
"ENTRY_VALUE_11" ,
"INPUT_VALUE_12" ,
"ENTRY_VALUE_12" ,
"INPUT_VALUE_13" ,
"ENTRY_VALUE_13" ,
"INPUT_VALUE_14" ,
"ENTRY_VALUE_14" ,
"INPUT_VALUE_15" ,
"ENTRY_VALUE_15" ,
"PROCESS_FLAG" CONSTANT 'N',
"ERROR_MESSAGE" ,
"ELEMENT_ENTRY_ID" ,
"OBJECT_VERSION_NUMBER",
"CREATION_DATE" SYSDATE,
"CREATED_BY" "FND_GLOBAL.USER_ID",
"LAST_UPDATE_DATE" SYSDATE,
"LAST_UPDATED_BY" "FND_GLOBAL.USER_ID" ,
"LAST_UPDATE_LOGIN" "FND_GLOBAL.LOGIN_ID"
)
-- File Type : SQL*Loader Control file.
-- RICEW Object id :
-- Description : This SQL*Loader file is used to load data
-- from flat file to the staging table XXARJ_CREATE_ELEMENT_ENTRY
-- Maintenance History:
LOAD DATA
INFILE '/genhor12app/hc12u/uat/apps/apps_st/appl/XXARJ/12.0.0/data/XXARJ_CREATE_ELEMENT_ENTRY.csv'
APPEND
INTO TABLE XXARJ_CREATE_ELEMENT_ENTRY
TRUNCATE
FIELDS TERMINATED BY "," optionally enclosed by '"'
TRAILING NULLCOLS
( "ELEMENT_NAME" ,
"BATCH_NAME" ,
"ENTRY_TYPE" ,
"CREATOR_TYPE",
"EFFECTIVE_START_DATE" ,
"BUSINESS_GROUP_ID" ,
"EMPLOYEE_NUMBER" ,
"NEW_EMPLOYEE_NUMBER" ,
"INPUT_VALUE_1" ,
"ENTRY_VALUE_1" ,
"INPUT_VALUE_2" ,
"ENTRY_VALUE_2" ,
"INPUT_VALUE_3" ,
"ENTRY_VALUE_3" ,
"INPUT_VALUE_4" ,
"ENTRY_VALUE_4" ,
"INPUT_VALUE_5" ,
"ENTRY_VALUE_5" ,
"INPUT_VALUE_6" ,
"ENTRY_VALUE_6" ,
"INPUT_VALUE_7" ,
"ENTRY_VALUE_7" ,
"INPUT_VALUE_8" ,
"ENTRY_VALUE_8" ,
"INPUT_VALUE_9" ,
"ENTRY_VALUE_9" ,
"INPUT_VALUE_10" ,
"ENTRY_VALUE_10" ,
"INPUT_VALUE_11" ,
"ENTRY_VALUE_11" ,
"INPUT_VALUE_12" ,
"ENTRY_VALUE_12" ,
"INPUT_VALUE_13" ,
"ENTRY_VALUE_13" ,
"INPUT_VALUE_14" ,
"ENTRY_VALUE_14" ,
"INPUT_VALUE_15" ,
"ENTRY_VALUE_15" ,
"PROCESS_FLAG" CONSTANT 'N',
"ERROR_MESSAGE" ,
"ELEMENT_ENTRY_ID" ,
"OBJECT_VERSION_NUMBER",
"CREATION_DATE" SYSDATE,
"CREATED_BY" "FND_GLOBAL.USER_ID",
"LAST_UPDATE_DATE" SYSDATE,
"LAST_UPDATED_BY" "FND_GLOBAL.USER_ID" ,
"LAST_UPDATE_LOGIN" "FND_GLOBAL.LOGIN_ID"
)
No comments:
Post a Comment