DBA Data[Home] [Help]

APPS.OE_OE_PRICING_AVAILABILITY dependencies on QP_PREQ_LDETS_TMP_T

Line 3846: FROM qp_preq_ldets_tmp_t qpt, qp_list_lines b

3842: b.charge_subtype_code, b.benefit_qty, b.benefit_uom_code,
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