[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT inventory_item_flag
FROM mtl_system_items
WHERE organization_id = cp_organization_id
AND inventory_item_id = cp_item_id;
SELECT max(fin_year) fin_year
FROM JAI_CMN_FIN_YEARS
WHERE organization_id = p_organization_id
AND fin_active_flag = 'Y';
SELECT excise_duty_range, excise_duty_division
FROM JAI_CMN_VENDOR_SITES
WHERE vendor_id = p_vendor_id
AND vendor_site_id = p_vendor_site_id;
SELECT nvl(fcl.precision,0)
-- FROM fnd_currencies_vl fcl
FROM fnd_currencies fcl
WHERE fcl.currency_code = 'INR'
AND NVL(fcl.enabled_flag, 'N') = 'Y'
AND NVL(fcl.currency_flag, 'N') = 'Y'
AND NVL(start_date_active, SYSDATE) <= SYSDATE
AND NVL(end_date_active, SYSDATE ) >= SYSDATE;
SELECT concatenated_segments
FROM gl_code_combinations_kfv
WHERE code_combination_id = cp_code_combination_id;
SELECT primary_uom_code
FROM mtl_system_items
WHERE organization_id = p_organization_id
AND inventory_item_id = p_inventory_item_id;
SELECT uom_code
FROM mtl_units_of_measure
WHERE unit_of_measure = p_uom;
SELECT master_org_flag
FROM JAI_CMN_INVENTORY_ORGS
WHERE organization_id = p_organization_id
AND location_id = p_location_id;
FOR r_boe IN (SELECT boe_id FROM JAI_CMN_BOE_MATCHINGS
WHERE transaction_id = p_transaction_id)
LOOP
IF NVL(length(lv_boe_no), 0) <= 135 THEN
lv_boe_no := lv_boe_no||to_char(r_boe.boe_id)||'/';
SELECT register_id FROM JAI_CMN_RG_23AC_I_TRXS
WHERE organization_id = p_organization_id
AND location_id = p_location_id
AND register_type = cp_register_type
AND inventory_item_id = p_inventory_item_id
AND fin_year = cp_fin_year
AND slno = (select max(slno) from JAI_CMN_RG_23AC_I_TRXS
WHERE organization_id = p_organization_id
AND location_id = p_location_id
AND register_type = cp_register_type
AND inventory_item_id = p_inventory_item_id
AND fin_year = cp_fin_year);
SELECT register_id FROM JAI_CMN_RG_I_TRXS
WHERE organization_id = p_organization_id
AND location_id = p_location_id
AND inventory_item_id = p_inventory_item_id
AND fin_year = cp_fin_year
AND slno = (select max(slno) from JAI_CMN_RG_I_TRXS
WHERE organization_id = p_organization_id
AND location_id = p_location_id
AND inventory_item_id = p_inventory_item_id
AND fin_year = cp_fin_year);
SELECT register_id FROM JAI_CMN_RG_23D_TRXS
WHERE organization_id = p_organization_id
AND location_id = p_location_id
AND inventory_item_id = p_inventory_item_id
AND fin_year = cp_fin_year
AND slno = (select max(slno) from JAI_CMN_RG_23D_TRXS
WHERE organization_id = p_organization_id
AND location_id = p_location_id
AND inventory_item_id = p_inventory_item_id
AND fin_year = cp_fin_year);
SELECT register_id FROM JAI_CMN_RG_23AC_II_TRXS
WHERE organization_id = p_organization_id
AND location_id = p_location_id
AND register_type = cp_register_type
AND fin_year = cp_fin_year
AND slno = (select max(slno) from JAI_CMN_RG_23AC_II_TRXS
WHERE organization_id = p_organization_id
AND location_id = p_location_id
AND register_type = cp_register_type
AND fin_year = cp_fin_year);
SELECT register_id FROM JAI_CMN_RG_PLA_TRXS
WHERE organization_id = p_organization_id
AND location_id = p_location_id
AND fin_year = cp_fin_year
AND slno = (select max(slno) from JAI_CMN_RG_PLA_TRXS
WHERE organization_id = p_organization_id
AND location_id = p_location_id
AND fin_year = cp_fin_year);
PROCEDURE update_rg_balances(
p_organization_id IN NUMBER,
p_location_id IN NUMBER,
p_register IN VARCHAR2,
p_amount IN NUMBER,
p_transaction_source IN VARCHAR2,
p_called_from IN VARCHAR2
) IS
ln_rg23a_amount NUMBER;
lv_object_name CONSTANT VARCHAR2 (61) := 'jai_general_pkg.update_rg_balances';
UPDATE JAI_CMN_RG_BALANCES
SET rg23a_balance = nvl(rg23a_balance,0) + ln_rg23a_amount,
rg23c_balance = nvl(rg23c_balance,0) + ln_rg23c_amount,
pla_balance = nvl(pla_balance,0) + ln_pla_amount
WHERE organization_id = p_location_id
AND location_id = p_location_id;
END update_rg_balances;
SELECT NVL(cust_acct_site_id, 0) address_id
FROM hz_cust_site_uses_all A -- Removed ra_site_uses_all for Bug# 4434287
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
JAI_CMN_CUS_ADDRESSES a,
qp_list_lines b,
qp_pricing_attributes c
WHERE
a.customer_id = p_party_id AND
a.address_id = p_address_id AND
a.vat_price_list_id = 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_CUS_ADDRESSES a,
qp_list_lines b,
qp_pricing_attributes c
WHERE
a.customer_id = p_party_id AND
a.address_id = p_address_id AND
a.vat_price_list_id = 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_CUS_ADDRESSES a,
qp_list_lines b,
qp_pricing_attributes c
WHERE
a.customer_id = p_party_id AND
a.address_id = p_address_id AND
a.vat_price_list_id = 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
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.vat_price_list_id = 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.vat_price_list_id = 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.vat_price_list_id = 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;