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_ASSIGNMENTS

Line 164: wsh_delivery_assignments wda

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
167: wda.Delivery_Id = wnd.Delivery_Id AND
168: wnd.Delivery_Id = cp_delivery_id AND

Line 250: ',WSH_DELIVERY_ASSIGNMENTS wda '||

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 '||
254: 'NVL('||NVL(TO_CHAR(p_order_number_to), 'NULL')||',order_number) '||

Line 276: ',WSH_DELIVERY_ASSIGNMENTS wda '||

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 '||
280: 'NVL('||NVL(TO_CHAR(p_order_number_to), 'NULL')||',order_number) '||

Line 502: FROM WSH_DELIVERY_ASSIGNMENTS wda

498: AND gst_inv_gen_status <> 'C'
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

Line 531: FROM WSH_DELIVERY_ASSIGNMENTS wda

527: AND gst_inv_gen_status <> 'C'
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