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.JAI_CMN_GST_INV_GEN_PKG dependencies on WSH_DELIVERY_DETAILS

Line 162: wsh_delivery_details wdd ,

158: */
159: CURSOR c_check_interface_status (cp_delivery_id NUMBER) IS
160: SELECT 1
161: FROM
162: wsh_delivery_details wdd ,
163: wsh_new_deliveries wnd ,
164: wsh_delivery_assignments wda
165: WHERE
166: wdd.delivery_detail_id = wda.delivery_detail_id AND

Line 249: 'AND EXISTS (SELECT 1 FROM WSH_DELIVERY_DETAILS wdd '||

245: 'order_line_id, order_number ' ||
246: 'FROM JAI_RGM_GST_INVOICE_GEN_T jrigt ' ||
247: 'WHERE (delivery_id BETWEEN NVL('||NVL(TO_CHAR(p_delivery_id_from), 'NULL')||',delivery_id) AND '||
248: 'NVL('||NVL(TO_CHAR(p_delivery_id_to), 'NULL')||',delivery_id)) '||
249: 'AND EXISTS (SELECT 1 FROM WSH_DELIVERY_DETAILS wdd '||
250: ',WSH_DELIVERY_ASSIGNMENTS wda '||
251: ',OE_ORDER_HEADERS_ALL ooha '||
252: 'WHERE ooha.order_number BETWEEN '||
253: 'NVL('||NVL(TO_CHAR(p_order_number_from), 'NULL')||',order_number) AND '||

Line 275: 'AND EXISTS (SELECT 1 FROM WSH_DELIVERY_DETAILS wdd '||

271: 'FROM JAI_RGM_GST_INVOICE_GEN_T jrigt ' ||
272: 'WHERE (delivery_id IS NULL OR (delivery_id BETWEEN '||
273: 'NVL('||NVL(TO_CHAR(p_delivery_id_from), 'NULL')||',delivery_id) AND '||
274: 'NVL('||NVL(TO_CHAR(p_delivery_id_to), 'NULL')||',delivery_id) '||
275: 'AND EXISTS (SELECT 1 FROM WSH_DELIVERY_DETAILS wdd '||
276: ',WSH_DELIVERY_ASSIGNMENTS wda '||
277: ',OE_ORDER_HEADERS_ALL ooha '||
278: 'WHERE ooha.order_number BETWEEN '||
279: 'NVL('||NVL(TO_CHAR(p_order_number_from), 'NULL')||',order_number) AND '||

Line 503: , WSH_DELIVERY_DETAILS wdd

499: AND delivery_id BETWEEN NVL(P_DELIVERY_ID_FROM,delivery_id)
500: AND NVL(P_DELIVERY_ID_TO,delivery_id)
501: AND EXISTS (SELECT 1
502: FROM WSH_DELIVERY_ASSIGNMENTS wda
503: , WSH_DELIVERY_DETAILS wdd
504: , OE_ORDER_HEADERS_ALL ooha
505: WHERE wda.delivery_id = jrigt.delivery_id
506: AND wda.delivery_detail_id = wdd.delivery_detail_id
507: AND wdd.source_header_id = ooha.header_id

Line 532: , WSH_DELIVERY_DETAILS wdd

528: AND delivery_id BETWEEN NVL(P_DELIVERY_ID_FROM,delivery_id)
529: AND NVL(P_DELIVERY_ID_TO,delivery_id)
530: AND EXISTS (SELECT 1
531: FROM WSH_DELIVERY_ASSIGNMENTS wda
532: , WSH_DELIVERY_DETAILS wdd
533: , OE_ORDER_HEADERS_ALL ooha
534: WHERE wda.delivery_id = jrigt.delivery_id
535: AND wda.delivery_detail_id = wdd.delivery_detail_id
536: AND wdd.source_header_id = ooha.header_id