DBA Data[Home] [Help]

APPS.PO_EMAIL_GENERATE dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 276: financials_system_params_all fsp -- --financials_system_parameters fsp

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

Line 324: financials_system_params_all fsp -- --financials_system_parameters fsp

320: FROM po_lines_all pol, -- --po_lines pol,
321: po_line_locations pll,
322: mtl_system_items_kfv msi,
323: mtl_units_of_measure_vl umvl,
324: financials_system_params_all fsp -- --financials_system_parameters fsp
325: where POL.PO_HEADER_ID = v_document_id
326: and POL.po_line_id = PLL.po_line_id(+)
327: and pol.item_id = msi.inventory_item_id(+)
328: and pll.shipment_type(+) = 'PRICE BREAK'

Line 371: financials_system_params_all fsp -- --financials_system_parameters fsp

367: FROM po_lines pol,
368: po_headers_all poh, -- --po_headers poh,
369: mtl_system_items_kfv msi,
370: mtl_units_of_measure_vl umvl,
371: financials_system_params_all fsp -- --financials_system_parameters fsp
372: where POL.PO_HEADER_ID = v_document_id
373: and POL.po_header_id = POH.po_header_id
374: and pol.item_id = msi.inventory_item_id(+)
375: and NVL(msi.organization_id, fsp.inventory_organization_id) = fsp.inventory_organization_id

Line 417: financials_system_params_all fsp -- --financials_system_parameters fsp

413: FROM po_lines_all pol, -- --po_lines pol,
414: po_line_locations pll,
415: mtl_system_items_kfv msi,
416: mtl_units_of_measure_vl umvl,
417: financials_system_params_all fsp -- --financials_system_parameters fsp
418: where PLL.PO_RELEASE_ID = v_document_id
419: and PLL.po_line_id = POL.po_line_id
420: and pol.item_id = msi.inventory_item_id(+)
421: and NVL(msi.organization_id, fsp.inventory_organization_id) =