APPS.JAI_CMN_GST_INV_GEN_PKG dependencies on OE_ORDER_HEADERS_ALL

Line 76: p_order_number_from OE_ORDER_HEADERS_ALL.ORDER_NUMBER%TYPE,

72: retcode OUT NOCOPY VARCHAR2,
73: errbuf OUT NOCOPY VARCHAR2,
74: p_organization_id JAI_OM_WSH_LINES_ALL.ORGANIZATION_ID%TYPE,
75: p_location_id JAI_OM_WSH_LINES_ALL.LOCATION_ID%TYPE,
76: p_order_number_from OE_ORDER_HEADERS_ALL.ORDER_NUMBER%TYPE,
77: p_order_number_to OE_ORDER_HEADERS_ALL.ORDER_NUMBER%TYPE,
78: p_delivery_id_from JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE,
79: p_delivery_id_to JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE,
80: pv_delivery_date_from VARCHAR2,

Line 77: p_order_number_to OE_ORDER_HEADERS_ALL.ORDER_NUMBER%TYPE,

73: errbuf OUT NOCOPY VARCHAR2,
74: p_organization_id JAI_OM_WSH_LINES_ALL.ORGANIZATION_ID%TYPE,
75: p_location_id JAI_OM_WSH_LINES_ALL.LOCATION_ID%TYPE,
76: p_order_number_from OE_ORDER_HEADERS_ALL.ORDER_NUMBER%TYPE,
77: p_order_number_to OE_ORDER_HEADERS_ALL.ORDER_NUMBER%TYPE,
78: p_delivery_id_from JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE,
79: p_delivery_id_to JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE,
80: pv_delivery_date_from VARCHAR2,
81: pv_delivery_date_to VARCHAR2,

Line 251: ',OE_ORDER_HEADERS_ALL ooha '||

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

Line 277: ',OE_ORDER_HEADERS_ALL ooha '||

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

Line 504: , OE_ORDER_HEADERS_ALL ooha

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

Line 533: , OE_ORDER_HEADERS_ALL ooha

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