DBA Data[Home] [Help]

APPS.OKS_MISC_UTIL_WEB dependencies on RA_CUSTOMER_TRX_ALL

Line 343: ra_customer_trx_all ra,

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
347: and oel.header_id = oe.header_id

Line 391: ra_customer_trx_all ra,

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

Line 831: RA_CUSTOMER_TRX_ALL RA,

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
835: AND OEL.HEADER_ID = OE.HEADER_ID

Line 1114: FROM ra_customer_trx_all rah

1110:
1111: CURSOR get_commitment_number_csr(p_commitment_id NUMBER,
1112: p_org_id NUMBER) IS
1113: SELECT trx_number
1114: FROM ra_customer_trx_all rah
1115: WHERE rah.customer_trx_id = p_commitment_id
1116: AND nvl(rah.org_id,-99) = p_org_id;
1117:
1118: BEGIN