eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_MISC_UTIL_WEB dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 342: ra_customer_trx_lines_all ral,

338: and rel.jtot_object1_code = 'OKX_ORDERLINE') uniqueOrderLineSelect,
339:
340: oe_order_lines_all oel,
341: oe_order_headers_all oe,
342: ra_customer_trx_lines_all ral,
343: ra_customer_trx_all ra,
344: ra_customer_trx_lines_all ratax
345: where
346: uniqueOrderLineSelect.object1_id1 = oel.line_id

Line 344: ra_customer_trx_lines_all ratax

340: oe_order_lines_all oel,
341: oe_order_headers_all oe,
342: ra_customer_trx_lines_all ral,
343: ra_customer_trx_all ra,
344: ra_customer_trx_lines_all ratax
345: where
346: uniqueOrderLineSelect.object1_id1 = oel.line_id
347: and oel.header_id = oe.header_id
348: and to_char (oe.order_number) = ral.sales_order

Line 390: ra_customer_trx_lines_all ral,

386: okc_k_lines_b subline,
387: okc_k_rel_objs rel,
388: oe_order_lines_all oel,
389: oe_order_headers_all oe,
390: ra_customer_trx_lines_all ral,
391: ra_customer_trx_all ra,
392: ra_customer_trx_lines_all ratax
393: where subline.id = l_line_id
394: and subline.lse_id in (9,18,25)

Line 392: ra_customer_trx_lines_all ratax

388: oe_order_lines_all oel,
389: oe_order_headers_all oe,
390: ra_customer_trx_lines_all ral,
391: ra_customer_trx_all ra,
392: ra_customer_trx_lines_all ratax
393: where subline.id = l_line_id
394: and subline.lse_id in (9,18,25)
395: and subline.id = rel.cle_id
396: and rel.jtot_object1_code = 'OKX_ORDERLINE'

Line 524: ra_customer_trx_lines_all ral

520: and rel.jtot_object1_code = 'OKX_ORDERLINE') uniqueOrderLineSelect,
521:
522: oe_order_lines_all oel,
523: oe_order_headers_all oe,
524: ra_customer_trx_lines_all ral
525: where
526: uniqueOrderLineSelect.object1_id1 = oel.line_id
527: and oel.header_id = oe.header_id
528: and to_char (oe.order_number) = ral.sales_order

Line 577: ra_customer_trx_lines_all ral

573: (
574: SELECT
575: NVL(SUM(ral.extended_amount), 0) BILLED_AMOUNT
576: FROM
577: ra_customer_trx_lines_all ral
578: ,oks_bill_cont_lines bcl
579: ,oe_order_headers_all oe
580: ,oe_order_lines_all oel
581: ,okc_k_rel_objs rel

Line 718: RA_CUSTOMER_TRX_LINES_ALL RAL

714: AND SUBLINE.ID = REL.CLE_ID
715: AND REL.JTOT_OBJECT1_CODE = 'OKX_ORDERLINE') UNIQUEORDERLINESELECT,
716: OE_ORDER_LINES_ALL OEL,
717: OE_ORDER_HEADERS_ALL OE,
718: RA_CUSTOMER_TRX_LINES_ALL RAL
719: WHERE
720: UNIQUEORDERLINESELECT.OBJECT1_ID1 = OEL.LINE_ID
721: AND OEL.HEADER_ID = OE.HEADER_ID
722: AND TO_CHAR (OE.ORDER_NUMBER) = RAL.SALES_ORDER

Line 830: RA_CUSTOMER_TRX_LINES_ALL RAL,

826: AND REL.JTOT_OBJECT1_CODE = 'OKX_ORDERLINE') UNIQUEORDERLINESELECT,
827:
828: OE_ORDER_LINES_ALL OEL,
829: OE_ORDER_HEADERS_ALL OE,
830: RA_CUSTOMER_TRX_LINES_ALL RAL,
831: RA_CUSTOMER_TRX_ALL RA,
832: RA_CUSTOMER_TRX_LINES_ALL RATAX
833: WHERE
834: UNIQUEORDERLINESELECT.OBJECT1_ID1 = OEL.LINE_ID

Line 832: RA_CUSTOMER_TRX_LINES_ALL RATAX

828: OE_ORDER_LINES_ALL OEL,
829: OE_ORDER_HEADERS_ALL OE,
830: RA_CUSTOMER_TRX_LINES_ALL RAL,
831: RA_CUSTOMER_TRX_ALL RA,
832: RA_CUSTOMER_TRX_LINES_ALL RATAX
833: WHERE
834: UNIQUEORDERLINESELECT.OBJECT1_ID1 = OEL.LINE_ID
835: AND OEL.HEADER_ID = OE.HEADER_ID
836: AND TO_CHAR (OE.ORDER_NUMBER) = RAL.SALES_ORDER