APPS.PO_EMAIL_GENERATE dependencies on FINANCIALS_SYSTEM_PARAMETERS

Line 206: from fnd_attached_docs_form_vl fad, financials_system_parameters fsp

202: /* bug 4567441 : added the orderby clause, so that the document attachments
203: are ordered by sequence */
204: cursor attachments_from_ga_cursor(v_entity_name varchar2, v_document_id number) is
205: Select datatype_id, media_id
206: from fnd_attached_docs_form_vl fad, financials_system_parameters fsp
207: where entity_name = v_entity_name
208: and pk1_value = to_char(v_document_id) /* Bug 5964375 */
209: and function_name = 'PO_PRINTPO'
210: and datatype_id in (1,2)

Line 271: financials_system_params_all fsp -- --financials_system_parameters fsp

267: FROM po_lines_all pol, -- --po_lines pol,
268: po_line_locations pll,
269: mtl_system_items_kfv msi,
270: mtl_units_of_measure_vl umvl,
271: financials_system_params_all fsp -- --financials_system_parameters fsp
272: where PLL.PO_HEADER_ID = v_document_id
273: and PLL.po_line_id = POL.po_line_id
274: and PLL.po_release_id is NULL /* Bug 4513703 */
275: and pol.item_id = msi.inventory_item_id(+)

Line 318: financials_system_params_all fsp -- --financials_system_parameters fsp

314: FROM po_lines_all pol, -- --po_lines pol,
315: po_line_locations pll,
316: mtl_system_items_kfv msi,
317: mtl_units_of_measure_vl umvl,
318: financials_system_params_all fsp -- --financials_system_parameters fsp
319: where POL.PO_HEADER_ID = v_document_id
320: and POL.po_line_id = PLL.po_line_id(+)
321: and pol.item_id = msi.inventory_item_id(+)
322: and pll.shipment_type(+) = 'PRICE BREAK'

Line 364: financials_system_params_all fsp -- --financials_system_parameters fsp

360: FROM po_lines pol,
361: po_headers_all poh, -- --po_headers poh,
362: mtl_system_items_kfv msi,
363: mtl_units_of_measure_vl umvl,
364: financials_system_params_all fsp -- --financials_system_parameters fsp
365: where POL.PO_HEADER_ID = v_document_id
366: and POL.po_header_id = POH.po_header_id
367: and pol.item_id = msi.inventory_item_id(+)
368: and NVL(msi.organization_id, fsp.inventory_organization_id) = fsp.inventory_organization_id

Line 409: financials_system_params_all fsp -- --financials_system_parameters fsp

405: FROM po_lines_all pol, -- --po_lines pol,
406: po_line_locations pll,
407: mtl_system_items_kfv msi,
408: mtl_units_of_measure_vl umvl,
409: financials_system_params_all fsp -- --financials_system_parameters fsp
410: where PLL.PO_RELEASE_ID = v_document_id
411: and PLL.po_line_id = POL.po_line_id
412: and pol.item_id = msi.inventory_item_id(+)
413: and NVL(msi.organization_id, fsp.inventory_organization_id) =