382: l_item_name,
383: NULL,
384: l_item_name,
385: msc_x_util.get_lookup_meaning('MSC_X_ORDER_TYPE', REPLENISHMENT),
386: FND_GLOBAL.CONC_REQUEST_ID, -- request_id
387: FND_GLOBAL.CONC_PROGRAM_ID, -- program_id
388: FND_GLOBAL.PROG_APPL_ID, -- program_application_id
389: null, -- program_update_date
390: FND_GLOBAL.USER_ID, -- created_by
383: NULL,
384: l_item_name,
385: msc_x_util.get_lookup_meaning('MSC_X_ORDER_TYPE', REPLENISHMENT),
386: FND_GLOBAL.CONC_REQUEST_ID, -- request_id
387: FND_GLOBAL.CONC_PROGRAM_ID, -- program_id
388: FND_GLOBAL.PROG_APPL_ID, -- program_application_id
389: null, -- program_update_date
390: FND_GLOBAL.USER_ID, -- created_by
391: SYSDATE, -- creation_date
384: l_item_name,
385: msc_x_util.get_lookup_meaning('MSC_X_ORDER_TYPE', REPLENISHMENT),
386: FND_GLOBAL.CONC_REQUEST_ID, -- request_id
387: FND_GLOBAL.CONC_PROGRAM_ID, -- program_id
388: FND_GLOBAL.PROG_APPL_ID, -- program_application_id
389: null, -- program_update_date
390: FND_GLOBAL.USER_ID, -- created_by
391: SYSDATE, -- creation_date
392: FND_GLOBAL.USER_ID, -- last_updated_by
386: FND_GLOBAL.CONC_REQUEST_ID, -- request_id
387: FND_GLOBAL.CONC_PROGRAM_ID, -- program_id
388: FND_GLOBAL.PROG_APPL_ID, -- program_application_id
389: null, -- program_update_date
390: FND_GLOBAL.USER_ID, -- created_by
391: SYSDATE, -- creation_date
392: FND_GLOBAL.USER_ID, -- last_updated_by
393: SYSDATE, -- last_update_date
394: FND_GLOBAL.LOGIN_ID, -- last_update_login
388: FND_GLOBAL.PROG_APPL_ID, -- program_application_id
389: null, -- program_update_date
390: FND_GLOBAL.USER_ID, -- created_by
391: SYSDATE, -- creation_date
392: FND_GLOBAL.USER_ID, -- last_updated_by
393: SYSDATE, -- last_update_date
394: FND_GLOBAL.LOGIN_ID, -- last_update_login
395: l_uom_code,
396: l_order_quantity,
390: FND_GLOBAL.USER_ID, -- created_by
391: SYSDATE, -- creation_date
392: FND_GLOBAL.USER_ID, -- last_updated_by
393: SYSDATE, -- last_update_date
394: FND_GLOBAL.LOGIN_ID, -- last_update_login
395: l_uom_code,
396: l_order_quantity,
397: l_uom_code,
398: l_order_quantity,
476: , supplier_name = l_oem_company_name
477: , supplier_site_name = NULL
478: , quantity_in_process = 0
479: , implemented_quantity = 0
480: , last_updated_by = FND_GLOBAL.USER_ID
481: , last_update_date = SYSDATE
482: , last_update_login = FND_GLOBAL.LOGIN_ID
483: , customer_id = l_cust_id
484: , customer_name = l_customer_name
478: , quantity_in_process = 0
479: , implemented_quantity = 0
480: , last_updated_by = FND_GLOBAL.USER_ID
481: , last_update_date = SYSDATE
482: , last_update_login = FND_GLOBAL.LOGIN_ID
483: , customer_id = l_cust_id
484: , customer_name = l_customer_name
485: , customer_site_id = l_cust_site_id
486: , customer_site_name = l_customer_site_name