DBA Data[Home] [Help]

APPS.OKS_MISC_UTIL_WEB dependencies on OE_ORDER_HEADERS_ALL

Line 341: oe_order_headers_all oe,

337: and subline.id = rel.cle_id
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

Line 389: oe_order_headers_all oe,

385: from
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

Line 523: oe_order_headers_all oe,

519: and subline.id = rel.cle_id
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

Line 579: ,oe_order_headers_all oe

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
582: ,okc_k_lines_b subline
583: WHERE

Line 717: OE_ORDER_HEADERS_ALL OE,

713: AND BCL.BILL_ACTION = 'RI'
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

Line 829: OE_ORDER_HEADERS_ALL OE,

825: AND SUBLINE.ID = REL.CLE_ID
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