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_LIST_HEADERS_B

Line 768: qp_list_headers_b qlhb /* Added for bug#16288090 */

764: qlhb.currency_code /* Added for bug#16288090 */
765: FROM
766: qp_list_lines b,
767: qp_pricing_attributes c,
768: qp_list_headers_b qlhb /* Added for bug#16288090 */
769: WHERE
770: c.list_line_id = b.list_line_id AND
771: c.product_attr_value = decode(c.product_attr_value,'ALL',
772: c.product_attr_value,to_char(p_inventory_item_id)) AND--Modified by Junjian on 15-Oct-2012 for bug#14736812

Line 802: qp_list_headers_b qlhb /* Added for bug#16288090 */

798: qlhb.currency_code /* Added for bug#16288090 */
799: FROM
800: qp_list_lines b,
801: qp_pricing_attributes c,
802: qp_list_headers_b qlhb /* Added for bug#16288090 */
803: WHERE
804: c.list_line_id = b.list_line_id AND
805: c.product_attr_value = decode(c.product_attr_value,'ALL',
806: c.product_attr_value,to_char(p_inventory_item_id)) AND--Modified by Junjian on 15-Oct-2012 for bug#14736812

Line 835: qp_list_headers_b qlhb /* Added for bug#16288090 */

831: qlhb.currency_code /* Added for bug#16288090 */
832: FROM
833: qp_list_lines b,
834: qp_pricing_attributes c,
835: qp_list_headers_b qlhb /* Added for bug#16288090 */
836: WHERE
837: c.list_line_id = b.list_line_id AND
838: c.PRODUCT_ATTR_VALUE = decode(c.product_attr_value,'ALL',
839: c.product_attr_value,TO_CHAR(p_inventory_item_id)) AND--Modified by Junjian on 15-Oct-2012 for bug#14736812

Line 877: qp_list_headers_b qlhb /* Added for bug#16288090 */

873: FROM
874: JAI_CMN_VENDOR_SITES a,
875: qp_list_lines b,
876: qp_pricing_attributes c,
877: qp_list_headers_b qlhb /* Added for bug#16288090 */
878: WHERE
879: a.vendor_id = p_vendor_id AND
880: a.vendor_site_id = p_address_id AND
881: a.vat_price_list_id = b.LIST_header_ID AND

Line 912: qp_list_headers_b qlhb /* Added for bug#16288090 */

908: FROM
909: JAI_CMN_VENDOR_SITES a,
910: qp_list_lines b,
911: qp_pricing_attributes c,
912: qp_list_headers_b qlhb /* Added for bug#16288090 */
913: WHERE
914: a.vendor_id = p_vendor_id AND
915: a.vendor_site_id = p_address_id AND
916: a.vat_price_list_id = b.list_header_id AND

Line 942: qp_list_headers_b qlhb /* Added for bug#16288090 */

938: FROM
939: JAI_CMN_VENDOR_SITES a,
940: qp_list_lines b,
941: qp_pricing_attributes c,
942: qp_list_headers_b qlhb /* Added for bug#16288090 */
943: WHERE
944: a.vendor_id = p_vendor_id AND
945: a.vendor_site_id = p_address_id AND
946: a.vat_price_list_id = b.LIST_header_ID AND

Line 1003: qp_list_headers_b qlhb /* 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
1005: AND a.address_id = pn_address_id
1006: AND a.vat_price_list_id = b.list_header_id
1007: AND c.list_line_id = b.list_line_id

Line 1040: qp_list_headers_b qlhb /* 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
1042: AND a.address_id = pn_address_id
1043: AND a.vat_price_list_id = b.list_header_id
1044: AND c.list_line_id = b.list_line_id

Line 1076: qp_list_headers_b qlhb /* 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
1078: AND a.address_id = pn_address_id
1079: AND a.vat_price_list_id = b.list_header_id
1080: AND c.list_line_id = b.list_line_id

Line 1113: qp_list_headers_b qlhb /* Added for bug#16288090 */

1109: FROM
1110: jai_cmn_vendor_sites a
1111: , qp_list_lines b
1112: , qp_pricing_attributes c,
1113: qp_list_headers_b qlhb /* Added for bug#16288090 */
1114: WHERE a.vendor_id = pn_vendor_id
1115: AND a.vendor_site_id = pn_address_id
1116: AND a.vat_price_list_id = b.list_header_id
1117: AND c.list_line_id = b.list_line_id

Line 1150: qp_list_headers_b qlhb /* Added for bug#16288090 */

1146: FROM
1147: jai_cmn_vendor_sites a
1148: , qp_list_lines b
1149: , qp_pricing_attributes c,
1150: qp_list_headers_b qlhb /* Added for bug#16288090 */
1151: WHERE a.vendor_id = pn_vendor_id
1152: AND a.vendor_site_id = pn_address_id
1153: AND a.vat_price_list_id = b.list_header_id
1154: AND c.list_line_id = b.list_line_id

Line 1186: qp_list_headers_b qlhb /* Added for bug#16288090 */

1182: FROM
1183: jai_cmn_vendor_sites a
1184: , qp_list_lines b
1185: , qp_pricing_attributes c,
1186: qp_list_headers_b qlhb /* Added for bug#16288090 */
1187: WHERE a.vendor_id = pn_vendor_id
1188: AND a.vendor_site_id = pn_address_id
1189: AND a.vat_price_list_id = b.list_header_id
1190: AND c.list_line_id = b.list_line_id