[Home] [Help]
74:
75: CURSOR C IS
76: SELECT DECODE(Buy_Or_Sell, 'B', 'IN', 'OUT') Direction
77: , Inv_Organization_ID
78: FROM okc_k_headers_b
79: WHERE ID = P_Header_ID;
80:
81:
82: BEGIN
286: and rle_code = p_code
287: and object1_id1 is not null;
288:
289: cursor c is
290: select buy_or_sell from okc_k_headers_b
291: where id = p_header_id;
292:
293: cursor top_line is
294: select 'x' from okc_ancestrys
319:
320: BEGIN
321:
322: select buy_or_sell into l_buy_or_sell
323: from okc_k_headers_b
324: where id = p_header_id;
325:
326: IF p_line_id is not null then
327:
766: WHERE ID1 = P_ID;
767:
768: CURSOR Buy_Or_Sell ( P_ID NUMBER ) IS
769: SELECT Buy_Or_Sell
770: FROM OKC_K_HEADERS_B
771: WHERE ID = P_ID;
772:
773: CURSOR Ven_C ( P_ID NUMBER ) IS
774: SELECT Vendor_ID, status
978: l.copies_required,
979: l.cdrl_category,
980: l.data_item_name,
981: l.export_flag
982: from oke_k_lines_v l, okc_k_headers_b h, oke_k_headers k
983: where h.id = l.header_id
984: and l.k_line_id = p_id
985: and h.id = k.k_header_id;
986:
1214: l.copies_required,
1215: l.cdrl_category,
1216: l.data_item_name,
1217: l.export_flag
1218: from oke_k_lines_v l, okc_k_headers_b h, oke_k_headers k
1219: where h.id = p_id
1220: and l.header_id = p_id
1221: and h.id = k.k_header_id
1222: and not exists (select 'x' from oke_k_deliverables_b where k_line_id = l.k_line_id and nvl(defaulted_flag, 'N') = 'Y')
1372: l.copies_required,
1373: l.cdrl_category,
1374: l.data_item_name,
1375: l.export_flag
1376: from oke_k_lines_v l, okc_k_headers_b h, oke_k_headers k
1377: where l.k_line_id = p_id
1378: and h.id = l.header_id
1379: and k.k_header_id = l.header_id;
1380:
1905: , L.Header_ID
1906: , L.Inventory_Item_ID
1907: , L.Line_Quantity
1908: , L.Line_Number
1909: FROM okc_k_headers_b H, oke_k_lines_v L
1910: WHERE H.ID = L.Header_ID
1911: AND L.K_Line_ID = P_Line_ID;
1912:
1913: CURSOR Item_C IS