APPS.JAI_JAR_TL_TRIGGER_PKG dependencies on OE_ORDER_HEADERS_ALL

Line 347: FROM OE_ORDER_HEADERS_ALL oh,

343: CURSOR check_rma_credit_cur(-- pn_order_number NUMBER /*Commented order number parameter by mmurtuza for bug 14846750*/
344: pn_order_line_id NUMBER)
345: IS
346: SELECT count(1)
347: FROM OE_ORDER_HEADERS_ALL oh,
348: OE_ORDER_LINES_ALL ol,
349: OE_TRANSACTION_TYPES_TL ot,
350: oe_workflow_assignments owf
351: WHERE oh.header_id = ol.header_id

Line 456: Also , a join between oe_order_headers_all and oe_transaction_types_tl has been added.

452:
453: If the flag value of ORDER_PRICE_EXCISE_INCLUSIVE becomes 'Y' then the excise tax will go as zero
454: else , the normal excise value will go to the base apps.
455:
456: Also , a join between oe_order_headers_all and oe_transaction_types_tl has been added.
457: Without this join, if the same sales order number is associated to multiple order types,
458: there is scope for the wrong order number to be chosen and comparison done on that basis.
459:
460: With this join condition, the value in the ra_customer_trx_all.interface_header_attribute2 is