DBA Data[Home] [Help]

APPS.JAI_AR_IMPORT_SYNC_PKG dependencies on OE_ORDER_HEADERS_ALL

Line 2165: FROM OE_ORDER_HEADERS_ALL oh,

2161: */
2162: CURSOR check_rma_credit_cur(pn_order_line_id NUMBER)
2163: IS
2164: SELECT count(1)
2165: FROM OE_ORDER_HEADERS_ALL oh,
2166: OE_ORDER_LINES_ALL ol,
2167: OE_TRANSACTION_TYPES_TL ot,
2168: oe_workflow_assignments owf
2169: WHERE oh.header_id = ol.header_id

Line 2285: FROM OE_ORDER_HEADERS_ALL ohc,

2281:
2282: CURSOR get_copy_vat_invoice_cur
2283: IS
2284: SELECT jwl.vat_invoice_no
2285: FROM OE_ORDER_HEADERS_ALL ohc,
2286: oe_transaction_types_tl ot,
2287: JAI_OM_WSH_LINES_ALL jwl
2288: WHERE ohc.order_type_id = ot.transaction_type_id
2289: AND ot.LANGUAGE = userenv('LANG')