DBA Data[Home] [Help]

APPS.OKL_OPEN_INTERFACE_PVT dependencies on OKX_AST_LOCS_V

Line 23074: FROM okx_ast_locs_v

23070: p_segment5 VARCHAR2,
23071: p_segment6 VARCHAR2,
23072: p_segment7 VARCHAR2 ) IS
23073: SELECT location_id
23074: FROM okx_ast_locs_v
23075: WHERE (segment1 = NVL(P_segment1,'NULL') OR segment1 IS NULL)
23076: AND (segment2 = NVL(p_segment2,'NULL') OR segment2 is NULL)
23077: AND (segment3 = NVL(p_segment3,'NULL') OR segment3 IS NULL)
23078: AND (segment4 = NVL(p_segment4,'NULL') OR segment4 IS NULL)