DBA Data[Home] [Help]

APPS.OKS_AUTH_UTIL_PVT dependencies on MTL_ITEM_REVISIONS_VL

Line 5643: FROM MTL_ITEM_REVISIONS_VL

5639:
5640: CURSOR l_csr_get_item_revision(p_item_id IN NUMBER, p_organization_id IN NUMBER)
5641: IS
5642: SELECT revision
5643: FROM MTL_ITEM_REVISIONS_VL
5644: WHERE inventory_item_id = p_item_id
5645: AND organization_id = p_organization_id;
5646:
5647:

Line 5663: l_revision MTL_ITEM_REVISIONS_VL.revision%TYPE;

5659: l_cust_acct_id OKX_CUSTOMER_ACCOUNTS_V.id1%TYPE;
5660:
5661:
5662: l_revision_control_yn MTL_SYSTEM_ITEMS_KFV.revision_qty_control_code%TYPE;
5663: l_revision MTL_ITEM_REVISIONS_VL.revision%TYPE;
5664: l_ship_to_site_use_id OKC_K_HEADERS_B.ship_to_site_use_id%TYPE;
5665: l_bill_to_site_use_id OKC_K_HEADERS_B.bill_to_site_use_id%TYPE;
5666:
5667: FUNCTION ship_to(p_cle_id IN NUMBER)