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_RGM_PROCESSING_PKG dependencies on WSH_DELIVERY_ASSIGNMENTS

Line 3253: wsh_delivery_assignments wda

3249: SELECT 1
3250: FROM
3251: wsh_delivery_details wdd ,
3252: wsh_new_deliveries wnd ,
3253: wsh_delivery_assignments wda
3254: WHERE
3255: wdd.delivery_detail_id = wda.delivery_detail_id AND
3256: wda.Delivery_Id = wnd.Delivery_Id AND
3257: wnd.Delivery_Id = cp_delivery_id AND

Line 3287: ,WSH_DELIVERY_ASSIGNMENTS wda

3283: AND jrigt.delivery_id = jowla.delivery_id
3284: AND jowla.excise_invoice_no IS NOT NULL
3285: AND EXISTS (SELECT 1
3286: FROM WSH_DELIVERY_DETAILS wdd
3287: ,WSH_DELIVERY_ASSIGNMENTS wda
3288: ,OE_ORDER_HEADERS_ALL ooha
3289: WHERE ooha.order_number = cp_order_number
3290: AND ooha.header_id = wdd.source_header_id
3291: AND wda.delivery_detail_id = wdd.delivery_detail_id

Line 3379: ',WSH_DELIVERY_ASSIGNMENTS wda '||

3375: 'AND registration_num = NVL('||lv_p_registration_num_str||',registration_num) '||
3376: 'AND (delivery_id BETWEEN NVL('||NVL(TO_CHAR(p_delivery_id_from), 'NULL')||',delivery_id) AND '||
3377: 'NVL('||NVL(TO_CHAR(p_delivery_id_to), 'NULL')||',delivery_id)) '||
3378: 'AND EXISTS (SELECT 1 FROM WSH_DELIVERY_DETAILS wdd '||
3379: ',WSH_DELIVERY_ASSIGNMENTS wda '||
3380: ',OE_ORDER_HEADERS_ALL ooha '||
3381: 'WHERE ooha.order_number BETWEEN '||
3382: 'NVL('||NVL(TO_CHAR(p_order_number_from), 'NULL')||',order_number) AND '||
3383: 'NVL('||NVL(TO_CHAR(p_order_number_to), 'NULL')||',order_number) '||

Line 3410: ',WSH_DELIVERY_ASSIGNMENTS wda '||

3406: 'AND (delivery_id IS NULL OR (delivery_id BETWEEN '||
3407: 'NVL('||NVL(TO_CHAR(p_delivery_id_from), 'NULL')||',delivery_id) AND '||
3408: 'NVL('||NVL(TO_CHAR(p_delivery_id_to), 'NULL')||',delivery_id) '||
3409: 'AND EXISTS (SELECT 1 FROM WSH_DELIVERY_DETAILS wdd '||
3410: ',WSH_DELIVERY_ASSIGNMENTS wda '||
3411: ',OE_ORDER_HEADERS_ALL ooha '||
3412: 'WHERE ooha.order_number BETWEEN '||
3413: 'NVL('||NVL(TO_CHAR(p_order_number_from), 'NULL')||',order_number) AND '||
3414: 'NVL('||NVL(TO_CHAR(p_order_number_to), 'NULL')||',order_number) '||

Line 3759: FROM WSH_DELIVERY_ASSIGNMENTS wda

3755: AND vat_inv_gen_status <> 'C'
3756: AND delivery_id BETWEEN NVL(P_DELIVERY_ID_FROM,delivery_id)
3757: AND NVL(P_DELIVERY_ID_TO,delivery_id)
3758: AND EXISTS (SELECT 1
3759: FROM WSH_DELIVERY_ASSIGNMENTS wda
3760: , WSH_DELIVERY_DETAILS wdd
3761: , OE_ORDER_HEADERS_ALL ooha
3762: WHERE wda.delivery_id = jrigt.delivery_id
3763: AND wda.delivery_detail_id = wdd.delivery_detail_id

Line 3787: FROM WSH_DELIVERY_ASSIGNMENTS wda

3783: AND vat_inv_gen_status <> 'C'
3784: AND delivery_id BETWEEN NVL(P_DELIVERY_ID_FROM,delivery_id)
3785: AND NVL(P_DELIVERY_ID_TO,delivery_id)
3786: AND EXISTS (SELECT 1
3787: FROM WSH_DELIVERY_ASSIGNMENTS wda
3788: , WSH_DELIVERY_DETAILS wdd
3789: , OE_ORDER_HEADERS_ALL ooha
3790: WHERE wda.delivery_id = jrigt.delivery_id
3791: AND wda.delivery_detail_id = wdd.delivery_detail_id