Friday 19 April 2013

Item Child Load ctl file

OPTIONS (SKIP=1)
 LOAD DATA
 INFILE *
 APPEND INTO TABLE XXMTZ_INV_SYSTEM_ITEMS_STG
 FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
 TRAILING NULLCOLS
 (
  ORGANIZATION_CODE           "REPLACE(REPLACE(LTRIM(RTRIM(:ORGANIZATION_CODE)),chr(34),NULL),chr(13),NULL)"
 ,TRANSACTION_TYPE            "REPLACE(REPLACE(LTRIM(RTRIM(:TRANSACTION_TYPE)),chr(34),NULL),chr(13),NULL)"
 ,SEGMENT1                    "REPLACE(REPLACE(LTRIM(RTRIM(:SEGMENT1)),chr(34),NULL),chr(13),NULL)"                              
 ,DESCRIPTION                 "REPLACE(REPLACE(LTRIM(RTRIM(:DESCRIPTION)),chr(34),NULL),chr(13),NULL)"
 ,PRIMARY_UOM_CODE            "TRIM(:PRIMARY_UOM_CODE)"
 ,INVENTORY_ITEM_STATUS_CODE  "TRIM(:INVENTORY_ITEM_STATUS_CODE)"
 ,TEMPLATE_NAME               "TRIM(:TEMPLATE_NAME)"
 ,SERIAL_CONTROL              "TRIM(:SERIAL_CONTROL)"
 ,LIST_PRICE                  "TO_NUMBER(REPLACE(REPLACE(LTRIM(RTRIM(:LIST_PRICE)),chr(34),NULL),chr(13),NULL))"
 ,USE_APPROVED_SUPPLIER_FLAG  "REPLACE(REPLACE(LTRIM(RTRIM(:USE_APPROVED_SUPPLIER_FLAG)),chr(34),NULL),chr(13),NULL)"
 ,INSPECTION_REQUIRED_FLAG    "REPLACE(REPLACE(LTRIM(RTRIM(:INSPECTION_REQUIRED_FLAG)),chr(34),NULL),chr(13),NULL)"
 ,PURCHASING_ITEM           "REPLACE(REPLACE(LTRIM(RTRIM(:PURCHASING_ITEM)),chr(34),NULL),chr(13),NULL)"
 ,COST_OF_SALES_ACCOUNT       "TRIM(:COST_OF_SALES_ACCOUNT)"
 ,SALES_ACCOUNT               "TRIM(:SALES_ACCOUNT)"
 ,EXPENSE_ACCOUNT             "TRIM(:EXPENSE_ACCOUNT)"
 ,RECEIVING_ROUTING_ID        "TRIM(:RECEIVING_ROUTING_ID)"
 ,LOT_CONTROL_CODE            "TRIM(:LOT_CONTROL_CODE)"
 ,BUYER_ID                    "TRIM(:BUYER_ID)"
 ,INVENTORY_PLANNING_CODE     "TRIM(:INVENTORY_PLANNING_CODE)"
 ,MAX_MINMAX_QUANTITY         "TRIM(:MAX_MINMAX_QUANTITY)"
 ,MIN_MINMAX_QUANTITY         "TRIM(:MIN_MINMAX_QUANTITY)"
 ,MINIMUM_ORDER_QUANTITY      "TRIM(:MINIMUM_ORDER_QUANTITY)"
 ,MAXIMUM_ORDER_QUANTITY      "TRIM(:MAXIMUM_ORDER_QUANTITY)"
 ,FIXED_LOT_MULTIPLIER        "TRIM(:FIXED_LOT_MULTIPLIER)"
 ,PREPROCESSING_LEAD_TIME     "TRIM(:PREPROCESSING_LEAD_TIME)"
 ,FULL_LEAD_TIME              "TRIM(:FULL_LEAD_TIME)"
 ,POSTPROCESSING_LEAD_TIME    "TRIM(:POSTPROCESSING_LEAD_TIME)"
 ,ATTRIBUTE1                  "TRIM(:ATTRIBUTE1)"
 ,ATTRIBUTE2                  "TRIM(:ATTRIBUTE2)"
 ,ATTRIBUTE3                  "TRIM(:ATTRIBUTE3)"
 ,ATTRIBUTE4                  "TRIM(:ATTRIBUTE4)"
 ,ATTRIBUTE5                  "TRIM(:ATTRIBUTE5)"
 ,ATTRIBUTE6                  "TRIM(:ATTRIBUTE6)"
 ,ATTRIBUTE7                  "TRIM(:ATTRIBUTE7)"
 ,ATTRIBUTE8                  "TRIM(:ATTRIBUTE8)"
 ,ATTRIBUTE9                  "TRIM(:ATTRIBUTE9)"
 ,ATTRIBUTE10                 "TRIM(:ATTRIBUTE10)"
 ,ATTRIBUTE11                 "TRIM(:ATTRIBUTE11)"
 ,ATTRIBUTE12                 "TRIM(:ATTRIBUTE12)"
 ,ATTRIBUTE13                 "TRIM(:ATTRIBUTE13)"
 ,ATTRIBUTE14                 "TRIM(:ATTRIBUTE14)"
 ,ATTRIBUTE15                 "TRIM(:ATTRIBUTE15)"
 ,CREATED_BY                  "FND_GLOBAL.USER_ID" 
 ,CREATION_DATE               "TRUNC (SYSDATE)"
 ,LAST_UPDATED_BY             "FND_GLOBAL.USER_ID"
 ,LAST_UPDATE_DATE            "TRUNC (SYSDATE)"
 ,LAST_UPDATE_LOGIN           "FND_GLOBAL.LOGIN_ID"
 ,REQUEST_ID                  "FND_GLOBAL.CONC_REQUEST_ID"
 ,RECORD_ID                   "XXMTZ_INV_SYSTEM_ITEMS_S.nextval"
 ,RECORD_STATUS                CONSTANT 'N'
 )

No comments:

Post a Comment