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 683: wsh_delivery_details_s.nextval, --lpn conv

679: release_revision_number
680: ) VALUES
681: (l_delivery_details_info.source_code,
682: l_delivery_details_info.source_header_id,
683: wsh_delivery_details_s.nextval, --lpn conv
684: decode( l_delivery_details_info.container_flag , 'Y', wsh_delivery_details_s.currval, l_delivery_details_info.source_line_id),
685: l_delivery_details_info.customer_id,
686: l_delivery_details_info.sold_to_contact_id,
687: l_delivery_details_info.inventory_item_id,

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

680: ) VALUES
681: (l_delivery_details_info.source_code,
682: l_delivery_details_info.source_header_id,
683: wsh_delivery_details_s.nextval, --lpn conv
684: decode( l_delivery_details_info.container_flag , 'Y', wsh_delivery_details_s.currval, l_delivery_details_info.source_line_id),
685: l_delivery_details_info.customer_id,
686: l_delivery_details_info.sold_to_contact_id,
687: l_delivery_details_info.inventory_item_id,
688: l_delivery_details_info.item_description,

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

813: l_delivery_details_info.released_status,
814: l_delivery_details_info.container_flag,
815: l_delivery_details_info.container_type_code,
816: decode(l_delivery_details_info.container_flag,'Y',
817: nvl(p_container_info_rec.container_names(i), NVL(l_delivery_details_info.container_name,wsh_delivery_details_s.currval)),
818: l_delivery_details_info.container_name),
819: l_delivery_details_info.fill_percent,
820: l_delivery_details_info.gross_weight,
821: l_delivery_details_info.master_serial_number,

Line 972: SELECT wsh_delivery_details_s.nextval

968: l_container_name varchar2(50);
969:
970: CURSOR C_Del_detail_ID
971: IS
972: SELECT wsh_delivery_details_s.nextval
973: FROM sys.dual;
974:
975: l_row_count NUMBER;
976: l_temp_id NUMBER;

Line 1650: SELECT wsh_delivery_details_s.nextval

1646: WHERE delivery_detail_id = x_delivery_detail_id;
1647:
1648: CURSOR C_Del_detail_ID
1649: IS
1650: SELECT wsh_delivery_details_s.nextval
1651: FROM sys.dual;
1652:
1653: CURSOR C_Check_Detail_ID
1654: IS SELECT rowid

Line 3219: l_shipped_quantity WSH_DELIVERY_DETAILS.SHIPPED_QUANTITY%TYPE;

3215: -- 6749200 (replenishment project) : end
3216:
3217: l_delivery_id WSH_NEW_DELIVERIES.DELIVERY_ID%TYPE;
3218: l_requested_quantity WSH_DELIVERY_DETAILS.REQUESTED_QUANTITY%TYPE;
3219: l_shipped_quantity WSH_DELIVERY_DETAILS.SHIPPED_QUANTITY%TYPE;
3220: l_delivery_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3221: l_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
3222: l_gc3_is_installed VARCHAR2(1);
3223: -- End of OTM R12