DBA Data[Home] [Help]

APPS.QP_COPY_PRICELIST_PVT dependencies on QP_LIST_LINES_S

Line 779: SELECT qp_list_lines_s.nextval

775: qp_discount_lines_cur (qp_from_discounts_rec.list_header_id)
776: LOOP
777:
778: --Get New Discount Line Id
779: SELECT qp_list_lines_s.nextval
780: INTO l_new_discount_line_id
781: FROM dual;
782:
783: --Insert Discount Line

Line 1472: substitution_context QP_LIST_LINES.substitution_context%TYPE,

1468: inventory_item_id QP_LIST_LINES.inventory_item_id%TYPE,
1469: organization_id QP_LIST_LINES.organization_id%TYPE,
1470: related_item_id QP_LIST_LINES.related_item_id%TYPE,
1471: relationship_type_id QP_LIST_LINES.relationship_type_id%TYPE,
1472: substitution_context QP_LIST_LINES.substitution_context%TYPE,
1473: substitution_attribute QP_LIST_LINES.substitution_attribute%TYPE,
1474: substitution_value QP_LIST_LINES.substitution_value%TYPE,
1475: revision QP_LIST_LINES.revision%TYPE,
1476: revision_date QP_LIST_LINES.revision_date%TYPE,

Line 1473: substitution_attribute QP_LIST_LINES.substitution_attribute%TYPE,

1469: organization_id QP_LIST_LINES.organization_id%TYPE,
1470: related_item_id QP_LIST_LINES.related_item_id%TYPE,
1471: relationship_type_id QP_LIST_LINES.relationship_type_id%TYPE,
1472: substitution_context QP_LIST_LINES.substitution_context%TYPE,
1473: substitution_attribute QP_LIST_LINES.substitution_attribute%TYPE,
1474: substitution_value QP_LIST_LINES.substitution_value%TYPE,
1475: revision QP_LIST_LINES.revision%TYPE,
1476: revision_date QP_LIST_LINES.revision_date%TYPE,
1477: revision_reason_code QP_LIST_LINES.revision_reason_code%TYPE,

Line 1474: substitution_value QP_LIST_LINES.substitution_value%TYPE,

1470: related_item_id QP_LIST_LINES.related_item_id%TYPE,
1471: relationship_type_id QP_LIST_LINES.relationship_type_id%TYPE,
1472: substitution_context QP_LIST_LINES.substitution_context%TYPE,
1473: substitution_attribute QP_LIST_LINES.substitution_attribute%TYPE,
1474: substitution_value QP_LIST_LINES.substitution_value%TYPE,
1475: revision QP_LIST_LINES.revision%TYPE,
1476: revision_date QP_LIST_LINES.revision_date%TYPE,
1477: revision_reason_code QP_LIST_LINES.revision_reason_code%TYPE,
1478: context QP_LIST_LINES.context%TYPE,

Line 1507: start_date_active QP_LIST_LINES.start_date_active%TYPE,

1503: print_on_invoice_flag QP_LIST_LINES.print_on_invoice_flag%TYPE,
1504: rebate_transaction_type_code QP_LIST_LINES.rebate_transaction_type_code%TYPE,
1505: estim_accrual_rate QP_LIST_LINES.estim_accrual_rate%TYPE,
1506: generate_using_formula_id QP_LIST_LINES.generate_using_formula_id%TYPE,
1507: start_date_active QP_LIST_LINES.start_date_active%TYPE,
1508: end_date_active QP_LIST_LINES.end_date_active%TYPE,
1509: reprice_flag QP_LIST_LINES.reprice_flag%TYPE,
1510: accrual_flag QP_LIST_LINES.accrual_flag%TYPE,
1511: pricing_group_sequence QP_LIST_LINES.pricing_group_sequence%TYPE,

Line 2397: SELECT qp_list_lines_s.nextval

2393:
2394:
2395: -- Get next list_line_id
2396:
2397: SELECT qp_list_lines_s.nextval
2398: INTO l_new_list_line_id
2399: FROM dual;
2400:
2401: INSERT INTO qp_list_lines