Friday 19 April 2013

ITEM_MASTER_LOAD

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)"
 ,PROCESS_FLAG                "TRIM(:PROCESS_FLAG)"
 ,UNIT_HEIGHT                 "TRIM(:UNIT_HEIGHT)"
 ,UNIT_WIDTH                  "TRIM(:UNIT_WIDTH)"
 ,UNIT_LENGTH                 "TRIM(:UNIT_LENGTH)"
 ,DIMENSION_UOM_CODE          "TRIM(:DIMENSION_UOM_CODE)" 
 ,UNIT_WEIGHT                 "TRIM(:UNIT_WEIGHT)"
 ,WEIGHT_UOM_CODE             "TRIM(:WEIGHT_UOM_CODE)"
 ,LONG_DESCRIPTION          "REPLACE(REPLACE(LTRIM(RTRIM(:LONG_DESCRIPTION)),chr(34),NULL),chr(13),NULL)"
 --,ATTRIBUTE1                "TRIM(:ATTRIBUTE1)"
 ,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