eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_PRICE_ADJUSTMENTS_PKG dependencies on QP_LDETS_V

Line 1404: FROM QP_LDETS_V LDUP

1400:
1401: CURSOR upd_line_det_cur IS
1402: SELECT ADJ.price_adjustment_id
1403: ,LDUP.line_detail_index
1404: FROM QP_LDETS_V LDUP
1405: ,QP_PREQ_LINES_TMP QLUP
1406: ,PO_PRICE_ADJUSTMENTS_DRAFT ADJ
1407: WHERE LDUP.process_code IN (QP_PREQ_GRP.G_STATUS_NEW, QP_PREQ_GRP.G_STATUS_UPDATED)
1408: AND LDUP.list_line_id = ADJ.list_line_id

Line 1634: FROM qp_ldets_v LD

1630: -- AND QPP.pricing_phase_id = QEP.pricing_phase_id
1631: -- AND NVL(QPP.user_freeze_override_flag, QPP.freeze_override_flag)
1632: -- = decode(l_price_flag, 'Y', nvl(QPP.user_freeze_override_flag, QPP.freeze_override_flag), 'P', 'Y'))
1633: AND ADJD.list_line_id NOT IN (SELECT LD.list_line_id
1634: FROM qp_ldets_v LD
1635: WHERE LD.line_index = l_line_index
1636: AND LD.process_code IN (QP_PREQ_GRP.G_STATUS_UPDATED
1637: ,QP_PREQ_GRP.G_STATUS_UNCHANGED
1638: ,QP_PREQ_GRP.G_STATUS_NEW)

Line 1815: FROM QP_LDETS_v LDETS

1811: , LDETS.modifier_level_code
1812: , LDETS.price_break_type_code
1813: , LDETS.include_on_returns_flag
1814: , ADJD.lock_control + 1
1815: FROM QP_LDETS_v LDETS
1816: WHERE ldets.line_detail_index = p_line_detail_index
1817: )
1818: WHERE ADJD.draft_id = p_draft_id --For now draft_id in this place can never be null, but this condition needs to be changed or removed if null value is allowed in draft_id
1819: AND ADJD.price_adjustment_id = p_price_adjustment_id

Line 2059: FROM QP_LDETS_v LDETS

2055: , NULL -- AC_ATTRIBUTE15
2056: , LDETS.operand_value -- OPERAND_PER_PQTY
2057: , LDETS.adjustment_amount -- ADJUSTED_AMOUNT_PER_PQTY
2058: , 1 -- LOCK_CONTROL
2059: FROM QP_LDETS_v LDETS
2060: , QP_PREQ_LINES_TMP QLINE
2061: , QP_LIST_HEADERS_B QH
2062: WHERE LDETS.list_header_id = QH.list_header_id
2063: AND LDETS.process_code = QP_PREQ_GRP.G_STATUS_NEW

Line 2132: , QP_LDETS_V LDETS

2128: CURSOR refresh_attribs_cur IS
2129: SELECT ADJ.price_adjustment_id, ldets.line_detail_index
2130: FROM QP_PREQ_LINES_TMP QPL
2131: , PO_PRICE_ADJUSTMENTS_DRAFT ADJ
2132: , QP_LDETS_V LDETS
2133: WHERE LDETS.list_line_id = ADJ.list_line_id
2134: AND ADJ.draft_id = p_draft_id --For now draft_id in this place can never be null, but this condition needs to be changed or removed if null value is allowed in draft_id
2135: AND LDETS.line_index = QPL.line_index
2136: AND ADJ.pricing_phase_id IN (SELECT QEP.pricing_phase_id

Line 2309: , QP_LDETS_v LDETS

2305: 'QP_ATTR_DEFNS_PRICING')
2306: , PO_PRICE_ADJ_ATTRIBS_S.nextval
2307: , 1
2308: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT
2309: , QP_LDETS_v LDETS
2310: , PO_PRICE_ADJUSTMENTS_DRAFT ADJ
2311: , QP_PREQ_LINES_TMP QPLINE
2312: WHERE ADJ.po_header_id = p_order_header_id
2313: AND QPLAT.pricing_status_code = QP_PREQ_PUB.G_STATUS_NEW