DBA Data[Home] [Help]

APPS.OKL_OPEN_INTERFACE_PVT dependencies on OKX_AST_LOCS_V

Line 23263: FROM okx_ast_locs_v

23259: p_segment5 VARCHAR2,
23260: p_segment6 VARCHAR2,
23261: p_segment7 VARCHAR2 ) IS
23262: SELECT location_id
23263: FROM okx_ast_locs_v
23264: WHERE (segment1 = NVL(P_segment1,'NULL') OR segment1 IS NULL)
23265: AND (segment2 = NVL(p_segment2,'NULL') OR segment2 is NULL)
23266: AND (segment3 = NVL(p_segment3,'NULL') OR segment3 IS NULL)
23267: AND (segment4 = NVL(p_segment4,'NULL') OR segment4 IS NULL)