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 OE_ORDER_HEADERS_ALL

Line 3031: p_order_number_from OE_ORDER_HEADERS_ALL.ORDER_NUMBER%TYPE,

3027: p_registration_num JAI_RGM_TRX_RECORDS.REGIME_PRIMARY_REGNO%TYPE,
3028: p_organization_id JAI_OM_WSH_LINES_ALL.ORGANIZATION_ID%TYPE,
3029: p_location_id JAI_OM_WSH_LINES_ALL.LOCATION_ID%TYPE,
3030: -- added by Allen Yang for bug 9485355 (12.1.3 non-shippable Enhancement), begin
3031: p_order_number_from OE_ORDER_HEADERS_ALL.ORDER_NUMBER%TYPE,
3032: p_order_number_to OE_ORDER_HEADERS_ALL.ORDER_NUMBER%TYPE,
3033: -- added by Allen Yang for bug 9485355 (12.1.3 non-shippable Enhancement), end
3034: p_delivery_id_from JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE,
3035: p_delivery_id_to JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE,

Line 3032: p_order_number_to OE_ORDER_HEADERS_ALL.ORDER_NUMBER%TYPE,

3028: p_organization_id JAI_OM_WSH_LINES_ALL.ORGANIZATION_ID%TYPE,
3029: p_location_id JAI_OM_WSH_LINES_ALL.LOCATION_ID%TYPE,
3030: -- added by Allen Yang for bug 9485355 (12.1.3 non-shippable Enhancement), begin
3031: p_order_number_from OE_ORDER_HEADERS_ALL.ORDER_NUMBER%TYPE,
3032: p_order_number_to OE_ORDER_HEADERS_ALL.ORDER_NUMBER%TYPE,
3033: -- added by Allen Yang for bug 9485355 (12.1.3 non-shippable Enhancement), end
3034: p_delivery_id_from JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE,
3035: p_delivery_id_to JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE,
3036: pv_delivery_date_from VARCHAR2, --DATE, Harshita for Bug 4918870

Line 3288: ,OE_ORDER_HEADERS_ALL ooha

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
3292: AND wda.delivery_id = jrigt.delivery_id)

Line 3380: ',OE_ORDER_HEADERS_ALL ooha '||

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

Line 3411: ',OE_ORDER_HEADERS_ALL ooha '||

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

Line 3761: , OE_ORDER_HEADERS_ALL ooha

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
3765: AND ooha.order_number BETWEEN

Line 3789: , OE_ORDER_HEADERS_ALL ooha

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
3793: AND ooha.order_number BETWEEN