DBA Data[Home] [Help]

APPS.IEX_SCORE_CASE_PVT dependencies on OKC_K_HEADERS_B

Line 56: OKC_K_HEADERS_B KH,

52: SELECT SUM (PS.ACCTD_AMOUNT_DUE_REMAINING) AMOUNT
53: FROM
54: AR_PAYMENT_SCHEDULES PS,
55: OKL_CNSLD_AR_STRMS_B ST,
56: OKC_K_HEADERS_B KH,
57: IEX_CASE_OBJECTS CAO
58: WHERE
59: PS.CUSTOMER_TRX_ID = ST.RECEIVABLES_INVOICE_ID
60: AND KH.ID = ST.KHR_ID

Line 434: from okc_k_headers_b chr

430:
431: -- begin raverma 04182003 change AR_PAY_SCHED_ALL to org enabled view
432: BEGIN
433: select round(ps.due_date - sysdate) into l_DueInDays
434: from okc_k_headers_b chr
435: ,okc_rules_b sll
436: ,okc_rules_b slh
437: ,okc_rule_groups_b rg
438: ,OKL_CNSLD_AR_STRMS_B ST