DBA Data[Home] [Help]

APPS.OKL_ASD_PVT dependencies on OKX_SYSTEM_ITEMS_V

Line 26: -- Description : FK validation with okx_system_items_v

22: ----------------------------------7---------------------------------------------
23: -- Start of Commnets
24: -- chenkuang.lee
25: -- Procedure Name : Validate_INVENTORY_ITEM_ID
26: -- Description : FK validation with okx_system_items_v
27: -- Business Rules :
28: -- Parameters : OUT Return Status, IN Rec Info
29: -- Version : 1.0
30: -- End of Commnets

Line 37: FROM okx_system_items_v

33: p_asdv_rec IN asdv_rec_type) IS
34: ln_dummy number := 0;
35: CURSOR c_INVENTORY_ITEM_ID_validate(p_id number) is
36: SELECT 1
37: FROM okx_system_items_v
38: WHERE id1 = p_id;
39: --AND ID2=OKL_CONTEXT.get_okc_organization_id; -- multi-org enable
40:
41: BEGIN