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 671: FROM qp_List_Lines_v

667:
668: -- Above Cursor is modified as below by Vijay Shankar for Bug# 3515883
669: CURSOR C_PRICE_LIST_INFO (p_list_header_id NUMBER, p_inv_item_id IN VARCHAR2) IS
670: SELECT product_attr_value, list_header_id
671: FROM qp_List_Lines_v
672: WHERE List_header_id = p_list_header_id
673: AND product_attribute_context = 'ITEM'
674: AND product_attr_value = p_inv_item_id
675: AND NVL( Start_Date_Active, SYSDATE - 1 ) <= SYSDATE

Line 680: FROM QP_LIST_LINES b, qp_pricing_attributes c

676: AND NVL( End_Date_Active, SYSDATE + 1 ) >= SYSDATE;
677:
678: CURSOR LIST_PRICE(ID NUMBER,UNT_CODE VARCHAR2, PRICE_LIST NUMBER,TRDATE DATE) IS
679: SELECT b.operand list_price
680: FROM QP_LIST_LINES b, qp_pricing_attributes c
681: WHERE c.PRODUCT_ATTR_VALUE = TO_CHAR(Id)
682: AND c.product_uom_code = UNT_CODE
683: AND b.list_header_id = PRICE_LIST
684: AND c.list_line_id = b.list_line_id

Line 714: FROM QP_LIST_LINES b, qp_pricing_attributes c

710: AND CUSTOMER_ID = v_cust_id;
711:
712: CURSOR GET_ASSESS_LIST (INVENT NUMBER,UNT VARCHAR2 ,NEW_NO NUMBER, ADATE DATE) IS
713: SELECT b.operand list_price
714: FROM QP_LIST_LINES b, qp_pricing_attributes c
715: WHERE c.PRODUCT_ATTR_VALUE = TO_CHAR(INVENT)
716: AND c.product_uom_code = UNT
717: AND b.list_header_id = NEW_NO
718: AND c.list_line_id = b.list_line_id

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

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

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

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