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 JAI_CMN_CUS_ADDRESSES

Line 688: JAI_CMN_CUS_ADDRESSES a,

684: SELECT
685: b.operand list_price,
686: c.product_uom_code list_price_uom_code
687: FROM
688: JAI_CMN_CUS_ADDRESSES a,
689: qp_list_lines b,
690: qp_pricing_attributes c
691: WHERE
692: a.customer_id = p_party_id AND

Line 716: JAI_CMN_CUS_ADDRESSES a,

712: SELECT
713: b.operand list_price,
714: c.product_uom_code list_price_uom_code
715: FROM
716: JAI_CMN_CUS_ADDRESSES a,
717: qp_list_lines b,
718: qp_pricing_attributes c
719: WHERE
720: a.customer_id = p_party_id AND

Line 740: JAI_CMN_CUS_ADDRESSES a,

736: SELECT
737: b.operand list_price,
738: c.product_uom_code list_price_uom_code
739: FROM
740: JAI_CMN_CUS_ADDRESSES a,
741: qp_list_lines b,
742: qp_pricing_attributes c
743: WHERE
744: a.customer_id = p_party_id AND

Line 778: from qp_list_headers qlh, JAI_CMN_CUS_ADDRESSES a

774: qlhb.list_header_id = b.list_header_id AND /* Added for bug#16288090 */
775: p_ordered_date BETWEEN nvl( b.start_date_active, p_ordered_date)
776: AND nvl( b.end_date_active, SYSDATE) AND
777: EXISTS ( Select 1
778: from qp_list_headers qlh, JAI_CMN_CUS_ADDRESSES a
779: where qlh.list_header_id = b.list_header_id
780: and a.customer_id = p_party_id
781: AND a.address_id = p_address_id
782: AND a.vat_price_list_id = b.LIST_header_ID

Line 811: from qp_list_headers qlh, JAI_CMN_CUS_ADDRESSES a

807: trunc(nvl(b.end_date_active,sysdate)) >= trunc(p_ordered_date) AND
808: qlhb.list_header_id = b.list_header_id AND /* Added for bug#16288090 */
809: nvl(qlhb.active_flag,'N') = 'Y' AND /*added for bug#16288090*/
810: exists ( select 1
811: from qp_list_headers qlh, JAI_CMN_CUS_ADDRESSES a
812: where a.customer_id = p_party_id AND
813: a.address_id = p_address_id AND
814: qlh.list_header_id = b.list_header_id AND
815: a.vat_price_list_id = b.list_header_id AND

Line 845: from qp_list_headers qlh, JAI_CMN_CUS_ADDRESSES a

841: NVL(qlhb.end_date_active,SYSDATE) >= p_ordered_date AND
842: NVL(qlhb.active_flag,'N') = 'Y' AND /*Added for bug#16288090*/
843: NVL(b.end_date_active,SYSDATE) >= p_ordered_date AND
844: EXISTS ( select 1
845: from qp_list_headers qlh, JAI_CMN_CUS_ADDRESSES a
846: WHERE a.customer_id = p_party_id AND
847: a.address_id = p_address_id AND
848: qlh.list_header_id = b.list_header_id AND
849: a.vat_price_list_id = b.LIST_header_ID AND

Line 1000: jai_cmn_cus_addresses a

996: b.operand list_price
997: , c.product_uom_code list_price_uom_code ,
998: qlhb.currency_code /* Added for bug#16288090 */
999: FROM
1000: jai_cmn_cus_addresses a
1001: , qp_list_lines b
1002: , qp_pricing_attributes c,
1003: qp_list_headers_b qlhb /* Added for bug#16288090 */
1004: WHERE a.customer_id = pn_party_id

Line 1037: jai_cmn_cus_addresses a

1033: b.operand list_price
1034: , c.product_uom_code list_price_uom_code ,
1035: qlhb.currency_code /* Added for bug#16288090 */
1036: FROM
1037: jai_cmn_cus_addresses a
1038: , qp_list_lines b
1039: , qp_pricing_attributes c,
1040: qp_list_headers_b qlhb /* Added for bug#16288090 */
1041: WHERE a.customer_id = pn_party_id

Line 1073: jai_cmn_cus_addresses a

1069: b.operand list_price
1070: , c.product_uom_code list_price_uom_code ,
1071: qlhb.currency_code /* Added for bug#16288090 */
1072: FROM
1073: jai_cmn_cus_addresses a
1074: , qp_list_lines b
1075: , qp_pricing_attributes c,
1076: qp_list_headers_b qlhb /* Added for bug#16288090 */
1077: WHERE a.customer_id = pn_party_id