[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
968: l.copies_required,
969: l.cdrl_category,
970: l.data_item_name,
971: l.export_flag
972: from oke_k_lines_v l, okc_k_headers_b h, oke_k_headers k
973: where h.id = l.header_id
974: and l.k_line_id = p_id
975: and h.id = k.k_header_id;
976:
1192: l.copies_required,
1193: l.cdrl_category,
1194: l.data_item_name,
1195: l.export_flag
1196: from oke_k_lines_v l, okc_k_headers_b h, oke_k_headers k
1197: where h.id = p_id
1198: and l.header_id = p_id
1199: and h.id = k.k_header_id
1200: and not exists (select 'x' from oke_k_deliverables_b where k_line_id = l.k_line_id and nvl(defaulted_flag, 'N') = 'Y')
1350: l.copies_required,
1351: l.cdrl_category,
1352: l.data_item_name,
1353: l.export_flag
1354: from oke_k_lines_v l, okc_k_headers_b h, oke_k_headers k
1355: where l.k_line_id = p_id
1356: and h.id = l.header_id
1357: and k.k_header_id = l.header_id;
1358:
1883: , L.Header_ID
1884: , L.Inventory_Item_ID
1885: , L.Line_Quantity
1886: , L.Line_Number
1887: FROM okc_k_headers_b H, oke_k_lines_v L
1888: WHERE H.ID = L.Header_ID
1889: AND L.K_Line_ID = P_Line_ID;
1890:
1891: CURSOR Item_C IS