DBA Data[Home] [Help]

APPS.POA_CM_EVALUATION_ICX dependencies on FINANCIALS_SYSTEM_PARAMETERS

Line 128: financials_system_parameters f,

124: l_user_period_type,
125: l_period_name
126: from gl_periods p,
127: gl_period_types t,
128: financials_system_parameters f,
129: gl_sets_of_books b
130: where f.set_of_books_id = b.set_of_books_id
131: and b.accounted_period_type = p.period_type
132: and b.period_set_name = p.period_set_name

Line 245: c_js_where_clause = " ORGANIZATION_ID in (select INVENTORY_ORGANIZATION_ID from FINANCIALS_SYSTEM_PARAMETERS)" +

241: else if (c_attribute_code == "POA_CM_ITEM")
242: {
243: if (f.POA_CM_COMMODITY.value != "")
244: if (f.POA_CM_CATEGORY_ID.value != "")
245: c_js_where_clause = " ORGANIZATION_ID in (select INVENTORY_ORGANIZATION_ID from FINANCIALS_SYSTEM_PARAMETERS)" +
246: " AND CATEGORY_ID = " + f.POA_CM_CATEGORY_ID.value.replace(/''/g,"''''");
247: else
248: c_js_where_clause = " ORGANIZATION_ID in (select INVENTORY_ORGANIZATION_ID from FINANCIALS_SYSTEM_PARAMETERS)" +
249: " AND COMMODITY = ''" + f.POA_CM_COMMODITY.value.replace(/''/g,"''''") + "''";

Line 248: c_js_where_clause = " ORGANIZATION_ID in (select INVENTORY_ORGANIZATION_ID from FINANCIALS_SYSTEM_PARAMETERS)" +

244: if (f.POA_CM_CATEGORY_ID.value != "")
245: c_js_where_clause = " ORGANIZATION_ID in (select INVENTORY_ORGANIZATION_ID from FINANCIALS_SYSTEM_PARAMETERS)" +
246: " AND CATEGORY_ID = " + f.POA_CM_CATEGORY_ID.value.replace(/''/g,"''''");
247: else
248: c_js_where_clause = " ORGANIZATION_ID in (select INVENTORY_ORGANIZATION_ID from FINANCIALS_SYSTEM_PARAMETERS)" +
249: " AND COMMODITY = ''" + f.POA_CM_COMMODITY.value.replace(/''/g,"''''") + "''";
250: else
251: c_js_where_clause = " ORGANIZATION_ID in (select INVENTORY_ORGANIZATION_ID from FINANCIALS_SYSTEM_PARAMETERS)";
252: }

Line 251: c_js_where_clause = " ORGANIZATION_ID in (select INVENTORY_ORGANIZATION_ID from FINANCIALS_SYSTEM_PARAMETERS)";

247: else
248: c_js_where_clause = " ORGANIZATION_ID in (select INVENTORY_ORGANIZATION_ID from FINANCIALS_SYSTEM_PARAMETERS)" +
249: " AND COMMODITY = ''" + f.POA_CM_COMMODITY.value.replace(/''/g,"''''") + "''";
250: else
251: c_js_where_clause = " ORGANIZATION_ID in (select INVENTORY_ORGANIZATION_ID from FINANCIALS_SYSTEM_PARAMETERS)";
252: }
253:
254: c_js_where_clause = escape(c_js_where_clause, 1);
255: