APPS.JAI_GENERAL_PKG dependencies on JAI_CMN_VENDOR_SITES

Line 136: FROM JAI_CMN_VENDOR_SITES

132: ) IS
133:
134: CURSOR c_range_division IS
135: SELECT excise_duty_range, excise_duty_division
136: FROM JAI_CMN_VENDOR_SITES
137: WHERE vendor_id = p_vendor_id
138: AND vendor_site_id = p_vendor_site_id;
139: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_general_pkg.get_range_division';
140: BEGIN

Line 874: JAI_CMN_VENDOR_SITES a,

870: b.operand list_price,
871: c.product_uom_code list_price_uom_code,
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

Line 909: JAI_CMN_VENDOR_SITES a,

905: b.operand list_price,
906: c.product_uom_code list_price_uom_code,
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

Line 939: JAI_CMN_VENDOR_SITES a,

935: b.operand list_price,
936: c.product_uom_code list_price_uom_code,
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

Line 1110: jai_cmn_vendor_sites a

1106: b.operand list_price
1107: , c.product_uom_code list_price_uom_code ,
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

Line 1147: jai_cmn_vendor_sites a

1143: b.operand list_price
1144: , c.product_uom_code list_price_uom_code ,
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

Line 1183: jai_cmn_vendor_sites a

1179: b.operand list_price
1180: , c.product_uom_code list_price_uom_code ,
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