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.OKL_PAY_INVOICES_DISB_PVT dependencies on OKC_K_HEADERS_ALL_B

Line 2560: FROM OKC_K_HEADERS_ALL_B KHR_OP

2556: ( EXISTS
2557: (
2558: -- indirect refer from MLA contract's credit line
2559: SELECT 1 -- op chrid
2560: FROM OKC_K_HEADERS_ALL_B KHR_OP
2561: WHERE KHR_OP.ID = TPL.KHR_ID -- link
2562: AND EXISTS (
2563: SELECT 1 -- MLA id
2564: FROM OKC_K_HEADERS_ALL_B KHR,

Line 2564: FROM OKC_K_HEADERS_ALL_B KHR,

2560: FROM OKC_K_HEADERS_ALL_B KHR_OP
2561: WHERE KHR_OP.ID = TPL.KHR_ID -- link
2562: AND EXISTS (
2563: SELECT 1 -- MLA id
2564: FROM OKC_K_HEADERS_ALL_B KHR,
2565: OKC_GOVERNANCES MLA_GOV
2566: WHERE KHR.ID = MLA_GOV.CHR_ID_REFERRED
2567: AND KHR.SCS_CODE = 'MASTER_LEASE'
2568: AND MLA_GOV.DNZ_CHR_ID = KHR_OP.ID -- link

Line 2571: FROM OKC_K_HEADERS_ALL_B CRD,

2567: AND KHR.SCS_CODE = 'MASTER_LEASE'
2568: AND MLA_GOV.DNZ_CHR_ID = KHR_OP.ID -- link
2569: AND EXISTS (
2570: SELECT 1 -- credit line id
2571: FROM OKC_K_HEADERS_ALL_B CRD,
2572: OKC_GOVERNANCES CRD_GOV
2573: WHERE CRD.ID = CRD_GOV.CHR_ID_REFERRED
2574: AND CRD.STS_CODE = 'ACTIVE'
2575: AND KHR.ID = CRD_GOV.DNZ_CHR_ID -- link

Line 2585: FROM OKC_K_HEADERS_ALL_B KHR

2581: EXISTS
2582: (
2583: -- non-MLA contracts direct associated with credit line
2584: SELECT 1 -- op chrid
2585: FROM OKC_K_HEADERS_ALL_B KHR
2586: WHERE KHR.ID = TPL.KHR_ID -- link
2587: AND KHR.SCS_CODE <> 'MASTER_LEASE'
2588: AND EXISTS (
2589: SELECT 1 -- credit line id

Line 2590: FROM OKC_K_HEADERS_ALL_B CRD,

2586: WHERE KHR.ID = TPL.KHR_ID -- link
2587: AND KHR.SCS_CODE <> 'MASTER_LEASE'
2588: AND EXISTS (
2589: SELECT 1 -- credit line id
2590: FROM OKC_K_HEADERS_ALL_B CRD,
2591: OKC_GOVERNANCES CRD_GOV
2592: WHERE CRD.ID = CRD_GOV.CHR_ID_REFERRED
2593: AND CRD.STS_CODE = 'ACTIVE'
2594: AND KHR.ID = CRD_GOV.DNZ_CHR_ID -- link

Line 2633: FROM OKC_K_HEADERS_ALL_B KHR_OP

2629: ( EXISTS
2630: (
2631: -- indirect refer from MLA contract's credit line
2632: SELECT 1 -- op chrid
2633: FROM OKC_K_HEADERS_ALL_B KHR_OP
2634: WHERE KHR_OP.ID = CN.ID -- link
2635: AND EXISTS (
2636: SELECT 1 -- MLA id
2637: FROM OKC_K_HEADERS_ALL_B KHR,

Line 2637: FROM OKC_K_HEADERS_ALL_B KHR,

2633: FROM OKC_K_HEADERS_ALL_B KHR_OP
2634: WHERE KHR_OP.ID = CN.ID -- link
2635: AND EXISTS (
2636: SELECT 1 -- MLA id
2637: FROM OKC_K_HEADERS_ALL_B KHR,
2638: OKC_GOVERNANCES MLA_GOV
2639: WHERE KHR.ID = MLA_GOV.CHR_ID_REFERRED
2640: AND KHR.SCS_CODE = 'MASTER_LEASE'
2641: AND MLA_GOV.DNZ_CHR_ID = KHR_OP.ID -- link

Line 2644: FROM OKC_K_HEADERS_ALL_B CRD,

2640: AND KHR.SCS_CODE = 'MASTER_LEASE'
2641: AND MLA_GOV.DNZ_CHR_ID = KHR_OP.ID -- link
2642: AND EXISTS (
2643: SELECT 1 -- credit line id
2644: FROM OKC_K_HEADERS_ALL_B CRD,
2645: OKC_GOVERNANCES CRD_GOV
2646: WHERE CRD.ID = CRD_GOV.CHR_ID_REFERRED
2647: AND CRD.STS_CODE = 'ACTIVE'
2648: AND KHR.ID = CRD_GOV.DNZ_CHR_ID -- link

Line 2658: FROM OKC_K_HEADERS_ALL_B KHR

2654: EXISTS
2655: (
2656: -- non-MLA contracts direct associated with credit line
2657: SELECT 1 -- op chrid
2658: FROM OKC_K_HEADERS_ALL_B KHR
2659: WHERE KHR.ID = CN.ID -- link
2660: AND KHR.SCS_CODE <> 'MASTER_LEASE'
2661: AND EXISTS (
2662: SELECT 1 -- credit line id

Line 2663: FROM OKC_K_HEADERS_ALL_B CRD,

2659: WHERE KHR.ID = CN.ID -- link
2660: AND KHR.SCS_CODE <> 'MASTER_LEASE'
2661: AND EXISTS (
2662: SELECT 1 -- credit line id
2663: FROM OKC_K_HEADERS_ALL_B CRD,
2664: OKC_GOVERNANCES CRD_GOV
2665: WHERE CRD.ID = CRD_GOV.CHR_ID_REFERRED
2666: AND CRD.STS_CODE = 'ACTIVE'
2667: AND KHR.ID = CRD_GOV.DNZ_CHR_ID -- link