DBA Data[Home] [Help]

APPS.OKE_CLE_PVT dependencies on OKC_K_HEADERS_B

Line 91: OKC_K_HEADERS_B H, OKC_K_LINES_B L

87: where item.customer_item_id = p_cle_rec.customer_item_id;
88:
89: CURSOR get_intent IS
90: SELECT BUY_OR_SELL FROM
91: OKC_K_HEADERS_B H, OKC_K_LINES_B L
92: WHERE L.DNZ_CHR_ID = H.ID
93: AND L.ID = p_cle_rec.k_line_id;
94:
95: l_intent VARCHAR2(30);

Line 582: OKC_K_HEADERS_B H,OKC_K_LINES_B L

578: l_lse_id NUMBER;
579:
580: CURSOR get_org IS
581: SELECT INV_ORGANIZATION_ID FROM
582: OKC_K_HEADERS_B H,OKC_K_LINES_B L
583: WHERE H.ID = L.DNZ_CHR_ID
584: AND L.ID = p_cle_rec.k_line_id;
585:
586: CURSOR get_lse_id IS