DBA Data[Home] [Help]

APPS.JAI_GST_GENERAL_PKG dependencies on JAI_CMN_VENDOR_SITES

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 182: FROM JAI_CMN_VENDOR_SITES a,

178: Exact Match condition
179: */
180: CURSOR c_gst_ass_value_vend(p_vendor_id NUMBER, p_address_id NUMBER, p_inventory_item_id NUMBER, p_uom_code VARCHAR2, p_ordered_date DATE) IS
181: SELECT b.operand list_price, c.product_uom_code list_price_uom_code
182: FROM JAI_CMN_VENDOR_SITES a,
183: qp_list_lines b,
184: qp_pricing_attributes c
185: WHERE a.vendor_id = p_vendor_id
186: AND a.vendor_site_id = p_address_id

Line 201: FROM JAI_CMN_VENDOR_SITES a,

197: */
198:
199: CURSOR c_gst_ass_value_pri_uom_vend(p_vendor_id NUMBER, p_address_id NUMBER, p_inventory_item_id NUMBER, p_ordered_date DATE) IS
200: SELECT b.operand list_price, c.product_uom_code list_price_uom_code
201: FROM JAI_CMN_VENDOR_SITES a,
202: qp_list_lines b,
203: qp_pricing_attributes c
204: WHERE a.vendor_id = p_vendor_id
205: AND a.vendor_site_id = p_address_id

Line 215: FROM JAI_CMN_VENDOR_SITES a,

211: AND nvl(primary_uom_flag, 'N') = 'Y';
212:
213: CURSOR c_gst_ass_value_other_uom_vend(p_vendor_id NUMBER, p_address_id NUMBER, p_inventory_item_id NUMBER, p_ordered_date DATE) IS
214: SELECT b.operand list_price, c.product_uom_code list_price_uom_code
215: FROM JAI_CMN_VENDOR_SITES a,
216: qp_list_lines b,
217: qp_pricing_attributes c
218: WHERE a.vendor_id = p_vendor_id
219: AND a.vendor_site_id = p_address_id

Line 313: FROM jai_cmn_vendor_sites a,

309:
310: -- Get the gst Assessable Value based on the Vendor Id, Address Id, inventory_item_id, uom code, Ordered date.
311: CURSOR vend_ass_value_category_cur(pn_vendor_id NUMBER, pn_address_id NUMBER, pn_inventory_item_id NUMBER, pv_uom_code VARCHAR2, pd_ordered_date DATE) IS
312: SELECT b.operand list_price, c.product_uom_code list_price_uom_code
313: FROM jai_cmn_vendor_sites a,
314: qp_list_lines b,
315: qp_pricing_attributes c
316: WHERE a.vendor_id = pn_vendor_id
317: AND a.vendor_site_id = pn_address_id

Line 334: FROM jai_cmn_vendor_sites a,

330:
331: -- Get the gst Assessable Value based on the Primary Uom, Vendor Id, Address Id, inventory_item_id, Ordered date.
332: CURSOR vend_ass_value_pri_uom_cur(pn_vendor_id NUMBER, pn_address_id NUMBER, pn_inventory_item_id NUMBER, pd_ordered_date DATE) IS
333: SELECT b.operand list_price, c.product_uom_code list_price_uom_code
334: FROM jai_cmn_vendor_sites a,
335: qp_list_lines b,
336: qp_pricing_attributes c
337: WHERE a.vendor_id = pn_vendor_id
338: AND a.vendor_site_id = pn_address_id

Line 354: FROM jai_cmn_vendor_sites a,

350:
351: -- Get the gst Assessable Value based on the Vendor Id, Address Id, inventory_item_id, Ordered date.
352: CURSOR vend_ass_value_other_uom_cur(pn_vendor_id NUMBER, pn_address_id NUMBER, pn_inventory_item_id NUMBER, pd_ordered_date DATE) IS
353: SELECT b.operand list_price, c.product_uom_code list_price_uom_code
354: FROM jai_cmn_vendor_sites a,
355: qp_list_lines b,
356: qp_pricing_attributes c
357: WHERE a.vendor_id = pn_vendor_id
358: AND a.vendor_site_id = pn_address_id