DBA Data[Home] [Help]

APPS.JAI_CMN_ST_FORMS_PKG dependencies on OE_ORDER_HEADERS_ALL

Line 1326: from oe_order_headers_all

1322: p_order_header_id number
1323: )
1324: is
1325: select order_number
1326: from oe_order_headers_all
1327: where header_id = p_order_header_id;
1328:
1329: cursor c_check_duplicate(p_delivery_id Number)
1330: is

Line 1351: oe_order_headers_all oeh

1347: jspl.excise_invoice_no
1348: FROM wsh_new_deliveries wnd ,
1349: wsh_delivery_details wdd ,
1350: JAI_OM_WSH_LINES_ALL jspl ,
1351: oe_order_headers_all oeh
1352: WHERE jspl.delivery_id = wnd.delivery_id
1353: AND wdd.delivery_Detail_id = jspl.delivery_detail_id
1354: AND wdd.source_header_id = oeh.header_id
1355: AND oeh.source_document_type_id = 10

Line 1778: from oe_order_headers_all

1774: p_order_header_id number
1775: )
1776: is
1777: select order_number
1778: from oe_order_headers_all
1779: where header_id = p_order_header_id;
1780:
1781: cursor c_check_duplicate(p_invoice_id Number, p_trx_number varchar2) /*Added trx_number parameter for bug # 9113108 */
1782: is