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_GENERAL_PKG dependencies on QP_PRICING_ATTRIBUTES

Line 665: qp_pricing_attributes c

661: c.product_uom_code list_price_uom_code
662: FROM
663: JAI_CMN_CUS_ADDRESSES a,
664: qp_list_lines b,
665: qp_pricing_attributes c
666: WHERE
667: a.customer_id = p_party_id AND
668: a.address_id = p_address_id AND
669: a.vat_price_list_id = b.LIST_header_ID AND

Line 693: qp_pricing_attributes c

689: c.product_uom_code list_price_uom_code
690: FROM
691: JAI_CMN_CUS_ADDRESSES a,
692: qp_list_lines b,
693: qp_pricing_attributes c
694: WHERE
695: a.customer_id = p_party_id AND
696: a.address_id = p_address_id AND
697: a.vat_price_list_id = b.list_header_id AND

Line 717: qp_pricing_attributes c

713: c.product_uom_code list_price_uom_code
714: FROM
715: JAI_CMN_CUS_ADDRESSES a,
716: qp_list_lines b,
717: qp_pricing_attributes c
718: WHERE
719: a.customer_id = p_party_id AND
720: a.address_id = p_address_id AND
721: a.vat_price_list_id = b.LIST_header_ID AND

Line 747: qp_pricing_attributes c

743: c.product_uom_code list_price_uom_code
744: FROM
745: JAI_CMN_VENDOR_SITES a,
746: qp_list_lines b,
747: qp_pricing_attributes c
748: WHERE
749: a.vendor_id = p_vendor_id AND
750: a.vendor_site_id = p_address_id AND
751: a.vat_price_list_id = b.LIST_header_ID AND

Line 776: qp_pricing_attributes c

772: c.product_uom_code list_price_uom_code
773: FROM
774: JAI_CMN_VENDOR_SITES a,
775: qp_list_lines b,
776: qp_pricing_attributes c
777: WHERE
778: a.vendor_id = p_vendor_id AND
779: a.vendor_site_id = p_address_id AND
780: a.vat_price_list_id = b.list_header_id AND

Line 800: qp_pricing_attributes c

796: c.product_uom_code list_price_uom_code
797: FROM
798: JAI_CMN_VENDOR_SITES a,
799: qp_list_lines b,
800: qp_pricing_attributes c
801: WHERE
802: a.vendor_id = p_vendor_id AND
803: a.vendor_site_id = p_address_id AND
804: a.vat_price_list_id = b.LIST_header_ID AND

Line 810: v_primary_uom_code qp_pricing_attributes.product_uom_code%type;

806: c.PRODUCT_ATTR_VALUE = TO_CHAR(p_inventory_item_id) AND
807: NVL(b.end_date_active,SYSDATE) >= p_ordered_date;
808:
809: --------------------------------end, cursors for vendor--------------------------------------------------
810: v_primary_uom_code qp_pricing_attributes.product_uom_code%type;
811: v_other_uom_code qp_pricing_attributes.product_uom_code%type;
812:
813: v_debug CHAR(1); -- := 'N'; --rpokkula for File.Sql.35
814: v_address_id NUMBER;

Line 811: v_other_uom_code qp_pricing_attributes.product_uom_code%type;

807: NVL(b.end_date_active,SYSDATE) >= p_ordered_date;
808:
809: --------------------------------end, cursors for vendor--------------------------------------------------
810: v_primary_uom_code qp_pricing_attributes.product_uom_code%type;
811: v_other_uom_code qp_pricing_attributes.product_uom_code%type;
812:
813: v_debug CHAR(1); -- := 'N'; --rpokkula for File.Sql.35
814: v_address_id NUMBER;
815: v_assessable_value NUMBER;