APPS.OKE_CLE_PVT dependencies on OKE_SYSTEM_ITEMS_V

Line 591: SELECT 'x' FROM OKE_SYSTEM_ITEMS_V

587: SELECT lse_id from okc_k_lines_b
588: WHERE ID = p_cle_rec.k_line_id;
589:
590: CURSOR l_csr IS
591: SELECT 'x' FROM OKE_SYSTEM_ITEMS_V
592: WHERE ORGANIZATION_ID = l_org
593: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE - 1)
594: AND NVL(END_DATE_ACTIVE, SYSDATE + 1) AND STATUS = 'A'
595: AND ID1 = p_cle_rec.inventory_item_id;

Line 650: p_token3_value => 'OKE_SYSTEM_ITEMS_V');

646: p_token1_value => 'INVENTORY_ITEM_ID',
647: p_token2 => g_child_table_token,
648: p_token2_value => G_VIEW,
649: p_token3 => g_parent_table_token,
650: p_token3_value => 'OKE_SYSTEM_ITEMS_V');
651: -- notify caller of an error
652: x_return_status := OKE_API.G_RET_STS_ERROR;
653: End If;
654: