DBA Data[Home] [Help]

APPS.WMS_SHIPPING_TRANSACTION_PUB dependencies on WSH_REPORT_SETS

Line 3733: from wsh_report_sets

3729: when no_data_found then
3730: BEGIN
3731: select report_set_id
3732: into l_report_set_id
3733: from wsh_report_sets
3734: where usage_code = 'SHIP_CONFIRM'
3735: and name = 'Ship Confirm Documents';
3736: EXCEPTION
3737: when no_data_found then

Line 4282: from wsh_report_sets

4278: when no_data_found then
4279: BEGIN
4280: select report_set_id
4281: into l_report_set_id
4282: from wsh_report_sets
4283: where usage_code = 'SHIP_CONFIRM'
4284: and name = 'Ship Confirm Documents';
4285: EXCEPTION
4286: when no_data_found then

Line 6525: from wsh_report_sets

6521: Open x_report_set for
6522: Select report_set_id
6523: , name
6524: , description
6525: from wsh_report_sets
6526: where usage_code = 'SHIP_CONFIRM'
6527: and trunc(nvl(start_date_active, sysdate)) <= trunc(sysdate)
6528: and trunc(nvl(end_date_active, sysdate+1)) > trunc(sysdate)
6529: and name like (p_text);