Script for Inserting Data into Price List Import Interface Tables

INSERT INTO QP_INTERFACE_LIST_HEADERS (

ORIG_SYS_HEADER_REF,

LIST_TYPE_CODE,

NAME,

DESCRIPTION,

CURRENCY_CODE,

ACTIVE_FLAG,

CURRENCY_HEADER_ID,

START_DATE_ACTIVE,

END_DATE_ACTIVE,

ROUNDING_FACTOR,

SOURCE_LANG,

LANGUAGE,

INTERFACE_ACTION_CODE,

PROCESS_FLAG,

PROCESS_STATUS_FLAG

) VALUES

(

'SAMPLE_HEADER',

'PRL',

'SAMPLE_BLK_PL',

'SAMPLE BULK LOADED PRICE LIST',

'USD',

'Y',

3,

SYSDATE,

NULL,

-1,

'US',

'US',

'INSERT',

'Y',

'P'

)

/

/* Insert Price list line details into QP_INTERFACE_LIST_LINES table. */

INSERT INTO QP_INTERFACE_LIST_LINES (

ORIG_SYS_LINE_REF,

ORIG_SYS_HEADER_REF,

LIST_LINE_TYPE_CODE,

START_DATE_ACTIVE,

END_DATE_ACTIVE,

ARITHMETIC_OPERATOR,

OPERAND,

PRIMARY_UOM_FLAG,

PRODUCT_PRECEDENCE,

INTERFACE_ACTION_CODE,

PROCESS_FLAG,

PROCESS_STATUS_FLAG

) VALUES

(

'SAMPLE_LINE',

'SAMPLE_HEADER',

'PLL',

SYSDATE,

NULL,

'UNIT_PRICE',

100,

'Y',

230,

'INSERT',

'Y',

'P'

)

/

/* Insert Product attribute details into QP_INTERFACE_PRICING_ATTRIBS table. */

INSERT INTO QP_INTERFACE_PRICING_ATTRIBS (

ORIG_SYS_PRICING_ATTR_REF,

ORIG_SYS_LINE_REF,

ORIG_SYS_HEADER_REF,

PRODUCT_ATTRIBUTE_CONTEXT,

PRODUCT_ATTR_CODE,

PRODUCT_ATTR_VAL_DISP,

PRODUCT_UOM_CODE,

INTERFACE_ACTION_CODE,

PROCESS_FLAG,

PROCESS_STATUS_FLAG

) VALUES

(

'SAMPLE_PATTR',

'SAMPLE_LINE',

'SAMPLE_HEADER',

'ITEM',

'INVENTORY_ITEM_ID',

'123',

'KG',

'INSERT',

'Y',

'P'

)

/

COMMIT;