DBA Data[Home] [Help]

APPS.QP_COPY_PRICELIST_PVT dependencies on QP_LIST_LINES_S

Line 770: SELECT qp_list_lines_s.nextval

766: qp_discount_lines_cur (qp_from_discounts_rec.list_header_id)
767: LOOP
768:
769: --Get New Discount Line Id
770: SELECT qp_list_lines_s.nextval
771: INTO l_new_discount_line_id
772: FROM dual;
773:
774: --Insert Discount Line

Line 1290: substitution_context QP_LIST_LINES.substitution_context%TYPE,

1286: inventory_item_id QP_LIST_LINES.inventory_item_id%TYPE,
1287: organization_id QP_LIST_LINES.organization_id%TYPE,
1288: related_item_id QP_LIST_LINES.related_item_id%TYPE,
1289: relationship_type_id QP_LIST_LINES.relationship_type_id%TYPE,
1290: substitution_context QP_LIST_LINES.substitution_context%TYPE,
1291: substitution_attribute QP_LIST_LINES.substitution_attribute%TYPE,
1292: substitution_value QP_LIST_LINES.substitution_value%TYPE,
1293: revision QP_LIST_LINES.revision%TYPE,
1294: revision_date QP_LIST_LINES.revision_date%TYPE,

Line 1291: substitution_attribute QP_LIST_LINES.substitution_attribute%TYPE,

1287: organization_id QP_LIST_LINES.organization_id%TYPE,
1288: related_item_id QP_LIST_LINES.related_item_id%TYPE,
1289: relationship_type_id QP_LIST_LINES.relationship_type_id%TYPE,
1290: substitution_context QP_LIST_LINES.substitution_context%TYPE,
1291: substitution_attribute QP_LIST_LINES.substitution_attribute%TYPE,
1292: substitution_value QP_LIST_LINES.substitution_value%TYPE,
1293: revision QP_LIST_LINES.revision%TYPE,
1294: revision_date QP_LIST_LINES.revision_date%TYPE,
1295: revision_reason_code QP_LIST_LINES.revision_reason_code%TYPE,

Line 1292: substitution_value QP_LIST_LINES.substitution_value%TYPE,

1288: related_item_id QP_LIST_LINES.related_item_id%TYPE,
1289: relationship_type_id QP_LIST_LINES.relationship_type_id%TYPE,
1290: substitution_context QP_LIST_LINES.substitution_context%TYPE,
1291: substitution_attribute QP_LIST_LINES.substitution_attribute%TYPE,
1292: substitution_value QP_LIST_LINES.substitution_value%TYPE,
1293: revision QP_LIST_LINES.revision%TYPE,
1294: revision_date QP_LIST_LINES.revision_date%TYPE,
1295: revision_reason_code QP_LIST_LINES.revision_reason_code%TYPE,
1296: context QP_LIST_LINES.context%TYPE,

Line 1325: start_date_active QP_LIST_LINES.start_date_active%TYPE,

1321: print_on_invoice_flag QP_LIST_LINES.print_on_invoice_flag%TYPE,
1322: rebate_transaction_type_code QP_LIST_LINES.rebate_transaction_type_code%TYPE,
1323: estim_accrual_rate QP_LIST_LINES.estim_accrual_rate%TYPE,
1324: generate_using_formula_id QP_LIST_LINES.generate_using_formula_id%TYPE,
1325: start_date_active QP_LIST_LINES.start_date_active%TYPE,
1326: end_date_active QP_LIST_LINES.end_date_active%TYPE,
1327: reprice_flag QP_LIST_LINES.reprice_flag%TYPE,
1328: accrual_flag QP_LIST_LINES.accrual_flag%TYPE,
1329: pricing_group_sequence QP_LIST_LINES.pricing_group_sequence%TYPE,

Line 2214: SELECT qp_list_lines_s.nextval

2210:
2211:
2212: -- Get next list_line_id
2213:
2214: SELECT qp_list_lines_s.nextval
2215: INTO l_new_list_line_id
2216: FROM dual;
2217:
2218: INSERT INTO qp_list_lines