DBA Data[Home] [Help]

APPS.JAI_AR_RCTA_TRIGGER_PKG dependencies on OE_ORDER_HEADERS_ALL

Line 4014: FROM OE_ORDER_HEADERS_ALL oh,

4010: */
4011: CURSOR check_rma_credit_cur(pn_order_line_id NUMBER)
4012: IS
4013: SELECT count(1)
4014: FROM OE_ORDER_HEADERS_ALL oh,
4015: OE_ORDER_LINES_ALL ol,
4016: OE_TRANSACTION_TYPES_TL ot,
4017: oe_workflow_assignments owf
4018: WHERE oh.header_id = ol.header_id

Line 4135: FROM OE_ORDER_HEADERS_ALL ohc,

4131: -------------------------------------------------------------
4132: CURSOR get_copy_vat_invoice_cur
4133: IS
4134: SELECT jwl.vat_invoice_no
4135: FROM OE_ORDER_HEADERS_ALL ohc,
4136: oe_transaction_types_tl ot,
4137: JAI_OM_WSH_LINES_ALL jwl
4138: WHERE ohc.order_type_id = ot.transaction_type_id
4139: AND ot.LANGUAGE = userenv('LANG')