[Home] [Help]
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
693: a.address_id = p_address_id AND
694: a.vat_price_list_id = b.LIST_header_ID AND
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
721: a.address_id = p_address_id AND
722: a.vat_price_list_id = b.list_header_id AND
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
745: a.address_id = p_address_id AND
746: a.vat_price_list_id = b.LIST_header_ID AND
763: c.product_uom_code list_price_uom_code ,
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',
797: c.product_uom_code list_price_uom_code ,
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',
830: c.product_uom_code list_price_uom_code ,
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',
872: qlhb.currency_code /* 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
907: qlhb.currency_code /* 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
937: qlhb.currency_code /* 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
952: NVL(qlhb.active_flag,'N') = 'Y' AND /*Added for bug#16288090*/
953: NVL(b.end_date_active,SYSDATE) >= p_ordered_date;
954:
955: --------------------------------end, cursors for vendor--------------------------------------------------
956: v_primary_uom_code qp_pricing_attributes.product_uom_code%type;
957: v_other_uom_code qp_pricing_attributes.product_uom_code%type;
958: /* Added for bug#16288090 */
959:
960: lv_assess_val_curr_code VARCHAR2(100) ;
953: NVL(b.end_date_active,SYSDATE) >= p_ordered_date;
954:
955: --------------------------------end, cursors for vendor--------------------------------------------------
956: v_primary_uom_code qp_pricing_attributes.product_uom_code%type;
957: v_other_uom_code qp_pricing_attributes.product_uom_code%type;
958: /* Added for bug#16288090 */
959:
960: lv_assess_val_curr_code VARCHAR2(100) ;
961: ln_assess_val_conv_rate NUMBER ;
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
1005: AND a.address_id = pn_address_id
1006: AND a.vat_price_list_id = b.list_header_id
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
1042: AND a.address_id = pn_address_id
1043: AND a.vat_price_list_id = b.list_header_id
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
1078: AND a.address_id = pn_address_id
1079: AND a.vat_price_list_id = b.list_header_id
1108: qlhb.currency_code /* 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
1145: qlhb.currency_code /* 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
1181: qlhb.currency_code /* 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