Welcome to Oracle ERP

DECLARE    CURSOR dev_header_cur    IS       SELECT *         FROM apps.wsh_delivery_details        WHERE delivery_detail_id IN     ...

CREATE OR REPLACE PROCEDURE ship_confirm (p_delivery_id     IN     NUMBER,                                           p_shipment_date   IN...

CREATE OR REPLACE PROCEDURE create_deliveries (    p_delivery_detail_ids   IN     wsh_util_core.id_tab_type,    x_delivery_id          ...

CREATE OR REPLACE PROCEDURE transact_moveorder (p_delivery_id IN NUMBER) IS    CURSOR c_deli_details    IS       SELECT wdd.source_he...

SELECT 'Unprocessed Shipping Transactions'||'~'||       o.organization_code ||'~'||       to_char(wdd.last_upda...

UPDATE wsh_delivery_details    SET released_status = 'D',        src_requested_quantity = 0,        requested_quantity = 0,    ...

Steps to follow for Backordered lines in OM Shipping 1. Check in Shipping Transaction Form, make sure the order still in “Ready to Rele...

CREATE OR REPLACE PROCEDURE APPS.xx_om_pick_release (x_errbuf OUT VARCHAR2, x_retcode OUT NUMBER ) AS CURSOR cur_delivery_details ...