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.JAI_AR_SUP_TRX_PKG dependencies on QP_LIST_LINES

Line 599: FROM qp_List_Lines_v

595:
596: -- Above Cursor is modified as below by Vijay Shankar for Bug# 3515883
597: CURSOR C_PRICE_LIST_INFO (p_list_header_id NUMBER, p_inv_item_id IN VARCHAR2) IS
598: SELECT product_attr_value, list_header_id
599: FROM qp_List_Lines_v
600: WHERE List_header_id = p_list_header_id
601: AND product_attribute_context = 'ITEM'
602: AND product_attr_value = p_inv_item_id
603: AND NVL( Start_Date_Active, SYSDATE - 1 ) <= SYSDATE

Line 608: FROM QP_LIST_LINES b, qp_pricing_attributes c

604: AND NVL( End_Date_Active, SYSDATE + 1 ) >= SYSDATE;
605:
606: CURSOR LIST_PRICE(ID NUMBER,UNT_CODE VARCHAR2, PRICE_LIST NUMBER,TRDATE DATE) IS
607: SELECT b.operand list_price
608: FROM QP_LIST_LINES b, qp_pricing_attributes c
609: WHERE c.PRODUCT_ATTR_VALUE = TO_CHAR(Id)
610: AND c.product_uom_code = UNT_CODE
611: AND b.list_header_id = PRICE_LIST
612: AND c.list_line_id = b.list_line_id

Line 642: FROM QP_LIST_LINES b, qp_pricing_attributes c

638: AND CUSTOMER_ID = v_cust_id;
639:
640: CURSOR GET_ASSESS_LIST (INVENT NUMBER,UNT VARCHAR2 ,NEW_NO NUMBER, ADATE DATE) IS
641: SELECT b.operand list_price
642: FROM QP_LIST_LINES b, qp_pricing_attributes c
643: WHERE c.PRODUCT_ATTR_VALUE = TO_CHAR(INVENT)
644: AND c.product_uom_code = UNT
645: AND b.list_header_id = NEW_NO
646: AND c.list_line_id = b.list_line_id

Line 749: - Cursor C_PRICE_LIST_INFO is modified to use qp_list_lines_v View instead of qp_list_lines and qp_pricing_attributes tables.

745: 4. 28/03/2004 Vijay Shankar for bug # 3515883, Version: 619.1
746: - modified cursor GET_INV_LINE to filter out Modifier lines from RA_CUSTOMER_TRX_LINES_ALL table and added a
747: seperate code that reduces/adds discounts/surcharges from actual item price.
748: Added Cursor c_adjustment_details and required variables for discounts/surchages calculation
749: - Cursor C_PRICE_LIST_INFO is modified to use qp_list_lines_v View instead of qp_list_lines and qp_pricing_attributes tables.
750: Added inventory_item_id, Start and end date checks to where clause on qp_list_lines_v
751: - Query to fetch details from JAI_OM_WSH_LINES_ALL is modified by adding Order_line_id filter.
752: Also removed the usage of RA_CUSTOMER_TRX_LINES_ALL table from the query which is redundant
753:

Line 750: Added inventory_item_id, Start and end date checks to where clause on qp_list_lines_v

746: - modified cursor GET_INV_LINE to filter out Modifier lines from RA_CUSTOMER_TRX_LINES_ALL table and added a
747: seperate code that reduces/adds discounts/surcharges from actual item price.
748: Added Cursor c_adjustment_details and required variables for discounts/surchages calculation
749: - Cursor C_PRICE_LIST_INFO is modified to use qp_list_lines_v View instead of qp_list_lines and qp_pricing_attributes tables.
750: Added inventory_item_id, Start and end date checks to where clause on qp_list_lines_v
751: - Query to fetch details from JAI_OM_WSH_LINES_ALL is modified by adding Order_line_id filter.
752: Also removed the usage of RA_CUSTOMER_TRX_LINES_ALL table from the query which is redundant
753:
754: 5. 15/03/2005 Bug 4224466. Added by LGOPALSA. Version 115.2