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'
)
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