APPS.JAI_AR_MATCH_TAX_PKG dependencies on OE_ORDER_LINES_ALL

Line 279: oe_order_lines_all

275: OR order_line_id IN
276: ( SELECT
277: line_id
278: FROM
279: oe_order_lines_all
280: WHERE header_id IN
281: ( SELECT
282: header_id
283: FROM

Line 284: oe_order_lines_all

280: WHERE header_id IN
281: ( SELECT
282: header_id
283: FROM
284: oe_order_lines_all
285: WHERE line_id = p_order_line_id
286: )
287: AND item_type_code = 'CONFIG'
288: )

Line 309: oe_order_lines_all

305: OR order_line_id IN
306: ( SELECT
307: line_id
308: FROM
309: oe_order_lines_all
310: WHERE header_id IN
311: ( SELECT
312: header_id
313: FROM

Line 314: oe_order_lines_all

310: WHERE header_id IN
311: ( SELECT
312: header_id
313: FROM
314: oe_order_lines_all
315: WHERE line_id = p_order_line_id
316: )
317: AND item_type_code = 'CONFIG'
318: )

Line 3378: From oe_order_lines_all

3374: and line_type = p_line_type;
3375:
3376: Cursor Ref_type_cur(p_line_id IN Number) is
3377: Select context,reference_line_id
3378: From oe_order_lines_all
3379: Where line_id = p_line_id;
3380:
3381: v_upd_created_from varchar2(15);
3382: v_rma_check Number;

Line 4717: OE_ORDER_LINES_ALL ol,

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
4721: WHERE oh.header_id = ol.header_id

Line 4767: OE_ORDER_LINES_ALL ol,

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
4771: WHERE oh.header_id = ol.header_id