DBA Data[Home] [Help]

APPS.OKS_MISC_UTIL_WEB dependencies on OE_ORDER_LINES_ALL

Line 340: oe_order_lines_all oel,

336: AND bcl.bill_action = 'RI'
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

Line 388: oe_order_lines_all oel,

384: rank() over (partition by ral.customer_trx_line_id order by ratax.customer_trx_line_id) r
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

Line 522: oe_order_lines_all oel,

518: AND bcl.bill_action = 'RI'
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

Line 580: ,oe_order_lines_all oel

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
584: subline.id = l_line_id

Line 716: OE_ORDER_LINES_ALL OEL,

712: AND BCL.BTN_ID = - 44
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

Line 828: OE_ORDER_LINES_ALL OEL,

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

Line 1166: ,oe_order_lines_all oel

1162: 'Y'
1163: END) isComponentFlag
1164: FROM okc_k_items itm
1165: ,csi_item_instances csi
1166: ,oe_order_lines_all oel
1167: ,oe_order_lines_all oel1
1168: ,(SELECT rel.object1_id1,
1169: rel.cle_id
1170: FROM okc_k_rel_objs rel

Line 1167: ,oe_order_lines_all oel1

1163: END) isComponentFlag
1164: FROM okc_k_items itm
1165: ,csi_item_instances csi
1166: ,oe_order_lines_all oel
1167: ,oe_order_lines_all oel1
1168: ,(SELECT rel.object1_id1,
1169: rel.cle_id
1170: FROM okc_k_rel_objs rel
1171: WHERE rel.cle_id = l_line_id