[Home] [Help]
3786: qpt.pricing_status_text, qpt.hold_code, qpt.hold_text,
3787: qpt.price_request_code, qpt.pricing_effective_date, qpt.extended_price,
3788: qpt.order_uom_selling_price
3789: FROM qp_preq_lines_tmp_t qpt
3790: WHERE qp_java_engine_util_pub.java_engine_running = 'N'
3791: AND request_id = NVL (SYS_CONTEXT ('qp_context', 'request_id'), 1)
3792: UNION ALL
3793: SELECT qpt.line_index, qpt.line_id, qpt.price_list_header_id,
3794: qpt.line_type_code, qpt.line_quantity, qpt.line_uom_code,
3801: qpt.pricing_status_text, qpt.hold_code, qpt.hold_text,
3802: qpt.price_request_code, qpt.pricing_effective_date, qpt.extended_price,
3803: qpt.order_uom_selling_price
3804: FROM qp_int_lines_t qpt
3805: WHERE qp_java_engine_util_pub.java_engine_running = 'Y'
3806: AND request_id = NVL (SYS_CONTEXT ('qp_context', 'request_id'), -9999);
3807:
3808:
3809:
3868: b.proration_type_code, b.include_on_returns_flag,
3869: b.rebate_transaction_type_code, b.number_expiration_periods,
3870: b.expiration_period_uom, b.comments
3871: FROM qp_preq_ldets_tmp_t qpt, qp_list_lines b
3872: WHERE qp_java_engine_util_pub.java_engine_running = 'N'
3873: AND qpt.request_id = NVL (SYS_CONTEXT ('QP_CONTEXT', 'REQUEST_ID'), 1)
3874: AND qpt.created_from_list_line_id = b.list_line_id
3875: AND qpt.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
3876: UNION ALL
3895: b.proration_type_code, b.include_on_returns_flag,
3896: b.rebate_transaction_type_code, b.number_expiration_periods,
3897: b.expiration_period_uom, b.comments
3898: FROM qp_int_ldets_t qpt, qp_list_lines b
3899: WHERE qp_java_engine_util_pub.java_engine_running = 'Y'
3900: AND qpt.request_id = NVL (SYS_CONTEXT ('QP_CONTEXT', 'REQUEST_ID'), -9999)
3901: AND qpt.created_from_list_line_id = b.list_line_id
3902: AND qpt.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW;
3903: