APPS.JAI_CMN_RGM_PROCESSING_PKG dependencies on WSH_DELIVERY_DETAILS

Line 3251: wsh_delivery_details wdd ,

3247: */
3248: CURSOR c_check_interface_status (cp_delivery_id NUMBER) IS
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

Line 3286: FROM WSH_DELIVERY_DETAILS wdd

3282: WHERE jrigt.program_id = ln_conc_progam_id
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

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

3374: 'WHERE regime_id = '||p_regime_id ||' '||
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 '||

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

3405: 'AND registration_num = NVL('||lv_p_registration_num_str||',registration_num) '||
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 '||

Line 3760: , WSH_DELIVERY_DETAILS wdd

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
3764: AND wdd.source_header_id = ooha.header_id

Line 3788: , WSH_DELIVERY_DETAILS wdd

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
3792: AND wdd.source_header_id = ooha.header_id