DBA Data[Home] [Help]

APPS.JAI_AR_MATCH_TAX_PKG dependencies on OE_ORDER_HEADERS_ALL

Line 4716: FROM OE_ORDER_HEADERS_ALL oh,

4712: Cursor get_rma_flag_cur
4713: IS
4714: SELECT COUNT(customer_trx_line_id)
4715: FROM (SELECT rctl.customer_trx_line_id
4716: FROM OE_ORDER_HEADERS_ALL oh,
4717: OE_ORDER_LINES_ALL ol,
4718: OE_TRANSACTION_TYPES_TL ot,
4719: oe_workflow_assignments owf,
4720: ra_customer_trx_lines_all rctl

Line 4766: FROM OE_ORDER_HEADERS_ALL oh,

4762: WHERE a.tax_id = b.tax_id
4763: AND NVL(b.inclusive_tax_flag, 'N') = 'Y'
4764: AND a.link_to_cust_trx_line_id IN
4765: (SELECT rctl.customer_trx_line_id
4766: FROM OE_ORDER_HEADERS_ALL oh,
4767: OE_ORDER_LINES_ALL ol,
4768: OE_TRANSACTION_TYPES_TL ot,
4769: oe_workflow_assignments owf,
4770: ra_customer_trx_lines_all rctl