OM: Apply discount on an order line
Hi Team
I am trying to apply Discount precisely Coupon while importing Order using Order Import.
I am using the below script:
INSERT INTO oe_headers_iface_all (order_source_id,
orig_sys_document_ref,
order_number,
org_id,
ordered_date,
order_type,
price_list_id,
customer_id,
sold_to_org_id,
booked_flag,
closed_flag,
created_by,
creation_date,
last_updated_by,
last_update_date)
VALUES (6,
'PP_COUPON2',
8745616,
82,
SYSDATE,
'Standard Sales',
80026,
65819,
65819,
'N',
'N',
-1,
SYSDATE,
-1,
SYSDATE);
----Line----
INSERT INTO oe_lines_iface_all (order_source_id,
orig_sys_document_ref,
orig_sys_line_ref,
org_id,
ordered_quantity,