APPS.WMS_WAVE_PLANNING_PVT dependencies on WMS_WP_ADVANCED_CRITERIA

Line 1119: INSERT INTO wms_wp_Advanced_Criteria

1115: pick_subinventory
1116: FROM wms_wp_wave_headers_vl
1117: WHERE wave_header_id = p_wave_header_id;
1118:
1119: INSERT INTO wms_wp_Advanced_Criteria
1120: (RULE_ID,
1121: RULE_WAVE_HEADER_ID,
1122: SEQUENCE_NUMBER,
1123: LAST_UPDATED_BY,

Line 1143: SELECT wms_wp_advanced_criteria_s.NEXTVAL,

1139: OPERATOR_DESCRIPTION,
1140: OPERAND_VALUE,
1141: OPERAND_CHAR,
1142: BRACKET_CLOSE)
1143: SELECT wms_wp_advanced_criteria_s.NEXTVAL,
1144: l_wave_header_id,
1145: SEQUENCE_NUMBER,
1146: fnd_global.user_id,
1147: sysdate,

Line 1166: FROM wms_wp_Advanced_Criteria

1162: OPERATOR_DESCRIPTION,
1163: OPERAND_VALUE,
1164: OPERAND_CHAR,
1165: BRACKET_CLOSE
1166: FROM wms_wp_Advanced_Criteria
1167: WHERE rule_wave_header_id = p_wave_header_id;
1168:
1169: select WMS_WP_WAVE_HEADERS_S.CURRVAL into p_wave_header_id from dual;
1170:

Line 12286: FROM WMS_WP_ADVANCED_CRITERIA restrictions,

12282: cursor c_get_wave_parameters is
12283: SELECT restrictions.PARAMETER_ID,
12284: restrictions.OPERATOR_MEANING,
12285: restrictions.OPERAND_VALUE
12286: FROM WMS_WP_ADVANCED_CRITERIA restrictions,
12287: wms_wp_wave_headers_vl headers
12288: WHERE restrictions.RULE_WAVE_HEADER_ID = headers.wave_header_id
12289: and restrictions.RULE_WAVE_HEADER_ID = P_WAVE_HEADER_ID
12290: AND PARAMETER_ID IN (6002, 6003, 6004, 6005, 6006);

Line 12296: FROM WMS_WP_ADVANCED_CRITERIA restrictions,

12292: cursor c_get_wave_line_count is
12293: SELECT restrictions.PARAMETER_ID,
12294: restrictions.OPERATOR_MEANING,
12295: restrictions.OPERAND_VALUE
12296: FROM WMS_WP_ADVANCED_CRITERIA restrictions,
12297: wms_wp_wave_headers_vl headers
12298: WHERE restrictions.RULE_WAVE_HEADER_ID = headers.wave_header_id
12299: and restrictions.RULE_WAVE_HEADER_ID = P_WAVE_HEADER_ID
12300: AND PARAMETER_ID = 6001;

Line 13035: FROM WMS_WP_ADVANCED_CRITERIA

13031: v_cat_flag varchar2(1) := 'N';
13032:
13033: CURSOR C_ADVANCED_CONDITION IS
13034: SELECT PARAMETER_ID
13035: FROM WMS_WP_ADVANCED_CRITERIA
13036: WHERE RULE_WAVE_HEADER_ID = V_WAVE_HEADER_ID
13037: AND PARAMETER_ID IN
13038: (1006, 2001, 2002, 3002, 5001, 5002, 5003, 5004, 5005, 5006, 3001, 1011, 1004, 2006, 2004, 2005, 4002);
13039: BEGIN