DBA Data[Home] [Help]

APPS.OKS_AUTH_UTIL_PVT dependencies on MTL_ITEM_REVISIONS_VL

Line 6257: FROM MTL_ITEM_REVISIONS_VL

6253:
6254: CURSOR l_csr_get_item_revision(p_item_id IN NUMBER, p_organization_id IN NUMBER)
6255: IS
6256: SELECT revision
6257: FROM MTL_ITEM_REVISIONS_VL
6258: WHERE inventory_item_id = p_item_id
6259: AND organization_id = p_organization_id;
6260:
6261:

Line 6277: l_revision MTL_ITEM_REVISIONS_VL.revision%TYPE;

6273: l_cust_acct_id OKX_CUSTOMER_ACCOUNTS_V.id1%TYPE;
6274:
6275:
6276: l_revision_control_yn MTL_SYSTEM_ITEMS_KFV.revision_qty_control_code%TYPE;
6277: l_revision MTL_ITEM_REVISIONS_VL.revision%TYPE;
6278: l_ship_to_site_use_id OKC_K_HEADERS_B.ship_to_site_use_id%TYPE;
6279: l_bill_to_site_use_id OKC_K_HEADERS_B.bill_to_site_use_id%TYPE;
6280:
6281: FUNCTION ship_to(p_cle_id IN NUMBER)