eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_DELIVERY_DETAILS_PKG dependencies on WSH_DELIVERY_DETAILS_S

Line 182: SELECT wsh_delivery_details_s.nextval

178:
179: /* lpn conv
180: CURSOR C_Del_detail_ID
181: IS
182: SELECT wsh_delivery_details_s.nextval
183: FROM sys.dual;
184:
185: */
186:

Line 704: wsh_delivery_details_s.nextval, --lpn conv

700: consignee_flag --RTV changes
701: ) VALUES
702: (l_delivery_details_info.source_code,
703: l_delivery_details_info.source_header_id,
704: wsh_delivery_details_s.nextval, --lpn conv
705: decode( l_delivery_details_info.container_flag , 'Y', wsh_delivery_details_s.currval, l_delivery_details_info.source_line_id),
706: l_delivery_details_info.customer_id,
707: l_delivery_details_info.sold_to_contact_id,
708: l_delivery_details_info.inventory_item_id,

Line 705: decode( l_delivery_details_info.container_flag , 'Y', wsh_delivery_details_s.currval, l_delivery_details_info.source_line_id),

701: ) VALUES
702: (l_delivery_details_info.source_code,
703: l_delivery_details_info.source_header_id,
704: wsh_delivery_details_s.nextval, --lpn conv
705: decode( l_delivery_details_info.container_flag , 'Y', wsh_delivery_details_s.currval, l_delivery_details_info.source_line_id),
706: l_delivery_details_info.customer_id,
707: l_delivery_details_info.sold_to_contact_id,
708: l_delivery_details_info.inventory_item_id,
709: l_delivery_details_info.item_description,

Line 840: nvl(p_container_info_rec.container_names(i), NVL(l_delivery_details_info.container_name,wsh_delivery_details_s.currval)),

836: l_delivery_details_info.released_status,
837: l_delivery_details_info.container_flag,
838: l_delivery_details_info.container_type_code,
839: decode(l_delivery_details_info.container_flag,'Y',
840: nvl(p_container_info_rec.container_names(i), NVL(l_delivery_details_info.container_name,wsh_delivery_details_s.currval)),
841: l_delivery_details_info.container_name),
842: l_delivery_details_info.fill_percent,
843: l_delivery_details_info.gross_weight,
844: l_delivery_details_info.master_serial_number,

Line 1006: SELECT wsh_delivery_details_s.nextval

1002: l_container_name varchar2(50);
1003:
1004: CURSOR C_Del_detail_ID
1005: IS
1006: SELECT wsh_delivery_details_s.nextval
1007: FROM sys.dual;
1008:
1009: l_row_count NUMBER;
1010: l_temp_id NUMBER;

Line 1787: SELECT wsh_delivery_details_s.nextval

1783: WHERE delivery_detail_id = x_delivery_detail_id;
1784:
1785: CURSOR C_Del_detail_ID
1786: IS
1787: SELECT wsh_delivery_details_s.nextval
1788: FROM sys.dual;
1789:
1790: CURSOR C_Check_Detail_ID
1791: IS SELECT rowid

Line 3354: l_shipped_quantity WSH_DELIVERY_DETAILS.SHIPPED_QUANTITY%TYPE;

3350: -- 6749200 (replenishment project) : end
3351:
3352: l_delivery_id WSH_NEW_DELIVERIES.DELIVERY_ID%TYPE;
3353: l_requested_quantity WSH_DELIVERY_DETAILS.REQUESTED_QUANTITY%TYPE;
3354: l_shipped_quantity WSH_DELIVERY_DETAILS.SHIPPED_QUANTITY%TYPE;
3355: l_delivery_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3356: l_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
3357: l_gc3_is_installed VARCHAR2(1);
3358: -- End of OTM R12