DBA Data[Home] [Help]

APPS.WMS_WAVE_PLANNING_PVT dependencies on WMS_SAVED_QUERIES

Line 9332: from wms_saved_queries

9328: --ltrim(rtrim(field_value)) field_value,
9329: field_value,
9330: organization_id,
9331: query_type
9332: from wms_saved_queries
9333: where query_name = p_query_name
9334: and (query_type = 'TASK_PLANNING' or
9335: query_type = 'TEMP_TASK_PLANNING')
9336: FOR UPDATE NOWAIT;

Line 16973: from wms_saved_queries

16969: l_message_table wms_wave_planning_pvt.message_table_type;
16970:
16971: CURSOR c_saved_actions(p_action_name varchar2) IS
16972: select field_name, field_value, query_type
16973: from wms_saved_queries
16974: where query_name = p_action_name
16975: and (query_type = 'TASK_ACTION' or query_type = 'TEMP_TASK_ACTION')
16976: FOR UPDATE NOWAIT;
16977:

Line 16980: from wms_saved_queries

16976: FOR UPDATE NOWAIT;
16977:
16978: CURSOR c_query_type(p_action_name varchar2) IS
16979: select distinct query_type
16980: from wms_saved_queries
16981: where query_name = p_action_name;
16982:
16983: rec_saved_actions c_saved_actions%rowtype;
16984: