[Home] [Help]
3761: qpt.pricing_status_text, qpt.hold_code, qpt.hold_text,
3762: qpt.price_request_code, qpt.pricing_effective_date, qpt.extended_price,
3763: qpt.order_uom_selling_price
3764: FROM qp_preq_lines_tmp_t qpt
3765: WHERE qp_java_engine_util_pub.java_engine_running = 'N'
3766: AND request_id = NVL (SYS_CONTEXT ('qp_context', 'request_id'), 1)
3767: UNION ALL
3768: SELECT qpt.line_index, qpt.line_id, qpt.price_list_header_id,
3769: qpt.line_type_code, qpt.line_quantity, qpt.line_uom_code,
3776: qpt.pricing_status_text, qpt.hold_code, qpt.hold_text,
3777: qpt.price_request_code, qpt.pricing_effective_date, qpt.extended_price,
3778: qpt.order_uom_selling_price
3779: FROM qp_int_lines_t qpt
3780: WHERE qp_java_engine_util_pub.java_engine_running = 'Y'
3781: AND request_id = NVL (SYS_CONTEXT ('qp_context', 'request_id'), -9999);
3782:
3783:
3784:
3843: b.proration_type_code, b.include_on_returns_flag,
3844: b.rebate_transaction_type_code, b.number_expiration_periods,
3845: b.expiration_period_uom, b.comments
3846: FROM qp_preq_ldets_tmp_t qpt, qp_list_lines b
3847: WHERE qp_java_engine_util_pub.java_engine_running = 'N'
3848: AND qpt.request_id = NVL (SYS_CONTEXT ('QP_CONTEXT', 'REQUEST_ID'), 1)
3849: AND qpt.created_from_list_line_id = b.list_line_id
3850: AND qpt.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
3851: UNION ALL
3870: b.proration_type_code, b.include_on_returns_flag,
3871: b.rebate_transaction_type_code, b.number_expiration_periods,
3872: b.expiration_period_uom, b.comments
3873: FROM qp_int_ldets_t qpt, qp_list_lines b
3874: WHERE qp_java_engine_util_pub.java_engine_running = 'Y'
3875: AND qpt.request_id = NVL (SYS_CONTEXT ('QP_CONTEXT', 'REQUEST_ID'), -9999)
3876: AND qpt.created_from_list_line_id = b.list_line_id
3877: AND qpt.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW;
3878: