DBA Data[Home] [Help]

APPS.QP_LIST_UPGRADE_UTIL_PVT dependencies on SO_PRICE_LIST_LINES_115

Line 70: so_price_list_lines_115

66: is
67: select
68: price_list_line_id
69: from
70: so_price_list_lines_115
71: where price_list_line_id not in ( select list_line_id
72: from qp_LIST_lines )
73: order by price_list_line_id;
74:

Line 105: so_price_list_lines_115

101: l_total_lines,
102: l_min_line,
103: l_max_line
104: from
105: so_price_list_lines_115
106: where price_list_line_id not in ( select list_line_id
107: from qp_LIST_lines );
108:
109: exception

Line 216: SO_PRICE_LIST_LINES_115;

212: INTO
213: L_MIN_LINE,
214: L_MAX_LINE
215: FROM
216: SO_PRICE_LIST_LINES_115;
217:
218: exception
219: when others then
220: null;

Line 1182: SO_PRICE_LIST_LINES_115.price_list_line_id%TYPE INDEX BY BINARY_INTEGER;

1178:
1179: e_get_prod_flex_properties EXCEPTION;
1180:
1181: TYPE price_list_line_id_tab is table of
1182: SO_PRICE_LIST_LINES_115.price_list_line_id%TYPE INDEX BY BINARY_INTEGER;
1183: TYPE creation_date_tab is table of SO_PRICE_LIST_LINES_115.creation_date%TYPE INDEX BY BINARY_INTEGER;
1184: TYPE created_by_tab is table of SO_PRICE_LIST_LINES_115.created_by%TYPE INDEX BY BINARY_INTEGER;
1185: TYPE last_update_date_tab is table of
1186: SO_PRICE_LIST_LINES_115.last_update_date%TYPE INDEX BY BINARY_INTEGER;

Line 1183: TYPE creation_date_tab is table of SO_PRICE_LIST_LINES_115.creation_date%TYPE INDEX BY BINARY_INTEGER;

1179: e_get_prod_flex_properties EXCEPTION;
1180:
1181: TYPE price_list_line_id_tab is table of
1182: SO_PRICE_LIST_LINES_115.price_list_line_id%TYPE INDEX BY BINARY_INTEGER;
1183: TYPE creation_date_tab is table of SO_PRICE_LIST_LINES_115.creation_date%TYPE INDEX BY BINARY_INTEGER;
1184: TYPE created_by_tab is table of SO_PRICE_LIST_LINES_115.created_by%TYPE INDEX BY BINARY_INTEGER;
1185: TYPE last_update_date_tab is table of
1186: SO_PRICE_LIST_LINES_115.last_update_date%TYPE INDEX BY BINARY_INTEGER;
1187: TYPE last_updated_by_tab is table of

Line 1184: TYPE created_by_tab is table of SO_PRICE_LIST_LINES_115.created_by%TYPE INDEX BY BINARY_INTEGER;

1180:
1181: TYPE price_list_line_id_tab is table of
1182: SO_PRICE_LIST_LINES_115.price_list_line_id%TYPE INDEX BY BINARY_INTEGER;
1183: TYPE creation_date_tab is table of SO_PRICE_LIST_LINES_115.creation_date%TYPE INDEX BY BINARY_INTEGER;
1184: TYPE created_by_tab is table of SO_PRICE_LIST_LINES_115.created_by%TYPE INDEX BY BINARY_INTEGER;
1185: TYPE last_update_date_tab is table of
1186: SO_PRICE_LIST_LINES_115.last_update_date%TYPE INDEX BY BINARY_INTEGER;
1187: TYPE last_updated_by_tab is table of
1188: SO_PRICE_LIST_LINES_115.last_updated_by%TYPE INDEX BY BINARY_INTEGER;

Line 1186: SO_PRICE_LIST_LINES_115.last_update_date%TYPE INDEX BY BINARY_INTEGER;

1182: SO_PRICE_LIST_LINES_115.price_list_line_id%TYPE INDEX BY BINARY_INTEGER;
1183: TYPE creation_date_tab is table of SO_PRICE_LIST_LINES_115.creation_date%TYPE INDEX BY BINARY_INTEGER;
1184: TYPE created_by_tab is table of SO_PRICE_LIST_LINES_115.created_by%TYPE INDEX BY BINARY_INTEGER;
1185: TYPE last_update_date_tab is table of
1186: SO_PRICE_LIST_LINES_115.last_update_date%TYPE INDEX BY BINARY_INTEGER;
1187: TYPE last_updated_by_tab is table of
1188: SO_PRICE_LIST_LINES_115.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
1189: TYPE last_update_login_tab is table of
1190: SO_PRICE_LIST_LINES_115.last_update_login%TYPE INDEX BY BINARY_INTEGER;

Line 1188: SO_PRICE_LIST_LINES_115.last_updated_by%TYPE INDEX BY BINARY_INTEGER;

1184: TYPE created_by_tab is table of SO_PRICE_LIST_LINES_115.created_by%TYPE INDEX BY BINARY_INTEGER;
1185: TYPE last_update_date_tab is table of
1186: SO_PRICE_LIST_LINES_115.last_update_date%TYPE INDEX BY BINARY_INTEGER;
1187: TYPE last_updated_by_tab is table of
1188: SO_PRICE_LIST_LINES_115.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
1189: TYPE last_update_login_tab is table of
1190: SO_PRICE_LIST_LINES_115.last_update_login%TYPE INDEX BY BINARY_INTEGER;
1191: TYPE program_application_id_tab is table of
1192: SO_PRICE_LIST_LINES_115.program_application_id%TYPE INDEX BY BINARY_INTEGER;

Line 1190: SO_PRICE_LIST_LINES_115.last_update_login%TYPE INDEX BY BINARY_INTEGER;

1186: SO_PRICE_LIST_LINES_115.last_update_date%TYPE INDEX BY BINARY_INTEGER;
1187: TYPE last_updated_by_tab is table of
1188: SO_PRICE_LIST_LINES_115.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
1189: TYPE last_update_login_tab is table of
1190: SO_PRICE_LIST_LINES_115.last_update_login%TYPE INDEX BY BINARY_INTEGER;
1191: TYPE program_application_id_tab is table of
1192: SO_PRICE_LIST_LINES_115.program_application_id%TYPE INDEX BY BINARY_INTEGER;
1193: TYPE program_id_tab is table of SO_PRICE_LIST_LINES_115.program_id%TYPE INDEX BY BINARY_INTEGER;
1194: TYPE program_update_date_tab is table of

Line 1192: SO_PRICE_LIST_LINES_115.program_application_id%TYPE INDEX BY BINARY_INTEGER;

1188: SO_PRICE_LIST_LINES_115.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
1189: TYPE last_update_login_tab is table of
1190: SO_PRICE_LIST_LINES_115.last_update_login%TYPE INDEX BY BINARY_INTEGER;
1191: TYPE program_application_id_tab is table of
1192: SO_PRICE_LIST_LINES_115.program_application_id%TYPE INDEX BY BINARY_INTEGER;
1193: TYPE program_id_tab is table of SO_PRICE_LIST_LINES_115.program_id%TYPE INDEX BY BINARY_INTEGER;
1194: TYPE program_update_date_tab is table of
1195: SO_PRICE_LIST_LINES_115.program_update_date%TYPE INDEX BY BINARY_INTEGER;
1196: TYPE request_id_tab is table of SO_PRICE_LIST_LINES_115.request_id%TYPE INDEX BY BINARY_INTEGER;

Line 1193: TYPE program_id_tab is table of SO_PRICE_LIST_LINES_115.program_id%TYPE INDEX BY BINARY_INTEGER;

1189: TYPE last_update_login_tab is table of
1190: SO_PRICE_LIST_LINES_115.last_update_login%TYPE INDEX BY BINARY_INTEGER;
1191: TYPE program_application_id_tab is table of
1192: SO_PRICE_LIST_LINES_115.program_application_id%TYPE INDEX BY BINARY_INTEGER;
1193: TYPE program_id_tab is table of SO_PRICE_LIST_LINES_115.program_id%TYPE INDEX BY BINARY_INTEGER;
1194: TYPE program_update_date_tab is table of
1195: SO_PRICE_LIST_LINES_115.program_update_date%TYPE INDEX BY BINARY_INTEGER;
1196: TYPE request_id_tab is table of SO_PRICE_LIST_LINES_115.request_id%TYPE INDEX BY BINARY_INTEGER;
1197: TYPE price_list_id_tab is table of SO_PRICE_LIST_LINES_115.price_list_id%TYPE INDEX BY BINARY_INTEGER;

Line 1195: SO_PRICE_LIST_LINES_115.program_update_date%TYPE INDEX BY BINARY_INTEGER;

1191: TYPE program_application_id_tab is table of
1192: SO_PRICE_LIST_LINES_115.program_application_id%TYPE INDEX BY BINARY_INTEGER;
1193: TYPE program_id_tab is table of SO_PRICE_LIST_LINES_115.program_id%TYPE INDEX BY BINARY_INTEGER;
1194: TYPE program_update_date_tab is table of
1195: SO_PRICE_LIST_LINES_115.program_update_date%TYPE INDEX BY BINARY_INTEGER;
1196: TYPE request_id_tab is table of SO_PRICE_LIST_LINES_115.request_id%TYPE INDEX BY BINARY_INTEGER;
1197: TYPE price_list_id_tab is table of SO_PRICE_LIST_LINES_115.price_list_id%TYPE INDEX BY BINARY_INTEGER;
1198: TYPE inventory_item_id_tab is table of
1199: SO_PRICE_LIST_LINES_115.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;

Line 1196: TYPE request_id_tab is table of SO_PRICE_LIST_LINES_115.request_id%TYPE INDEX BY BINARY_INTEGER;

1192: SO_PRICE_LIST_LINES_115.program_application_id%TYPE INDEX BY BINARY_INTEGER;
1193: TYPE program_id_tab is table of SO_PRICE_LIST_LINES_115.program_id%TYPE INDEX BY BINARY_INTEGER;
1194: TYPE program_update_date_tab is table of
1195: SO_PRICE_LIST_LINES_115.program_update_date%TYPE INDEX BY BINARY_INTEGER;
1196: TYPE request_id_tab is table of SO_PRICE_LIST_LINES_115.request_id%TYPE INDEX BY BINARY_INTEGER;
1197: TYPE price_list_id_tab is table of SO_PRICE_LIST_LINES_115.price_list_id%TYPE INDEX BY BINARY_INTEGER;
1198: TYPE inventory_item_id_tab is table of
1199: SO_PRICE_LIST_LINES_115.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
1200: TYPE unit_code_tab is table of SO_PRICE_LIST_LINES_115.unit_code%TYPE INDEX BY BINARY_INTEGER;

Line 1197: TYPE price_list_id_tab is table of SO_PRICE_LIST_LINES_115.price_list_id%TYPE INDEX BY BINARY_INTEGER;

1193: TYPE program_id_tab is table of SO_PRICE_LIST_LINES_115.program_id%TYPE INDEX BY BINARY_INTEGER;
1194: TYPE program_update_date_tab is table of
1195: SO_PRICE_LIST_LINES_115.program_update_date%TYPE INDEX BY BINARY_INTEGER;
1196: TYPE request_id_tab is table of SO_PRICE_LIST_LINES_115.request_id%TYPE INDEX BY BINARY_INTEGER;
1197: TYPE price_list_id_tab is table of SO_PRICE_LIST_LINES_115.price_list_id%TYPE INDEX BY BINARY_INTEGER;
1198: TYPE inventory_item_id_tab is table of
1199: SO_PRICE_LIST_LINES_115.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
1200: TYPE unit_code_tab is table of SO_PRICE_LIST_LINES_115.unit_code%TYPE INDEX BY BINARY_INTEGER;
1201: TYPE method_code_tab is table of SO_PRICE_LIST_LINES_115.method_code%TYPE INDEX BY BINARY_INTEGER;

Line 1199: SO_PRICE_LIST_LINES_115.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;

1195: SO_PRICE_LIST_LINES_115.program_update_date%TYPE INDEX BY BINARY_INTEGER;
1196: TYPE request_id_tab is table of SO_PRICE_LIST_LINES_115.request_id%TYPE INDEX BY BINARY_INTEGER;
1197: TYPE price_list_id_tab is table of SO_PRICE_LIST_LINES_115.price_list_id%TYPE INDEX BY BINARY_INTEGER;
1198: TYPE inventory_item_id_tab is table of
1199: SO_PRICE_LIST_LINES_115.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
1200: TYPE unit_code_tab is table of SO_PRICE_LIST_LINES_115.unit_code%TYPE INDEX BY BINARY_INTEGER;
1201: TYPE method_code_tab is table of SO_PRICE_LIST_LINES_115.method_code%TYPE INDEX BY BINARY_INTEGER;
1202: TYPE list_price_tab is table of SO_PRICE_LIST_LINES_115.list_price%TYPE INDEX BY BINARY_INTEGER;
1203: TYPE pricing_rule_id_tab is table of

Line 1200: TYPE unit_code_tab is table of SO_PRICE_LIST_LINES_115.unit_code%TYPE INDEX BY BINARY_INTEGER;

1196: TYPE request_id_tab is table of SO_PRICE_LIST_LINES_115.request_id%TYPE INDEX BY BINARY_INTEGER;
1197: TYPE price_list_id_tab is table of SO_PRICE_LIST_LINES_115.price_list_id%TYPE INDEX BY BINARY_INTEGER;
1198: TYPE inventory_item_id_tab is table of
1199: SO_PRICE_LIST_LINES_115.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
1200: TYPE unit_code_tab is table of SO_PRICE_LIST_LINES_115.unit_code%TYPE INDEX BY BINARY_INTEGER;
1201: TYPE method_code_tab is table of SO_PRICE_LIST_LINES_115.method_code%TYPE INDEX BY BINARY_INTEGER;
1202: TYPE list_price_tab is table of SO_PRICE_LIST_LINES_115.list_price%TYPE INDEX BY BINARY_INTEGER;
1203: TYPE pricing_rule_id_tab is table of
1204: SO_PRICE_LIST_LINES_115.pricing_rule_id%TYPE INDEX BY BINARY_INTEGER;

Line 1201: TYPE method_code_tab is table of SO_PRICE_LIST_LINES_115.method_code%TYPE INDEX BY BINARY_INTEGER;

1197: TYPE price_list_id_tab is table of SO_PRICE_LIST_LINES_115.price_list_id%TYPE INDEX BY BINARY_INTEGER;
1198: TYPE inventory_item_id_tab is table of
1199: SO_PRICE_LIST_LINES_115.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
1200: TYPE unit_code_tab is table of SO_PRICE_LIST_LINES_115.unit_code%TYPE INDEX BY BINARY_INTEGER;
1201: TYPE method_code_tab is table of SO_PRICE_LIST_LINES_115.method_code%TYPE INDEX BY BINARY_INTEGER;
1202: TYPE list_price_tab is table of SO_PRICE_LIST_LINES_115.list_price%TYPE INDEX BY BINARY_INTEGER;
1203: TYPE pricing_rule_id_tab is table of
1204: SO_PRICE_LIST_LINES_115.pricing_rule_id%TYPE INDEX BY BINARY_INTEGER;
1205: TYPE reprice_flag_tab is table of SO_PRICE_LIST_LINES_115.reprice_flag%TYPE INDEX BY BINARY_INTEGER;

Line 1202: TYPE list_price_tab is table of SO_PRICE_LIST_LINES_115.list_price%TYPE INDEX BY BINARY_INTEGER;

1198: TYPE inventory_item_id_tab is table of
1199: SO_PRICE_LIST_LINES_115.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
1200: TYPE unit_code_tab is table of SO_PRICE_LIST_LINES_115.unit_code%TYPE INDEX BY BINARY_INTEGER;
1201: TYPE method_code_tab is table of SO_PRICE_LIST_LINES_115.method_code%TYPE INDEX BY BINARY_INTEGER;
1202: TYPE list_price_tab is table of SO_PRICE_LIST_LINES_115.list_price%TYPE INDEX BY BINARY_INTEGER;
1203: TYPE pricing_rule_id_tab is table of
1204: SO_PRICE_LIST_LINES_115.pricing_rule_id%TYPE INDEX BY BINARY_INTEGER;
1205: TYPE reprice_flag_tab is table of SO_PRICE_LIST_LINES_115.reprice_flag%TYPE INDEX BY BINARY_INTEGER;
1206: TYPE pricing_context_tab is table of

Line 1204: SO_PRICE_LIST_LINES_115.pricing_rule_id%TYPE INDEX BY BINARY_INTEGER;

1200: TYPE unit_code_tab is table of SO_PRICE_LIST_LINES_115.unit_code%TYPE INDEX BY BINARY_INTEGER;
1201: TYPE method_code_tab is table of SO_PRICE_LIST_LINES_115.method_code%TYPE INDEX BY BINARY_INTEGER;
1202: TYPE list_price_tab is table of SO_PRICE_LIST_LINES_115.list_price%TYPE INDEX BY BINARY_INTEGER;
1203: TYPE pricing_rule_id_tab is table of
1204: SO_PRICE_LIST_LINES_115.pricing_rule_id%TYPE INDEX BY BINARY_INTEGER;
1205: TYPE reprice_flag_tab is table of SO_PRICE_LIST_LINES_115.reprice_flag%TYPE INDEX BY BINARY_INTEGER;
1206: TYPE pricing_context_tab is table of
1207: SO_PRICE_LIST_LINES_115.pricing_context%TYPE INDEX BY BINARY_INTEGER;
1208: TYPE pricing_attribute1_tab is table of

Line 1205: TYPE reprice_flag_tab is table of SO_PRICE_LIST_LINES_115.reprice_flag%TYPE INDEX BY BINARY_INTEGER;

1201: TYPE method_code_tab is table of SO_PRICE_LIST_LINES_115.method_code%TYPE INDEX BY BINARY_INTEGER;
1202: TYPE list_price_tab is table of SO_PRICE_LIST_LINES_115.list_price%TYPE INDEX BY BINARY_INTEGER;
1203: TYPE pricing_rule_id_tab is table of
1204: SO_PRICE_LIST_LINES_115.pricing_rule_id%TYPE INDEX BY BINARY_INTEGER;
1205: TYPE reprice_flag_tab is table of SO_PRICE_LIST_LINES_115.reprice_flag%TYPE INDEX BY BINARY_INTEGER;
1206: TYPE pricing_context_tab is table of
1207: SO_PRICE_LIST_LINES_115.pricing_context%TYPE INDEX BY BINARY_INTEGER;
1208: TYPE pricing_attribute1_tab is table of
1209: SO_PRICE_LIST_LINES_115.pricing_attribute1%TYPE INDEX BY BINARY_INTEGER;

Line 1207: SO_PRICE_LIST_LINES_115.pricing_context%TYPE INDEX BY BINARY_INTEGER;

1203: TYPE pricing_rule_id_tab is table of
1204: SO_PRICE_LIST_LINES_115.pricing_rule_id%TYPE INDEX BY BINARY_INTEGER;
1205: TYPE reprice_flag_tab is table of SO_PRICE_LIST_LINES_115.reprice_flag%TYPE INDEX BY BINARY_INTEGER;
1206: TYPE pricing_context_tab is table of
1207: SO_PRICE_LIST_LINES_115.pricing_context%TYPE INDEX BY BINARY_INTEGER;
1208: TYPE pricing_attribute1_tab is table of
1209: SO_PRICE_LIST_LINES_115.pricing_attribute1%TYPE INDEX BY BINARY_INTEGER;
1210: TYPE pricing_attribute2_tab is table of
1211: SO_PRICE_LIST_LINES_115.pricing_attribute2%TYPE INDEX BY BINARY_INTEGER;

Line 1209: SO_PRICE_LIST_LINES_115.pricing_attribute1%TYPE INDEX BY BINARY_INTEGER;

1205: TYPE reprice_flag_tab is table of SO_PRICE_LIST_LINES_115.reprice_flag%TYPE INDEX BY BINARY_INTEGER;
1206: TYPE pricing_context_tab is table of
1207: SO_PRICE_LIST_LINES_115.pricing_context%TYPE INDEX BY BINARY_INTEGER;
1208: TYPE pricing_attribute1_tab is table of
1209: SO_PRICE_LIST_LINES_115.pricing_attribute1%TYPE INDEX BY BINARY_INTEGER;
1210: TYPE pricing_attribute2_tab is table of
1211: SO_PRICE_LIST_LINES_115.pricing_attribute2%TYPE INDEX BY BINARY_INTEGER;
1212: TYPE pricing_attribute3_tab is table of
1213: SO_PRICE_LIST_LINES_115.pricing_attribute3%TYPE INDEX BY BINARY_INTEGER;

Line 1211: SO_PRICE_LIST_LINES_115.pricing_attribute2%TYPE INDEX BY BINARY_INTEGER;

1207: SO_PRICE_LIST_LINES_115.pricing_context%TYPE INDEX BY BINARY_INTEGER;
1208: TYPE pricing_attribute1_tab is table of
1209: SO_PRICE_LIST_LINES_115.pricing_attribute1%TYPE INDEX BY BINARY_INTEGER;
1210: TYPE pricing_attribute2_tab is table of
1211: SO_PRICE_LIST_LINES_115.pricing_attribute2%TYPE INDEX BY BINARY_INTEGER;
1212: TYPE pricing_attribute3_tab is table of
1213: SO_PRICE_LIST_LINES_115.pricing_attribute3%TYPE INDEX BY BINARY_INTEGER;
1214: TYPE pricing_attribute4_tab is table of
1215: SO_PRICE_LIST_LINES_115.pricing_attribute4%TYPE INDEX BY BINARY_INTEGER;

Line 1213: SO_PRICE_LIST_LINES_115.pricing_attribute3%TYPE INDEX BY BINARY_INTEGER;

1209: SO_PRICE_LIST_LINES_115.pricing_attribute1%TYPE INDEX BY BINARY_INTEGER;
1210: TYPE pricing_attribute2_tab is table of
1211: SO_PRICE_LIST_LINES_115.pricing_attribute2%TYPE INDEX BY BINARY_INTEGER;
1212: TYPE pricing_attribute3_tab is table of
1213: SO_PRICE_LIST_LINES_115.pricing_attribute3%TYPE INDEX BY BINARY_INTEGER;
1214: TYPE pricing_attribute4_tab is table of
1215: SO_PRICE_LIST_LINES_115.pricing_attribute4%TYPE INDEX BY BINARY_INTEGER;
1216: TYPE pricing_attribute5_tab is table of
1217: SO_PRICE_LIST_LINES_115.pricing_attribute5%TYPE INDEX BY BINARY_INTEGER;

Line 1215: SO_PRICE_LIST_LINES_115.pricing_attribute4%TYPE INDEX BY BINARY_INTEGER;

1211: SO_PRICE_LIST_LINES_115.pricing_attribute2%TYPE INDEX BY BINARY_INTEGER;
1212: TYPE pricing_attribute3_tab is table of
1213: SO_PRICE_LIST_LINES_115.pricing_attribute3%TYPE INDEX BY BINARY_INTEGER;
1214: TYPE pricing_attribute4_tab is table of
1215: SO_PRICE_LIST_LINES_115.pricing_attribute4%TYPE INDEX BY BINARY_INTEGER;
1216: TYPE pricing_attribute5_tab is table of
1217: SO_PRICE_LIST_LINES_115.pricing_attribute5%TYPE INDEX BY BINARY_INTEGER;
1218: TYPE pricing_attribute6_tab is table of
1219: SO_PRICE_LIST_LINES_115.pricing_attribute6%TYPE INDEX BY BINARY_INTEGER;

Line 1217: SO_PRICE_LIST_LINES_115.pricing_attribute5%TYPE INDEX BY BINARY_INTEGER;

1213: SO_PRICE_LIST_LINES_115.pricing_attribute3%TYPE INDEX BY BINARY_INTEGER;
1214: TYPE pricing_attribute4_tab is table of
1215: SO_PRICE_LIST_LINES_115.pricing_attribute4%TYPE INDEX BY BINARY_INTEGER;
1216: TYPE pricing_attribute5_tab is table of
1217: SO_PRICE_LIST_LINES_115.pricing_attribute5%TYPE INDEX BY BINARY_INTEGER;
1218: TYPE pricing_attribute6_tab is table of
1219: SO_PRICE_LIST_LINES_115.pricing_attribute6%TYPE INDEX BY BINARY_INTEGER;
1220: TYPE pricing_attribute7_tab is table of
1221: SO_PRICE_LIST_LINES_115.pricing_attribute7%TYPE INDEX BY BINARY_INTEGER;

Line 1219: SO_PRICE_LIST_LINES_115.pricing_attribute6%TYPE INDEX BY BINARY_INTEGER;

1215: SO_PRICE_LIST_LINES_115.pricing_attribute4%TYPE INDEX BY BINARY_INTEGER;
1216: TYPE pricing_attribute5_tab is table of
1217: SO_PRICE_LIST_LINES_115.pricing_attribute5%TYPE INDEX BY BINARY_INTEGER;
1218: TYPE pricing_attribute6_tab is table of
1219: SO_PRICE_LIST_LINES_115.pricing_attribute6%TYPE INDEX BY BINARY_INTEGER;
1220: TYPE pricing_attribute7_tab is table of
1221: SO_PRICE_LIST_LINES_115.pricing_attribute7%TYPE INDEX BY BINARY_INTEGER;
1222: TYPE pricing_attribute8_tab is table of
1223: SO_PRICE_LIST_LINES_115.pricing_attribute8%TYPE INDEX BY BINARY_INTEGER;

Line 1221: SO_PRICE_LIST_LINES_115.pricing_attribute7%TYPE INDEX BY BINARY_INTEGER;

1217: SO_PRICE_LIST_LINES_115.pricing_attribute5%TYPE INDEX BY BINARY_INTEGER;
1218: TYPE pricing_attribute6_tab is table of
1219: SO_PRICE_LIST_LINES_115.pricing_attribute6%TYPE INDEX BY BINARY_INTEGER;
1220: TYPE pricing_attribute7_tab is table of
1221: SO_PRICE_LIST_LINES_115.pricing_attribute7%TYPE INDEX BY BINARY_INTEGER;
1222: TYPE pricing_attribute8_tab is table of
1223: SO_PRICE_LIST_LINES_115.pricing_attribute8%TYPE INDEX BY BINARY_INTEGER;
1224: TYPE pricing_attribute9_tab is table of
1225: SO_PRICE_LIST_LINES_115.pricing_attribute9%TYPE INDEX BY BINARY_INTEGER;

Line 1223: SO_PRICE_LIST_LINES_115.pricing_attribute8%TYPE INDEX BY BINARY_INTEGER;

1219: SO_PRICE_LIST_LINES_115.pricing_attribute6%TYPE INDEX BY BINARY_INTEGER;
1220: TYPE pricing_attribute7_tab is table of
1221: SO_PRICE_LIST_LINES_115.pricing_attribute7%TYPE INDEX BY BINARY_INTEGER;
1222: TYPE pricing_attribute8_tab is table of
1223: SO_PRICE_LIST_LINES_115.pricing_attribute8%TYPE INDEX BY BINARY_INTEGER;
1224: TYPE pricing_attribute9_tab is table of
1225: SO_PRICE_LIST_LINES_115.pricing_attribute9%TYPE INDEX BY BINARY_INTEGER;
1226: TYPE pricing_attribute10_tab is table of
1227: SO_PRICE_LIST_LINES_115.pricing_attribute10%TYPE INDEX BY BINARY_INTEGER;

Line 1225: SO_PRICE_LIST_LINES_115.pricing_attribute9%TYPE INDEX BY BINARY_INTEGER;

1221: SO_PRICE_LIST_LINES_115.pricing_attribute7%TYPE INDEX BY BINARY_INTEGER;
1222: TYPE pricing_attribute8_tab is table of
1223: SO_PRICE_LIST_LINES_115.pricing_attribute8%TYPE INDEX BY BINARY_INTEGER;
1224: TYPE pricing_attribute9_tab is table of
1225: SO_PRICE_LIST_LINES_115.pricing_attribute9%TYPE INDEX BY BINARY_INTEGER;
1226: TYPE pricing_attribute10_tab is table of
1227: SO_PRICE_LIST_LINES_115.pricing_attribute10%TYPE INDEX BY BINARY_INTEGER;
1228: TYPE pricing_attribute11_tab is table of
1229: SO_PRICE_LIST_LINES_115.pricing_attribute11%TYPE INDEX BY BINARY_INTEGER;

Line 1227: SO_PRICE_LIST_LINES_115.pricing_attribute10%TYPE INDEX BY BINARY_INTEGER;

1223: SO_PRICE_LIST_LINES_115.pricing_attribute8%TYPE INDEX BY BINARY_INTEGER;
1224: TYPE pricing_attribute9_tab is table of
1225: SO_PRICE_LIST_LINES_115.pricing_attribute9%TYPE INDEX BY BINARY_INTEGER;
1226: TYPE pricing_attribute10_tab is table of
1227: SO_PRICE_LIST_LINES_115.pricing_attribute10%TYPE INDEX BY BINARY_INTEGER;
1228: TYPE pricing_attribute11_tab is table of
1229: SO_PRICE_LIST_LINES_115.pricing_attribute11%TYPE INDEX BY BINARY_INTEGER;
1230: TYPE pricing_attribute12_tab is table of
1231: SO_PRICE_LIST_LINES_115.pricing_attribute12%TYPE INDEX BY BINARY_INTEGER;

Line 1229: SO_PRICE_LIST_LINES_115.pricing_attribute11%TYPE INDEX BY BINARY_INTEGER;

1225: SO_PRICE_LIST_LINES_115.pricing_attribute9%TYPE INDEX BY BINARY_INTEGER;
1226: TYPE pricing_attribute10_tab is table of
1227: SO_PRICE_LIST_LINES_115.pricing_attribute10%TYPE INDEX BY BINARY_INTEGER;
1228: TYPE pricing_attribute11_tab is table of
1229: SO_PRICE_LIST_LINES_115.pricing_attribute11%TYPE INDEX BY BINARY_INTEGER;
1230: TYPE pricing_attribute12_tab is table of
1231: SO_PRICE_LIST_LINES_115.pricing_attribute12%TYPE INDEX BY BINARY_INTEGER;
1232: TYPE pricing_attribute13_tab is table of
1233: SO_PRICE_LIST_LINES_115.pricing_attribute13%TYPE INDEX BY BINARY_INTEGER;

Line 1231: SO_PRICE_LIST_LINES_115.pricing_attribute12%TYPE INDEX BY BINARY_INTEGER;

1227: SO_PRICE_LIST_LINES_115.pricing_attribute10%TYPE INDEX BY BINARY_INTEGER;
1228: TYPE pricing_attribute11_tab is table of
1229: SO_PRICE_LIST_LINES_115.pricing_attribute11%TYPE INDEX BY BINARY_INTEGER;
1230: TYPE pricing_attribute12_tab is table of
1231: SO_PRICE_LIST_LINES_115.pricing_attribute12%TYPE INDEX BY BINARY_INTEGER;
1232: TYPE pricing_attribute13_tab is table of
1233: SO_PRICE_LIST_LINES_115.pricing_attribute13%TYPE INDEX BY BINARY_INTEGER;
1234: TYPE pricing_attribute14_tab is table of
1235: SO_PRICE_LIST_LINES_115.pricing_attribute14%TYPE INDEX BY BINARY_INTEGER;

Line 1233: SO_PRICE_LIST_LINES_115.pricing_attribute13%TYPE INDEX BY BINARY_INTEGER;

1229: SO_PRICE_LIST_LINES_115.pricing_attribute11%TYPE INDEX BY BINARY_INTEGER;
1230: TYPE pricing_attribute12_tab is table of
1231: SO_PRICE_LIST_LINES_115.pricing_attribute12%TYPE INDEX BY BINARY_INTEGER;
1232: TYPE pricing_attribute13_tab is table of
1233: SO_PRICE_LIST_LINES_115.pricing_attribute13%TYPE INDEX BY BINARY_INTEGER;
1234: TYPE pricing_attribute14_tab is table of
1235: SO_PRICE_LIST_LINES_115.pricing_attribute14%TYPE INDEX BY BINARY_INTEGER;
1236: TYPE pricing_attribute15_tab is table of
1237: SO_PRICE_LIST_LINES_115.pricing_attribute15%TYPE INDEX BY BINARY_INTEGER;

Line 1235: SO_PRICE_LIST_LINES_115.pricing_attribute14%TYPE INDEX BY BINARY_INTEGER;

1231: SO_PRICE_LIST_LINES_115.pricing_attribute12%TYPE INDEX BY BINARY_INTEGER;
1232: TYPE pricing_attribute13_tab is table of
1233: SO_PRICE_LIST_LINES_115.pricing_attribute13%TYPE INDEX BY BINARY_INTEGER;
1234: TYPE pricing_attribute14_tab is table of
1235: SO_PRICE_LIST_LINES_115.pricing_attribute14%TYPE INDEX BY BINARY_INTEGER;
1236: TYPE pricing_attribute15_tab is table of
1237: SO_PRICE_LIST_LINES_115.pricing_attribute15%TYPE INDEX BY BINARY_INTEGER;
1238: TYPE start_date_active_tab is table of
1239: SO_PRICE_LIST_LINES_115.start_date_active%TYPE INDEX BY BINARY_INTEGER;

Line 1237: SO_PRICE_LIST_LINES_115.pricing_attribute15%TYPE INDEX BY BINARY_INTEGER;

1233: SO_PRICE_LIST_LINES_115.pricing_attribute13%TYPE INDEX BY BINARY_INTEGER;
1234: TYPE pricing_attribute14_tab is table of
1235: SO_PRICE_LIST_LINES_115.pricing_attribute14%TYPE INDEX BY BINARY_INTEGER;
1236: TYPE pricing_attribute15_tab is table of
1237: SO_PRICE_LIST_LINES_115.pricing_attribute15%TYPE INDEX BY BINARY_INTEGER;
1238: TYPE start_date_active_tab is table of
1239: SO_PRICE_LIST_LINES_115.start_date_active%TYPE INDEX BY BINARY_INTEGER;
1240: TYPE end_date_active_tab is table of
1241: SO_PRICE_LIST_LINES_115.end_date_active%TYPE INDEX BY BINARY_INTEGER;

Line 1239: SO_PRICE_LIST_LINES_115.start_date_active%TYPE INDEX BY BINARY_INTEGER;

1235: SO_PRICE_LIST_LINES_115.pricing_attribute14%TYPE INDEX BY BINARY_INTEGER;
1236: TYPE pricing_attribute15_tab is table of
1237: SO_PRICE_LIST_LINES_115.pricing_attribute15%TYPE INDEX BY BINARY_INTEGER;
1238: TYPE start_date_active_tab is table of
1239: SO_PRICE_LIST_LINES_115.start_date_active%TYPE INDEX BY BINARY_INTEGER;
1240: TYPE end_date_active_tab is table of
1241: SO_PRICE_LIST_LINES_115.end_date_active%TYPE INDEX BY BINARY_INTEGER;
1242: TYPE context_tab is table of SO_PRICE_LIST_LINES_115.context%TYPE INDEX BY BINARY_INTEGER;
1243: TYPE attribute1_tab is table of SO_PRICE_LIST_LINES_115.attribute1%TYPE INDEX BY BINARY_INTEGER;

Line 1241: SO_PRICE_LIST_LINES_115.end_date_active%TYPE INDEX BY BINARY_INTEGER;

1237: SO_PRICE_LIST_LINES_115.pricing_attribute15%TYPE INDEX BY BINARY_INTEGER;
1238: TYPE start_date_active_tab is table of
1239: SO_PRICE_LIST_LINES_115.start_date_active%TYPE INDEX BY BINARY_INTEGER;
1240: TYPE end_date_active_tab is table of
1241: SO_PRICE_LIST_LINES_115.end_date_active%TYPE INDEX BY BINARY_INTEGER;
1242: TYPE context_tab is table of SO_PRICE_LIST_LINES_115.context%TYPE INDEX BY BINARY_INTEGER;
1243: TYPE attribute1_tab is table of SO_PRICE_LIST_LINES_115.attribute1%TYPE INDEX BY BINARY_INTEGER;
1244: TYPE attribute2_tab is table of SO_PRICE_LIST_LINES_115.attribute2%TYPE INDEX BY BINARY_INTEGER;
1245: TYPE attribute3_tab is table of SO_PRICE_LIST_LINES_115.attribute3%TYPE INDEX BY BINARY_INTEGER;

Line 1242: TYPE context_tab is table of SO_PRICE_LIST_LINES_115.context%TYPE INDEX BY BINARY_INTEGER;

1238: TYPE start_date_active_tab is table of
1239: SO_PRICE_LIST_LINES_115.start_date_active%TYPE INDEX BY BINARY_INTEGER;
1240: TYPE end_date_active_tab is table of
1241: SO_PRICE_LIST_LINES_115.end_date_active%TYPE INDEX BY BINARY_INTEGER;
1242: TYPE context_tab is table of SO_PRICE_LIST_LINES_115.context%TYPE INDEX BY BINARY_INTEGER;
1243: TYPE attribute1_tab is table of SO_PRICE_LIST_LINES_115.attribute1%TYPE INDEX BY BINARY_INTEGER;
1244: TYPE attribute2_tab is table of SO_PRICE_LIST_LINES_115.attribute2%TYPE INDEX BY BINARY_INTEGER;
1245: TYPE attribute3_tab is table of SO_PRICE_LIST_LINES_115.attribute3%TYPE INDEX BY BINARY_INTEGER;
1246: TYPE attribute4_tab is table of SO_PRICE_LIST_LINES_115.attribute4%TYPE INDEX BY BINARY_INTEGER;

Line 1243: TYPE attribute1_tab is table of SO_PRICE_LIST_LINES_115.attribute1%TYPE INDEX BY BINARY_INTEGER;

1239: SO_PRICE_LIST_LINES_115.start_date_active%TYPE INDEX BY BINARY_INTEGER;
1240: TYPE end_date_active_tab is table of
1241: SO_PRICE_LIST_LINES_115.end_date_active%TYPE INDEX BY BINARY_INTEGER;
1242: TYPE context_tab is table of SO_PRICE_LIST_LINES_115.context%TYPE INDEX BY BINARY_INTEGER;
1243: TYPE attribute1_tab is table of SO_PRICE_LIST_LINES_115.attribute1%TYPE INDEX BY BINARY_INTEGER;
1244: TYPE attribute2_tab is table of SO_PRICE_LIST_LINES_115.attribute2%TYPE INDEX BY BINARY_INTEGER;
1245: TYPE attribute3_tab is table of SO_PRICE_LIST_LINES_115.attribute3%TYPE INDEX BY BINARY_INTEGER;
1246: TYPE attribute4_tab is table of SO_PRICE_LIST_LINES_115.attribute4%TYPE INDEX BY BINARY_INTEGER;
1247: TYPE attribute5_tab is table of SO_PRICE_LIST_LINES_115.attribute5%TYPE INDEX BY BINARY_INTEGER;

Line 1244: TYPE attribute2_tab is table of SO_PRICE_LIST_LINES_115.attribute2%TYPE INDEX BY BINARY_INTEGER;

1240: TYPE end_date_active_tab is table of
1241: SO_PRICE_LIST_LINES_115.end_date_active%TYPE INDEX BY BINARY_INTEGER;
1242: TYPE context_tab is table of SO_PRICE_LIST_LINES_115.context%TYPE INDEX BY BINARY_INTEGER;
1243: TYPE attribute1_tab is table of SO_PRICE_LIST_LINES_115.attribute1%TYPE INDEX BY BINARY_INTEGER;
1244: TYPE attribute2_tab is table of SO_PRICE_LIST_LINES_115.attribute2%TYPE INDEX BY BINARY_INTEGER;
1245: TYPE attribute3_tab is table of SO_PRICE_LIST_LINES_115.attribute3%TYPE INDEX BY BINARY_INTEGER;
1246: TYPE attribute4_tab is table of SO_PRICE_LIST_LINES_115.attribute4%TYPE INDEX BY BINARY_INTEGER;
1247: TYPE attribute5_tab is table of SO_PRICE_LIST_LINES_115.attribute5%TYPE INDEX BY BINARY_INTEGER;
1248: TYPE attribute6_tab is table of SO_PRICE_LIST_LINES_115.attribute6%TYPE INDEX BY BINARY_INTEGER;

Line 1245: TYPE attribute3_tab is table of SO_PRICE_LIST_LINES_115.attribute3%TYPE INDEX BY BINARY_INTEGER;

1241: SO_PRICE_LIST_LINES_115.end_date_active%TYPE INDEX BY BINARY_INTEGER;
1242: TYPE context_tab is table of SO_PRICE_LIST_LINES_115.context%TYPE INDEX BY BINARY_INTEGER;
1243: TYPE attribute1_tab is table of SO_PRICE_LIST_LINES_115.attribute1%TYPE INDEX BY BINARY_INTEGER;
1244: TYPE attribute2_tab is table of SO_PRICE_LIST_LINES_115.attribute2%TYPE INDEX BY BINARY_INTEGER;
1245: TYPE attribute3_tab is table of SO_PRICE_LIST_LINES_115.attribute3%TYPE INDEX BY BINARY_INTEGER;
1246: TYPE attribute4_tab is table of SO_PRICE_LIST_LINES_115.attribute4%TYPE INDEX BY BINARY_INTEGER;
1247: TYPE attribute5_tab is table of SO_PRICE_LIST_LINES_115.attribute5%TYPE INDEX BY BINARY_INTEGER;
1248: TYPE attribute6_tab is table of SO_PRICE_LIST_LINES_115.attribute6%TYPE INDEX BY BINARY_INTEGER;
1249: TYPE attribute7_tab is table of SO_PRICE_LIST_LINES_115.attribute7%TYPE INDEX BY BINARY_INTEGER;

Line 1246: TYPE attribute4_tab is table of SO_PRICE_LIST_LINES_115.attribute4%TYPE INDEX BY BINARY_INTEGER;

1242: TYPE context_tab is table of SO_PRICE_LIST_LINES_115.context%TYPE INDEX BY BINARY_INTEGER;
1243: TYPE attribute1_tab is table of SO_PRICE_LIST_LINES_115.attribute1%TYPE INDEX BY BINARY_INTEGER;
1244: TYPE attribute2_tab is table of SO_PRICE_LIST_LINES_115.attribute2%TYPE INDEX BY BINARY_INTEGER;
1245: TYPE attribute3_tab is table of SO_PRICE_LIST_LINES_115.attribute3%TYPE INDEX BY BINARY_INTEGER;
1246: TYPE attribute4_tab is table of SO_PRICE_LIST_LINES_115.attribute4%TYPE INDEX BY BINARY_INTEGER;
1247: TYPE attribute5_tab is table of SO_PRICE_LIST_LINES_115.attribute5%TYPE INDEX BY BINARY_INTEGER;
1248: TYPE attribute6_tab is table of SO_PRICE_LIST_LINES_115.attribute6%TYPE INDEX BY BINARY_INTEGER;
1249: TYPE attribute7_tab is table of SO_PRICE_LIST_LINES_115.attribute7%TYPE INDEX BY BINARY_INTEGER;
1250: TYPE attribute8_tab is table of SO_PRICE_LIST_LINES_115.attribute8%TYPE INDEX BY BINARY_INTEGER;

Line 1247: TYPE attribute5_tab is table of SO_PRICE_LIST_LINES_115.attribute5%TYPE INDEX BY BINARY_INTEGER;

1243: TYPE attribute1_tab is table of SO_PRICE_LIST_LINES_115.attribute1%TYPE INDEX BY BINARY_INTEGER;
1244: TYPE attribute2_tab is table of SO_PRICE_LIST_LINES_115.attribute2%TYPE INDEX BY BINARY_INTEGER;
1245: TYPE attribute3_tab is table of SO_PRICE_LIST_LINES_115.attribute3%TYPE INDEX BY BINARY_INTEGER;
1246: TYPE attribute4_tab is table of SO_PRICE_LIST_LINES_115.attribute4%TYPE INDEX BY BINARY_INTEGER;
1247: TYPE attribute5_tab is table of SO_PRICE_LIST_LINES_115.attribute5%TYPE INDEX BY BINARY_INTEGER;
1248: TYPE attribute6_tab is table of SO_PRICE_LIST_LINES_115.attribute6%TYPE INDEX BY BINARY_INTEGER;
1249: TYPE attribute7_tab is table of SO_PRICE_LIST_LINES_115.attribute7%TYPE INDEX BY BINARY_INTEGER;
1250: TYPE attribute8_tab is table of SO_PRICE_LIST_LINES_115.attribute8%TYPE INDEX BY BINARY_INTEGER;
1251: TYPE attribute9_tab is table of SO_PRICE_LIST_LINES_115.attribute9%TYPE INDEX BY BINARY_INTEGER;

Line 1248: TYPE attribute6_tab is table of SO_PRICE_LIST_LINES_115.attribute6%TYPE INDEX BY BINARY_INTEGER;

1244: TYPE attribute2_tab is table of SO_PRICE_LIST_LINES_115.attribute2%TYPE INDEX BY BINARY_INTEGER;
1245: TYPE attribute3_tab is table of SO_PRICE_LIST_LINES_115.attribute3%TYPE INDEX BY BINARY_INTEGER;
1246: TYPE attribute4_tab is table of SO_PRICE_LIST_LINES_115.attribute4%TYPE INDEX BY BINARY_INTEGER;
1247: TYPE attribute5_tab is table of SO_PRICE_LIST_LINES_115.attribute5%TYPE INDEX BY BINARY_INTEGER;
1248: TYPE attribute6_tab is table of SO_PRICE_LIST_LINES_115.attribute6%TYPE INDEX BY BINARY_INTEGER;
1249: TYPE attribute7_tab is table of SO_PRICE_LIST_LINES_115.attribute7%TYPE INDEX BY BINARY_INTEGER;
1250: TYPE attribute8_tab is table of SO_PRICE_LIST_LINES_115.attribute8%TYPE INDEX BY BINARY_INTEGER;
1251: TYPE attribute9_tab is table of SO_PRICE_LIST_LINES_115.attribute9%TYPE INDEX BY BINARY_INTEGER;
1252: TYPE attribute10_tab is table of SO_PRICE_LIST_LINES_115.attribute10%TYPE INDEX BY BINARY_INTEGER;

Line 1249: TYPE attribute7_tab is table of SO_PRICE_LIST_LINES_115.attribute7%TYPE INDEX BY BINARY_INTEGER;

1245: TYPE attribute3_tab is table of SO_PRICE_LIST_LINES_115.attribute3%TYPE INDEX BY BINARY_INTEGER;
1246: TYPE attribute4_tab is table of SO_PRICE_LIST_LINES_115.attribute4%TYPE INDEX BY BINARY_INTEGER;
1247: TYPE attribute5_tab is table of SO_PRICE_LIST_LINES_115.attribute5%TYPE INDEX BY BINARY_INTEGER;
1248: TYPE attribute6_tab is table of SO_PRICE_LIST_LINES_115.attribute6%TYPE INDEX BY BINARY_INTEGER;
1249: TYPE attribute7_tab is table of SO_PRICE_LIST_LINES_115.attribute7%TYPE INDEX BY BINARY_INTEGER;
1250: TYPE attribute8_tab is table of SO_PRICE_LIST_LINES_115.attribute8%TYPE INDEX BY BINARY_INTEGER;
1251: TYPE attribute9_tab is table of SO_PRICE_LIST_LINES_115.attribute9%TYPE INDEX BY BINARY_INTEGER;
1252: TYPE attribute10_tab is table of SO_PRICE_LIST_LINES_115.attribute10%TYPE INDEX BY BINARY_INTEGER;
1253: TYPE attribute11_tab is table of SO_PRICE_LIST_LINES_115.attribute11%TYPE INDEX BY BINARY_INTEGER;

Line 1250: TYPE attribute8_tab is table of SO_PRICE_LIST_LINES_115.attribute8%TYPE INDEX BY BINARY_INTEGER;

1246: TYPE attribute4_tab is table of SO_PRICE_LIST_LINES_115.attribute4%TYPE INDEX BY BINARY_INTEGER;
1247: TYPE attribute5_tab is table of SO_PRICE_LIST_LINES_115.attribute5%TYPE INDEX BY BINARY_INTEGER;
1248: TYPE attribute6_tab is table of SO_PRICE_LIST_LINES_115.attribute6%TYPE INDEX BY BINARY_INTEGER;
1249: TYPE attribute7_tab is table of SO_PRICE_LIST_LINES_115.attribute7%TYPE INDEX BY BINARY_INTEGER;
1250: TYPE attribute8_tab is table of SO_PRICE_LIST_LINES_115.attribute8%TYPE INDEX BY BINARY_INTEGER;
1251: TYPE attribute9_tab is table of SO_PRICE_LIST_LINES_115.attribute9%TYPE INDEX BY BINARY_INTEGER;
1252: TYPE attribute10_tab is table of SO_PRICE_LIST_LINES_115.attribute10%TYPE INDEX BY BINARY_INTEGER;
1253: TYPE attribute11_tab is table of SO_PRICE_LIST_LINES_115.attribute11%TYPE INDEX BY BINARY_INTEGER;
1254: TYPE attribute12_tab is table of SO_PRICE_LIST_LINES_115. attribute12%TYPE INDEX BY BINARY_INTEGER;

Line 1251: TYPE attribute9_tab is table of SO_PRICE_LIST_LINES_115.attribute9%TYPE INDEX BY BINARY_INTEGER;

1247: TYPE attribute5_tab is table of SO_PRICE_LIST_LINES_115.attribute5%TYPE INDEX BY BINARY_INTEGER;
1248: TYPE attribute6_tab is table of SO_PRICE_LIST_LINES_115.attribute6%TYPE INDEX BY BINARY_INTEGER;
1249: TYPE attribute7_tab is table of SO_PRICE_LIST_LINES_115.attribute7%TYPE INDEX BY BINARY_INTEGER;
1250: TYPE attribute8_tab is table of SO_PRICE_LIST_LINES_115.attribute8%TYPE INDEX BY BINARY_INTEGER;
1251: TYPE attribute9_tab is table of SO_PRICE_LIST_LINES_115.attribute9%TYPE INDEX BY BINARY_INTEGER;
1252: TYPE attribute10_tab is table of SO_PRICE_LIST_LINES_115.attribute10%TYPE INDEX BY BINARY_INTEGER;
1253: TYPE attribute11_tab is table of SO_PRICE_LIST_LINES_115.attribute11%TYPE INDEX BY BINARY_INTEGER;
1254: TYPE attribute12_tab is table of SO_PRICE_LIST_LINES_115. attribute12%TYPE INDEX BY BINARY_INTEGER;
1255: TYPE attribute13_tab is table of SO_PRICE_LIST_LINES_115.attribute13%TYPE INDEX BY BINARY_INTEGER;

Line 1252: TYPE attribute10_tab is table of SO_PRICE_LIST_LINES_115.attribute10%TYPE INDEX BY BINARY_INTEGER;

1248: TYPE attribute6_tab is table of SO_PRICE_LIST_LINES_115.attribute6%TYPE INDEX BY BINARY_INTEGER;
1249: TYPE attribute7_tab is table of SO_PRICE_LIST_LINES_115.attribute7%TYPE INDEX BY BINARY_INTEGER;
1250: TYPE attribute8_tab is table of SO_PRICE_LIST_LINES_115.attribute8%TYPE INDEX BY BINARY_INTEGER;
1251: TYPE attribute9_tab is table of SO_PRICE_LIST_LINES_115.attribute9%TYPE INDEX BY BINARY_INTEGER;
1252: TYPE attribute10_tab is table of SO_PRICE_LIST_LINES_115.attribute10%TYPE INDEX BY BINARY_INTEGER;
1253: TYPE attribute11_tab is table of SO_PRICE_LIST_LINES_115.attribute11%TYPE INDEX BY BINARY_INTEGER;
1254: TYPE attribute12_tab is table of SO_PRICE_LIST_LINES_115. attribute12%TYPE INDEX BY BINARY_INTEGER;
1255: TYPE attribute13_tab is table of SO_PRICE_LIST_LINES_115.attribute13%TYPE INDEX BY BINARY_INTEGER;
1256: TYPE attribute14_tab is table of SO_PRICE_LIST_LINES_115.attribute14%TYPE INDEX BY BINARY_INTEGER;

Line 1253: TYPE attribute11_tab is table of SO_PRICE_LIST_LINES_115.attribute11%TYPE INDEX BY BINARY_INTEGER;

1249: TYPE attribute7_tab is table of SO_PRICE_LIST_LINES_115.attribute7%TYPE INDEX BY BINARY_INTEGER;
1250: TYPE attribute8_tab is table of SO_PRICE_LIST_LINES_115.attribute8%TYPE INDEX BY BINARY_INTEGER;
1251: TYPE attribute9_tab is table of SO_PRICE_LIST_LINES_115.attribute9%TYPE INDEX BY BINARY_INTEGER;
1252: TYPE attribute10_tab is table of SO_PRICE_LIST_LINES_115.attribute10%TYPE INDEX BY BINARY_INTEGER;
1253: TYPE attribute11_tab is table of SO_PRICE_LIST_LINES_115.attribute11%TYPE INDEX BY BINARY_INTEGER;
1254: TYPE attribute12_tab is table of SO_PRICE_LIST_LINES_115. attribute12%TYPE INDEX BY BINARY_INTEGER;
1255: TYPE attribute13_tab is table of SO_PRICE_LIST_LINES_115.attribute13%TYPE INDEX BY BINARY_INTEGER;
1256: TYPE attribute14_tab is table of SO_PRICE_LIST_LINES_115.attribute14%TYPE INDEX BY BINARY_INTEGER;
1257: TYPE attribute15_tab is table of SO_PRICE_LIST_LINES_115.attribute15%TYPE INDEX BY BINARY_INTEGER;

Line 1254: TYPE attribute12_tab is table of SO_PRICE_LIST_LINES_115. attribute12%TYPE INDEX BY BINARY_INTEGER;

1250: TYPE attribute8_tab is table of SO_PRICE_LIST_LINES_115.attribute8%TYPE INDEX BY BINARY_INTEGER;
1251: TYPE attribute9_tab is table of SO_PRICE_LIST_LINES_115.attribute9%TYPE INDEX BY BINARY_INTEGER;
1252: TYPE attribute10_tab is table of SO_PRICE_LIST_LINES_115.attribute10%TYPE INDEX BY BINARY_INTEGER;
1253: TYPE attribute11_tab is table of SO_PRICE_LIST_LINES_115.attribute11%TYPE INDEX BY BINARY_INTEGER;
1254: TYPE attribute12_tab is table of SO_PRICE_LIST_LINES_115. attribute12%TYPE INDEX BY BINARY_INTEGER;
1255: TYPE attribute13_tab is table of SO_PRICE_LIST_LINES_115.attribute13%TYPE INDEX BY BINARY_INTEGER;
1256: TYPE attribute14_tab is table of SO_PRICE_LIST_LINES_115.attribute14%TYPE INDEX BY BINARY_INTEGER;
1257: TYPE attribute15_tab is table of SO_PRICE_LIST_LINES_115.attribute15%TYPE INDEX BY BINARY_INTEGER;
1258:

Line 1255: TYPE attribute13_tab is table of SO_PRICE_LIST_LINES_115.attribute13%TYPE INDEX BY BINARY_INTEGER;

1251: TYPE attribute9_tab is table of SO_PRICE_LIST_LINES_115.attribute9%TYPE INDEX BY BINARY_INTEGER;
1252: TYPE attribute10_tab is table of SO_PRICE_LIST_LINES_115.attribute10%TYPE INDEX BY BINARY_INTEGER;
1253: TYPE attribute11_tab is table of SO_PRICE_LIST_LINES_115.attribute11%TYPE INDEX BY BINARY_INTEGER;
1254: TYPE attribute12_tab is table of SO_PRICE_LIST_LINES_115. attribute12%TYPE INDEX BY BINARY_INTEGER;
1255: TYPE attribute13_tab is table of SO_PRICE_LIST_LINES_115.attribute13%TYPE INDEX BY BINARY_INTEGER;
1256: TYPE attribute14_tab is table of SO_PRICE_LIST_LINES_115.attribute14%TYPE INDEX BY BINARY_INTEGER;
1257: TYPE attribute15_tab is table of SO_PRICE_LIST_LINES_115.attribute15%TYPE INDEX BY BINARY_INTEGER;
1258:
1259: /* pricing attribute specific tab types */

Line 1256: TYPE attribute14_tab is table of SO_PRICE_LIST_LINES_115.attribute14%TYPE INDEX BY BINARY_INTEGER;

1252: TYPE attribute10_tab is table of SO_PRICE_LIST_LINES_115.attribute10%TYPE INDEX BY BINARY_INTEGER;
1253: TYPE attribute11_tab is table of SO_PRICE_LIST_LINES_115.attribute11%TYPE INDEX BY BINARY_INTEGER;
1254: TYPE attribute12_tab is table of SO_PRICE_LIST_LINES_115. attribute12%TYPE INDEX BY BINARY_INTEGER;
1255: TYPE attribute13_tab is table of SO_PRICE_LIST_LINES_115.attribute13%TYPE INDEX BY BINARY_INTEGER;
1256: TYPE attribute14_tab is table of SO_PRICE_LIST_LINES_115.attribute14%TYPE INDEX BY BINARY_INTEGER;
1257: TYPE attribute15_tab is table of SO_PRICE_LIST_LINES_115.attribute15%TYPE INDEX BY BINARY_INTEGER;
1258:
1259: /* pricing attribute specific tab types */
1260:

Line 1257: TYPE attribute15_tab is table of SO_PRICE_LIST_LINES_115.attribute15%TYPE INDEX BY BINARY_INTEGER;

1253: TYPE attribute11_tab is table of SO_PRICE_LIST_LINES_115.attribute11%TYPE INDEX BY BINARY_INTEGER;
1254: TYPE attribute12_tab is table of SO_PRICE_LIST_LINES_115. attribute12%TYPE INDEX BY BINARY_INTEGER;
1255: TYPE attribute13_tab is table of SO_PRICE_LIST_LINES_115.attribute13%TYPE INDEX BY BINARY_INTEGER;
1256: TYPE attribute14_tab is table of SO_PRICE_LIST_LINES_115.attribute14%TYPE INDEX BY BINARY_INTEGER;
1257: TYPE attribute15_tab is table of SO_PRICE_LIST_LINES_115.attribute15%TYPE INDEX BY BINARY_INTEGER;
1258:
1259: /* pricing attribute specific tab types */
1260:
1261:

Line 1436: from so_price_list_lines_115 prl

1432: attribute15,
1433: price_list_line_id,
1434: NULL,
1435: 3
1436: from so_price_list_lines_115 prl
1437: where prl.price_list_id in ( select list_header_id
1438: from qp_LIST_headers_b
1439: where list_type_code = 'PRL')
1440: and not exists ( select null

Line 1504: so_price_list_lines_115 prl

1500: prl.price_list_line_id,
1501: 'AGR',
1502: 3
1503: from qp_list_headers_b qph,
1504: so_price_list_lines_115 prl
1505: where prl.price_list_id = qph.list_header_id
1506: and prl.price_list_id in ( select price_list_id
1507: from so_agreements_b)
1508: and not exists ( select null