[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT 'Y'
FROM JAI_RGM_DEFINITIONS jrd
WHERE jrd.regime_code IN (jai_constants.sgst_regime,jai_constants.cgst_regime);
SELECT nvl(cust_acct_site_id, 0) address_id
FROM hz_cust_site_uses_all A
WHERE A.site_use_id = NVL(p_party_site_id, 0);
SELECT b.operand list_price, c.product_uom_code list_price_uom_code
FROM qp_list_lines b, qp_pricing_attributes c
WHERE c.list_line_id = b.list_line_id
AND c.product_attr_value = to_char(p_inventory_item_id)
AND c.product_uom_code = p_uom_code
AND p_ordered_date BETWEEN
nvl(b.start_date_active, p_ordered_date) AND
nvl(b.end_date_active, SYSDATE)
AND EXISTS
(SELECT 1
FROM qp_list_headers qlh, JAI_CMN_CUS_ADDRESSES a
WHERE qlh.list_header_id = b.list_header_id
AND a.customer_id = p_party_id
AND a.address_id = p_address_id
AND a.Gst_Assessable_Price = b.LIST_header_ID
AND p_ordered_date BETWEEN
nvl(qlh.start_date_active, p_ordered_date) AND
nvl(qlh.end_date_active, SYSDATE)
AND nvl(qlh.active_flag, 'N') = 'Y');
SELECT b.operand list_price, c.product_uom_code list_price_uom_code
FROM qp_list_lines b, qp_pricing_attributes c
WHERE c.list_line_id = b.list_line_id
AND c.product_attr_value = to_char(p_inventory_item_id)
AND trunc(nvl(b.end_date_active, SYSDATE)) >=
trunc(p_ordered_date)
AND EXISTS
(SELECT 1
FROM qp_list_headers qlh, JAI_CMN_CUS_ADDRESSES a
WHERE a.customer_id = p_party_id
AND a.address_id = p_address_id
AND qlh.list_header_id = b.list_header_id
AND a.Gst_Assessable_Price = b.list_header_id
AND trunc(nvl(qlh.end_date_active, SYSDATE)) >=
trunc(p_ordered_date)
AND nvl(qlh.active_flag, 'N') = 'Y')
AND nvl(primary_uom_flag, 'N') = 'Y';
SELECT b.operand list_price, c.product_uom_code list_price_uom_code
FROM qp_list_lines b, qp_pricing_attributes c
WHERE c.list_line_id = b.list_line_id
AND c.PRODUCT_ATTR_VALUE = TO_CHAR(p_inventory_item_id)
AND NVL(b.end_date_active, SYSDATE) >= p_ordered_date
AND EXISTS
(SELECT 1
FROM qp_list_headers qlh, JAI_CMN_CUS_ADDRESSES a
WHERE a.customer_id = p_party_id
AND a.address_id = p_address_id
AND qlh.list_header_id = b.list_header_id
AND a.Gst_Assessable_Price = b.LIST_header_ID
AND NVL(qlh.end_date_active, SYSDATE) >= p_ordered_date
AND NVL(qlh.active_flag, 'N') = 'Y');
SELECT b.operand list_price, c.product_uom_code list_price_uom_code
FROM JAI_CMN_VENDOR_SITES a,
qp_list_lines b,
qp_pricing_attributes c
WHERE a.vendor_id = p_vendor_id
AND a.vendor_site_id = p_address_id
AND a.Gst_Assessable_Price = b.LIST_header_ID
AND c.list_line_id = b.list_line_id
AND c.product_attr_value = to_char(p_inventory_item_id)
AND c.product_uom_code = p_uom_code
AND p_ordered_date BETWEEN nvl(start_date_active, p_ordered_date) AND
nvl(end_date_active, SYSDATE);
SELECT b.operand list_price, c.product_uom_code list_price_uom_code
FROM JAI_CMN_VENDOR_SITES a,
qp_list_lines b,
qp_pricing_attributes c
WHERE a.vendor_id = p_vendor_id
AND a.vendor_site_id = p_address_id
AND a.Gst_Assessable_Price = b.list_header_id
AND c.list_line_id = b.list_line_id
AND c.product_attr_value = to_char(p_inventory_item_id)
AND trunc(nvl(b.end_date_active, SYSDATE)) >=
trunc(p_ordered_date)
AND nvl(primary_uom_flag, 'N') = 'Y';
SELECT b.operand list_price, c.product_uom_code list_price_uom_code
FROM JAI_CMN_VENDOR_SITES a,
qp_list_lines b,
qp_pricing_attributes c
WHERE a.vendor_id = p_vendor_id
AND a.vendor_site_id = p_address_id
AND a.Gst_Assessable_Price = b.LIST_header_ID
AND c.list_line_id = b.list_line_id
AND c.PRODUCT_ATTR_VALUE = TO_CHAR(p_inventory_item_id)
AND NVL(b.end_date_active, SYSDATE) >= p_ordered_date;
SELECT category_set_name
FROM mtl_default_category_sets_fk_v
WHERE functional_area_desc = 'Order Entry';
SELECT b.operand list_price, c.product_uom_code list_price_uom_code
FROM jai_cmn_cus_addresses a,
qp_list_lines b,
qp_pricing_attributes c
WHERE a.customer_id = pn_party_id
AND a.address_id = pn_address_id
AND a.Gst_Assessable_Price = b.list_header_id
AND c.list_line_id = b.list_line_id
AND c.product_uom_code = pv_uom_code
AND pd_ordered_date BETWEEN
NVL(b.start_date_active, pd_ordered_date) AND
NVL(b.end_date_active, SYSDATE)
AND EXISTS
(SELECT 'x'
FROM mtl_item_categories_v d
WHERE d.category_set_name = lv_category_set_name
AND d.inventory_item_id = pn_inventory_item_id
AND c.product_attr_value = TO_CHAR(d.category_id));
SELECT b.operand list_price, c.product_uom_code list_price_uom_code
FROM jai_cmn_cus_addresses a,
qp_list_lines b,
qp_pricing_attributes c
WHERE a.customer_id = pn_party_id
AND a.address_id = pn_address_id
AND a.Gst_Assessable_Price = b.list_header_id
AND c.list_line_id = b.list_line_id
AND TRUNC(NVL(b.end_date_active, SYSDATE)) >=
TRUNC(pd_ordered_date)
AND NVL(primary_uom_flag, 'N') = 'Y'
AND EXISTS
(SELECT 'x'
FROM mtl_item_categories_v d
WHERE d.category_set_name = lv_category_set_name
AND d.inventory_item_id = pn_inventory_item_id
AND c.product_attr_value = TO_CHAR(d.category_id));
SELECT b.operand list_price, c.product_uom_code list_price_uom_code
FROM jai_cmn_cus_addresses a,
qp_list_lines b,
qp_pricing_attributes c
WHERE a.customer_id = pn_party_id
AND a.address_id = pn_address_id
AND a.Gst_Assessable_Price = b.list_header_id
AND c.list_line_id = b.list_line_id
AND TRUNC(NVL(b.end_date_active, SYSDATE)) >=
TRUNC(pd_ordered_date)
AND EXISTS
(SELECT 'x'
FROM mtl_item_categories_v d
WHERE d.category_set_name = lv_category_set_name
AND d.inventory_item_id = pn_inventory_item_id
AND c.product_attr_value = TO_CHAR(d.category_id));
SELECT b.operand list_price, c.product_uom_code list_price_uom_code
FROM jai_cmn_vendor_sites a,
qp_list_lines b,
qp_pricing_attributes c
WHERE a.vendor_id = pn_vendor_id
AND a.vendor_site_id = pn_address_id
AND a.Gst_Assessable_Price = b.list_header_id
AND c.list_line_id = b.list_line_id
AND c.product_uom_code = pv_uom_code
AND pd_ordered_date BETWEEN
NVL(b.start_date_active, pd_ordered_date) AND
NVL(b.end_date_active, SYSDATE)
AND EXISTS
(SELECT 'x'
FROM mtl_item_categories_v d
WHERE d.category_set_name = lv_category_set_name
AND d.inventory_item_id = pn_inventory_item_id
AND c.product_attr_value = TO_CHAR(d.category_id));
SELECT b.operand list_price, c.product_uom_code list_price_uom_code
FROM jai_cmn_vendor_sites a,
qp_list_lines b,
qp_pricing_attributes c
WHERE a.vendor_id = pn_vendor_id
AND a.vendor_site_id = pn_address_id
AND a.Gst_Assessable_Price = b.list_header_id
AND c.list_line_id = b.list_line_id
AND TRUNC(NVL(b.end_date_active, SYSDATE)) >=
TRUNC(pd_ordered_date)
AND NVL(primary_uom_flag, 'N') = 'Y'
AND EXISTS
(SELECT 'x'
FROM mtl_item_categories_v d
WHERE d.category_set_name = lv_category_set_name
AND d.inventory_item_id = pn_inventory_item_id
AND c.product_attr_value = TO_CHAR(d.category_id));
SELECT b.operand list_price, c.product_uom_code list_price_uom_code
FROM jai_cmn_vendor_sites a,
qp_list_lines b,
qp_pricing_attributes c
WHERE a.vendor_id = pn_vendor_id
AND a.vendor_site_id = pn_address_id
AND a.Gst_Assessable_Price = b.list_header_id
AND c.list_line_id = b.list_line_id
AND TRUNC(NVL(b.end_date_active, SYSDATE)) >=
TRUNC(pd_ordered_date)
AND EXISTS
(SELECT 'x'
FROM mtl_item_categories_v d
WHERE d.category_set_name = lv_category_set_name
AND d.inventory_item_id = pn_inventory_item_id
AND c.product_attr_value = TO_CHAR(d.category_id));
SELECT regime_code
FROM jai_rgm_definitions
WHERE regime_id = cp_regime_id;
SELECT regime_id
FROM jai_rgm_definitions
WHERE regime_code = cp_regime_code;
SELECT to_number(accnts.attribute_value)
FROM jai_rgm_registrations tax_types,
jai_rgm_org_regns_v accnts
WHERE tax_types.regime_id = cp_regime_id
AND tax_types.registration_type = jai_constants.regn_type_tax_types
AND tax_types.attribute_code = cp_tax_type
AND accnts.regime_id = tax_types.regime_id
AND accnts.registration_type = jai_constants.regn_type_accounts
AND accnts.parent_registration_id = tax_types.registration_id
AND accnts.attribute_code = cp_account_name
AND accnts.organization_type = cp_organization_type
AND accnts.organization_id = cp_organization_id
AND (cp_location_id IS NULL OR location_id = cp_location_id);
SELECT tax_name
FROM jai_cmn_taxes_all
WHERE tax_id = pn_tax_id;
SELECT tax_type
FROM jai_cmn_taxes_all
WHERE tax_id = pn_tax_id;
SELECT regime_id
FROM jai_cmn_tax_types_all
WHERE tax_type_code = cn_tax_type_code;
SELECT upper(attribute_value)
FROM jai_rgm_registrations
WHERE regime_id = cn_regime_id
AND registration_type = 'OTHERS'
AND attribute_code = 'TAX_ACCOUNTING';
SELECT to_number(nvl(b.ATTRIBUTE_VALUE, a.ATTRIBUTE_VALUE)) ATTRIBUTE_VALUE
FROM (
SELECT JRP.ORGANIZATION_ID
ORGANIZATION_ID,
ACC.ATTRIBUTE_VALUE ATTRIBUTE_VALUE,
JRP.REGIME_ORG_ID
FROM JAI_RGM_PARTIES JRP,
JAI_RGM_REGISTRATIONS JRR,
JAI_RGM_DEFINITIONS JRG,
JAI_RGM_REGISTRATIONS ACC
WHERE 1=1
AND JRG.REGIME_ID = JRP.REGIME_ID
AND JRG.REGIME_id = cn_regime_id --
AND JRG.REGIME_ID = JRR.REGIME_ID
AND ACC.attribute_code = cv_account_class --'RECOVERY'
AND JRR.REGISTRATION_TYPE = 'TAX_TYPES'--cn_setup_type --'TAX_TYPES'
AND ACC.registration_type = 'ACCOUNTS'
AND ACC.PARENT_REGISTRATION_ID = JRR.REGISTRATION_ID
AND JRR.ATTRIBUTE_CODE = cv_attribute_code --'IGST_QA_TEST'
--AND JRP.LOCATION_ID = cn_location_id
) A,
(
SELECT JRP.ORGANIZATION_ID ORGANIZATION_ID,
JPR.ATTRIBUTE_VALUE ATTRIBUTE_VALUE,
JRP.REGIME_ORG_ID
FROM JAI_RGM_PARTIES JRP,
JAI_RGM_REGISTRATIONS JRR,
JAI_RGM_REGISTRATIONS ACC,
JAI_RGM_PARTY_REGNS JPR,
JAI_RGM_DEFINITIONS JRG
WHERE JRG.REGIME_ID = JRP.REGIME_ID
AND JRG.REGIME_ID = cn_regime_id
AND JRG.REGIME_ID = JRR.REGIME_ID
AND ACC.attribute_code = cv_account_class
AND JRR.REGISTRATION_TYPE = 'TAX_TYPES'
AND ACC.registration_type = 'ACCOUNTS'
AND ACC.PARENT_REGISTRATION_ID = JRR.REGISTRATION_ID
AND JRR.ATTRIBUTE_CODE = cv_attribute_code
AND JRP.REGIME_ORG_ID = JPR.REGIME_ORG_ID
AND JPR.REGISTRATION_ID = ACC.REGISTRATION_ID
AND JRP.LOCATION_ID = cn_location_id
) B
WHERE A.organization_id = B.organization_id(+)
AND A.organization_id = cn_organization_id;