APPS.PO_WF_PO_CHARGE_ACC dependencies on MTL_PARAMETERS

Line 250: from mtl_parameters

246:
247: if (x_account is NULL) then -- Get account from Org
248: begin
249: select expense_account into x_account
250: from mtl_parameters
251: where organization_id = x_dest_org_id;
252:
253: exception
254: when no_data_found then

Line 275: from mtl_parameters

271:
272: -- Get the default account from the Organization
273: begin
274: select material_account into x_account
275: from mtl_parameters
276: where organization_id = x_dest_org_id;
277: exception
278: when no_data_found then
279: x_account := NULL;

Line 302: from mtl_parameters

298:
299: -- Get the default account from the Organization
300: begin
301: select expense_account into x_account
302: from mtl_parameters
303: where organization_id = x_dest_org_id;
304: exception
305: when no_data_found then
306: x_account := NULL;

Line 328: from mtl_parameters

324:
325: if (x_account IS NULL) then
326: begin
327: select material_account into x_account
328: from mtl_parameters
329: where organization_id = x_dest_org_id;
330: exception
331: when no_data_found then
332: x_account := NULL;

Line 1576: FROM MTL_PARAMETERS

1572: -- associated with an OU for a given Transaction Flow.
1573: --SQL WHY: Default as the PO Charge Account for SPS case
1574: SELECT cost_of_sales_account
1575: INTO l_COGS_account_id
1576: FROM MTL_PARAMETERS
1577: WHERE ORGANIZATION_ID = p_inv_org_id;
1578:
1579: RETURN l_COGS_account_id;
1580: EXCEPTION

Line 1668: FROM MTL_PARAMETERS

1664: -- Inventory Org for a Start OU for a given Transaction Flow.
1665: --SQL WHY: To default this as the PO Expense Account for SPS case
1666: SELECT expense_account
1667: INTO l_org_expense_account_id
1668: FROM MTL_PARAMETERS
1669: WHERE organization_id = p_inv_org_id;
1670:
1671: RETURN l_org_expense_account_id;
1672: EXCEPTION

Line 1712: FROM MTL_PARAMETERS

1708: -- Inventory Org for a Start OU for a given Transaction Flow.
1709: --SQL WHY: To default this as the PO Expense Account for SPS case
1710: SELECT material_account
1711: INTO l_org_material_account_id
1712: FROM MTL_PARAMETERS
1713: WHERE organization_id = p_inv_org_id;
1714:
1715: RETURN l_org_material_account_id;
1716: EXCEPTION