[Home] [Help]
936:
937: --bug 8466686 added code to find if an item is inventory item or not
938: CURSOR inv_item_yn(p_id number) IS
939: SELECT o.INVENTORY_ITEM_FLAG
940: FROM oke_system_items_v o,oke_k_lines_v b WHERE
941: b.k_line_id = p_id
942: and o.ID1 = b.inventory_item_id ;
943:
944: l_inv_item_yn VARCHAR2(1);
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:
1598: L_Token_Value VARCHAR2(2000);
1599:
1600: CURSOR Update_C ( P_ID NUMBER ) IS
1601: SELECT l.k_line_id, b.deliverable_ID, l.line_number
1602: from oke_k_lines_v l, oke_k_deliverables_b b
1603: where b.k_header_id = p_id
1604: and b.k_line_id = l.k_line_id
1605: and nvl(l.scheduled_delv_default, 'N') = 'Y'
1606: and nvl(defaulted_flag, 'N') = 'Y'
1650: IF L_Return_Status <> OKE_API.G_Ret_Sts_Unexp_Error THEN
1651: L_Return_Status := X_Return_Status;
1652: END IF;
1653: ELSE
1654: UPDATE oke_k_lines
1655: SET Scheduled_Delv_Default = 'N'
1656: WHERE K_Line_ID = Update_Rec.K_Line_ID;
1657: END IF;
1658:
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