How to remove HOLD based on Customer Criteria.
Hi All
I have imported an Order in EBS using order import program and also applied using Hold on the order using criteria based on Customer. I used the below script:
INSERT INTO oe_headers_iface_all (order_source_id,
orig_sys_document_ref,
creation_date,
created_by,
last_update_date,
last_updated_by,
operation_code,
sold_to_org_id,
order_type,
booked_flag)
VALUES (6,
'TESTING1',
SYSDATE,
-1,
SYSDATE,
-1,
'INSERT',
3046,
'Standard Sales',
'');
INSERT INTO oe_actions_iface_all (order_source_id,
orig_sys_document_ref,
org_id,
operation_code,
hold_id,
hold_type_code,
hold_type_id,