DBA Data[Home] [Help]

APPS.JAI_CMN_ST_FORMS_PKG dependencies on OE_ORDER_HEADERS_ALL

Line 1186: from oe_order_headers_all

1182: p_order_header_id number
1183: )
1184: is
1185: select order_number
1186: from oe_order_headers_all
1187: where header_id = p_order_header_id;
1188:
1189: cursor c_check_duplicate(p_delivery_id Number)
1190: is

Line 1211: oe_order_headers_all oeh

1207: jspl.excise_invoice_no
1208: FROM wsh_new_deliveries wnd ,
1209: wsh_delivery_details wdd ,
1210: JAI_OM_WSH_LINES_ALL jspl ,
1211: oe_order_headers_all oeh
1212: WHERE jspl.delivery_id = wnd.delivery_id
1213: AND wdd.delivery_Detail_id = jspl.delivery_detail_id
1214: AND wdd.source_header_id = oeh.header_id
1215: AND oeh.source_document_type_id = 10

Line 1633: from oe_order_headers_all

1629: p_order_header_id number
1630: )
1631: is
1632: select order_number
1633: from oe_order_headers_all
1634: where header_id = p_order_header_id;
1635:
1636: cursor c_check_duplicate(p_invoice_id Number)
1637: is