APPS.JAI_GST_GENERAL_PKG dependencies on JAI_CMN_CUS_ADDRESSES

Line 73: -- Replace vat_price_list_id with Gst_Assessable_Price in jai_cmn_vendor_sites/jai_cmn_cus_addresses

69: --
70: -- DESCRIPTION:
71: -- Get gst assable value according customer+customer+site/vendor+vendor_site, item, uom, date
72: -- Base on the logic of function JAI_GENERAL_PKG.JA_IN_VAT_ASSESSABLE_VALUE
73: -- Replace vat_price_list_id with Gst_Assessable_Price in jai_cmn_vendor_sites/jai_cmn_cus_addresses
74: --
75: -- Return:
76: -- Number, the value of gst AV
77: --

Line 127: FROM qp_list_headers qlh, JAI_CMN_CUS_ADDRESSES a

123: nvl(b.start_date_active, p_ordered_date) AND
124: nvl(b.end_date_active, SYSDATE)
125: AND EXISTS
126: (SELECT 1
127: FROM qp_list_headers qlh, JAI_CMN_CUS_ADDRESSES a
128: WHERE qlh.list_header_id = b.list_header_id
129: AND a.customer_id = p_party_id
130: AND a.address_id = p_address_id
131: AND a.Gst_Assessable_Price = b.LIST_header_ID

Line 146: FROM qp_list_headers qlh, JAI_CMN_CUS_ADDRESSES a

142: AND trunc(nvl(b.end_date_active, SYSDATE)) >=
143: trunc(p_ordered_date)
144: AND EXISTS
145: (SELECT 1
146: FROM qp_list_headers qlh, JAI_CMN_CUS_ADDRESSES a
147: WHERE a.customer_id = p_party_id
148: AND a.address_id = p_address_id
149: AND qlh.list_header_id = b.list_header_id
150: AND a.Gst_Assessable_Price = b.list_header_id

Line 164: FROM qp_list_headers qlh, JAI_CMN_CUS_ADDRESSES a

160: AND c.PRODUCT_ATTR_VALUE = TO_CHAR(p_inventory_item_id)
161: AND NVL(b.end_date_active, SYSDATE) >= p_ordered_date
162: AND EXISTS
163: (SELECT 1
164: FROM qp_list_headers qlh, JAI_CMN_CUS_ADDRESSES a
165: WHERE a.customer_id = p_party_id
166: AND a.address_id = p_address_id
167: AND qlh.list_header_id = b.list_header_id
168: AND a.Gst_Assessable_Price = b.LIST_header_ID

Line 253: FROM jai_cmn_cus_addresses a,

249:
250: --Get the gst Assessable Value based on the Customer Id, Address Id, inventory_item_id, uom code, Ordered date.
251: CURSOR cust_ass_value_category_cur(pn_party_id NUMBER, pn_address_id NUMBER, pn_inventory_item_id NUMBER, pv_uom_code VARCHAR2, pd_ordered_date DATE) IS
252: SELECT b.operand list_price, c.product_uom_code list_price_uom_code
253: FROM jai_cmn_cus_addresses a,
254: qp_list_lines b,
255: qp_pricing_attributes c
256: WHERE a.customer_id = pn_party_id
257: AND a.address_id = pn_address_id

Line 274: FROM jai_cmn_cus_addresses a,

270:
271: --Get the gst Assessable Value based on the Primary Uom, Customer Id, Address Id, inventory_item_id, Ordered date.
272: CURSOR cust_ass_value_pri_uom_cur(pn_party_id NUMBER, pn_address_id NUMBER, pn_inventory_item_id NUMBER, pd_ordered_date DATE) IS
273: SELECT b.operand list_price, c.product_uom_code list_price_uom_code
274: FROM jai_cmn_cus_addresses a,
275: qp_list_lines b,
276: qp_pricing_attributes c
277: WHERE a.customer_id = pn_party_id
278: AND a.address_id = pn_address_id

Line 294: FROM jai_cmn_cus_addresses a,

290:
291: --Get the gst Assessable Value based on the Customer Id, Address Id, inventory_item_id, Ordered date.
292: CURSOR cust_ass_value_other_uom_cur(pn_party_id NUMBER, pn_address_id NUMBER, pn_inventory_item_id NUMBER, pd_ordered_date DATE) IS
293: SELECT b.operand list_price, c.product_uom_code list_price_uom_code
294: FROM jai_cmn_cus_addresses a,
295: qp_list_lines b,
296: qp_pricing_attributes c
297: WHERE a.customer_id = pn_party_id
298: AND a.address_id = pn_address_id