APPS.PO_WF_PO_CHARGE_ACC dependencies on MTL_PARAMETERS

Line 248: from mtl_parameters

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

Line 273: from mtl_parameters

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

Line 300: from mtl_parameters

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

Line 326: from mtl_parameters

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

Line 1561: FROM MTL_PARAMETERS

1557: -- associated with an OU for a given Transaction Flow.
1558: --SQL WHY: Default as the PO Charge Account for SPS case
1559: SELECT cost_of_sales_account
1560: INTO l_COGS_account_id
1561: FROM MTL_PARAMETERS
1562: WHERE ORGANIZATION_ID = p_inv_org_id;
1563:
1564: RETURN l_COGS_account_id;
1565: EXCEPTION

Line 1653: FROM MTL_PARAMETERS

1649: -- Inventory Org for a Start OU for a given Transaction Flow.
1650: --SQL WHY: To default this as the PO Expense Account for SPS case
1651: SELECT expense_account
1652: INTO l_org_expense_account_id
1653: FROM MTL_PARAMETERS
1654: WHERE organization_id = p_inv_org_id;
1655:
1656: RETURN l_org_expense_account_id;
1657: EXCEPTION

Line 1697: FROM MTL_PARAMETERS

1693: -- Inventory Org for a Start OU for a given Transaction Flow.
1694: --SQL WHY: To default this as the PO Expense Account for SPS case
1695: SELECT material_account
1696: INTO l_org_material_account_id
1697: FROM MTL_PARAMETERS
1698: WHERE organization_id = p_inv_org_id;
1699:
1700: RETURN l_org_material_account_id;
1701: EXCEPTION