APPS.OKL_PAY_INVOICES_DISB_PVT dependencies on OKC_K_HEADERS_ALL_B

Line 2613: FROM OKC_K_HEADERS_ALL_B KHR_OP

2609: ( EXISTS
2610: (
2611: -- indirect refer from MLA contract's credit line
2612: SELECT 1 -- op chrid
2613: FROM OKC_K_HEADERS_ALL_B KHR_OP
2614: WHERE KHR_OP.ID = TPL.KHR_ID -- link
2615: AND EXISTS (
2616: SELECT 1 -- MLA id
2617: FROM OKC_K_HEADERS_ALL_B KHR,

Line 2617: FROM OKC_K_HEADERS_ALL_B KHR,

2613: FROM OKC_K_HEADERS_ALL_B KHR_OP
2614: WHERE KHR_OP.ID = TPL.KHR_ID -- link
2615: AND EXISTS (
2616: SELECT 1 -- MLA id
2617: FROM OKC_K_HEADERS_ALL_B KHR,
2618: OKC_GOVERNANCES MLA_GOV
2619: WHERE KHR.ID = MLA_GOV.CHR_ID_REFERRED
2620: AND KHR.SCS_CODE = 'MASTER_LEASE'
2621: AND MLA_GOV.DNZ_CHR_ID = KHR_OP.ID -- link

Line 2624: FROM OKC_K_HEADERS_ALL_B CRD,

2620: AND KHR.SCS_CODE = 'MASTER_LEASE'
2621: AND MLA_GOV.DNZ_CHR_ID = KHR_OP.ID -- link
2622: AND EXISTS (
2623: SELECT 1 -- credit line id
2624: FROM OKC_K_HEADERS_ALL_B CRD,
2625: OKC_GOVERNANCES CRD_GOV
2626: WHERE CRD.ID = CRD_GOV.CHR_ID_REFERRED
2627: AND CRD.STS_CODE = 'ACTIVE'
2628: AND KHR.ID = CRD_GOV.DNZ_CHR_ID -- link

Line 2638: FROM OKC_K_HEADERS_ALL_B KHR

2634: EXISTS
2635: (
2636: -- non-MLA contracts direct associated with credit line
2637: SELECT 1 -- op chrid
2638: FROM OKC_K_HEADERS_ALL_B KHR
2639: WHERE KHR.ID = TPL.KHR_ID -- link
2640: AND KHR.SCS_CODE <> 'MASTER_LEASE'
2641: AND EXISTS (
2642: SELECT 1 -- credit line id

Line 2643: FROM OKC_K_HEADERS_ALL_B CRD,

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

Line 2686: FROM OKC_K_HEADERS_ALL_B KHR_OP

2682: ( EXISTS
2683: (
2684: -- indirect refer from MLA contract's credit line
2685: SELECT 1 -- op chrid
2686: FROM OKC_K_HEADERS_ALL_B KHR_OP
2687: WHERE KHR_OP.ID = CN.ID -- link
2688: AND EXISTS (
2689: SELECT 1 -- MLA id
2690: FROM OKC_K_HEADERS_ALL_B KHR,

Line 2690: FROM OKC_K_HEADERS_ALL_B KHR,

2686: FROM OKC_K_HEADERS_ALL_B KHR_OP
2687: WHERE KHR_OP.ID = CN.ID -- link
2688: AND EXISTS (
2689: SELECT 1 -- MLA id
2690: FROM OKC_K_HEADERS_ALL_B KHR,
2691: OKC_GOVERNANCES MLA_GOV
2692: WHERE KHR.ID = MLA_GOV.CHR_ID_REFERRED
2693: AND KHR.SCS_CODE = 'MASTER_LEASE'
2694: AND MLA_GOV.DNZ_CHR_ID = KHR_OP.ID -- link

Line 2697: FROM OKC_K_HEADERS_ALL_B CRD,

2693: AND KHR.SCS_CODE = 'MASTER_LEASE'
2694: AND MLA_GOV.DNZ_CHR_ID = KHR_OP.ID -- link
2695: AND EXISTS (
2696: SELECT 1 -- credit line id
2697: FROM OKC_K_HEADERS_ALL_B CRD,
2698: OKC_GOVERNANCES CRD_GOV
2699: WHERE CRD.ID = CRD_GOV.CHR_ID_REFERRED
2700: AND CRD.STS_CODE = 'ACTIVE'
2701: AND KHR.ID = CRD_GOV.DNZ_CHR_ID -- link

Line 2711: FROM OKC_K_HEADERS_ALL_B KHR

2707: EXISTS
2708: (
2709: -- non-MLA contracts direct associated with credit line
2710: SELECT 1 -- op chrid
2711: FROM OKC_K_HEADERS_ALL_B KHR
2712: WHERE KHR.ID = CN.ID -- link
2713: AND KHR.SCS_CODE <> 'MASTER_LEASE'
2714: AND EXISTS (
2715: SELECT 1 -- credit line id

Line 2716: FROM OKC_K_HEADERS_ALL_B CRD,

2712: WHERE KHR.ID = CN.ID -- link
2713: AND KHR.SCS_CODE <> 'MASTER_LEASE'
2714: AND EXISTS (
2715: SELECT 1 -- credit line id
2716: FROM OKC_K_HEADERS_ALL_B CRD,
2717: OKC_GOVERNANCES CRD_GOV
2718: WHERE CRD.ID = CRD_GOV.CHR_ID_REFERRED
2719: AND CRD.STS_CODE = 'ACTIVE'
2720: AND KHR.ID = CRD_GOV.DNZ_CHR_ID -- link