DBA Data[Home] [Help]

APPS.WMS_SHIPPING_TRANSACTION_PUB dependencies on WSH_REPORT_SETS

Line 3653: from wsh_report_sets

3649: when no_data_found then
3650: BEGIN
3651: select report_set_id
3652: into l_report_set_id
3653: from wsh_report_sets
3654: where usage_code = 'SHIP_CONFIRM'
3655: and name = 'Ship Confirm Documents';
3656: EXCEPTION
3657: when no_data_found then

Line 4122: from wsh_report_sets

4118: when no_data_found then
4119: BEGIN
4120: select report_set_id
4121: into l_report_set_id
4122: from wsh_report_sets
4123: where usage_code = 'SHIP_CONFIRM'
4124: and name = 'Ship Confirm Documents';
4125: EXCEPTION
4126: when no_data_found then

Line 6278: from wsh_report_sets

6274: Open x_report_set for
6275: Select report_set_id
6276: , name
6277: , description
6278: from wsh_report_sets
6279: where usage_code = 'SHIP_CONFIRM'
6280: and trunc(nvl(start_date_active, sysdate)) <= trunc(sysdate)
6281: and trunc(nvl(end_date_active, sysdate+1)) > trunc(sysdate)
6282: and name like (p_text);