eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_TAX_INTERFACE_PVT dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 2359: FROM financials_system_params_all WHERE org_id=ph.org_id)

2355: ,ph.po_header_id --trx_id
2356: ,sysdate --trx_date
2357: ,ph.revision_num --trx_doc_revision
2358: ,(SELECT set_of_books_id --ledger_id
2359: FROM financials_system_params_all WHERE org_id=ph.org_id)
2360: ,ph.currency_code --trx_currency_code
2361: ,ph.rate_date --currency_conversion_date
2362: ,ph.rate --currency_conversion_rate
2363: ,ph.rate_type --currency_conversion_type

Line 2471: FROM financials_system_params_all WHERE org_id=ph.org_id)

2467: ,ph.po_header_id --trx_id
2468: ,sysdate --trx_date
2469: ,ph.revision_num --trx_doc_revision
2470: ,(SELECT set_of_books_id --ledger_id
2471: FROM financials_system_params_all WHERE org_id=ph.org_id)
2472: ,ph.currency_code --trx_currency_code
2473: ,ph.rate_date --currency_conversion_date
2474: ,ph.rate --currency_conversion_rate
2475: ,ph.rate_type --currency_conversion_type

Line 2576: from financials_system_params_all where org_id=pr.org_id)

2572: ,pr.po_release_id --trx_id
2573: ,sysdate --trx_date
2574: ,pr.revision_num --trx_doc_revision
2575: ,(select set_of_books_id --ledger_id
2576: from financials_system_params_all where org_id=pr.org_id)
2577: ,ph.currency_code --trx_currency_code
2578: ,ph.rate_date --currency_conversion_date
2579: ,ph.rate --currency_conversion_rate
2580: ,ph.rate_type --currency_conversion_type

Line 2699: from financials_system_params_all where org_id=pr.org_id)

2695: ,pr.po_release_id --trx_id
2696: ,sysdate --trx_date
2697: ,pr.revision_num --trx_doc_revision
2698: ,(select set_of_books_id --ledger_id
2699: from financials_system_params_all where org_id=pr.org_id)
2700: ,ph.currency_code --trx_currency_code
2701: ,ph.rate_date --currency_conversion_date
2702: ,ph.rate --currency_conversion_rate
2703: ,ph.rate_type --currency_conversion_type

Line 2793: from financials_system_params_all where org_id=prh.org_id)

2789: PO_CONSTANTS_SV.REQ_CREATED)
2790: ,prh.requisition_header_id --trx_id
2791: ,sysdate --trx_date
2792: ,(select set_of_books_id --ledger_id
2793: from financials_system_params_all where org_id=prh.org_id)
2794: ,PO_CORE_S.get_default_legal_entity_id(prh.org_id) --legal_entity_id
2795: ,prh.org_id --rounding_bill_to_party_id
2796: ,'Y' --quote_flag
2797: ,zxldet.document_sub_type --document_sub_type

Line 2943: FROM financials_system_params_all fsp

2939: ,pll.quantity --trx_line_quantity
2940: ,pl.item_id --product_id
2941: -- Bug 5335818. Pass in inventory_organization_id
2942: ,(SELECT fsp.inventory_organization_id --product_org_id
2943: FROM financials_system_params_all fsp
2944: WHERE fsp.org_id=pll.org_id)
2945: ,DECODE(p_calling_program, --product_fisc_classification
2946: 'COPY_DOCUMENT', null,
2947: zxldet.product_fisc_classification)

Line 3252: FROM financials_system_params_all fsp

3248: ,pll.quantity --trx_line_quantity
3249: ,pl.item_id --product_id
3250: -- Bug 5335818. Pass in inventory_organization_id
3251: ,(SELECT fsp.inventory_organization_id --product_org_id
3252: FROM financials_system_params_all fsp
3253: WHERE fsp.org_id=pll.org_id)
3254: ,zxldet.product_fisc_classification --product_fisc_classification
3255: ,(SELECT mum.uom_code FROM mtl_units_of_measure mum
3256: WHERE mum.unit_of_measure=pll.unit_meas_lookup_code) --uom_code

Line 3467: l_set_of_books_id FINANCIALS_SYSTEM_PARAMS_ALL.set_of_books_id%TYPE;

3463: PROCEDURE populate_zx_lines_with_req(p_requisition_header_id IN NUMBER,
3464: p_calling_program IN VARCHAR2
3465: ) IS
3466: l_functional_currency_code PO_REQUISITION_LINES_ALL.currency_code%TYPE;
3467: l_set_of_books_id FINANCIALS_SYSTEM_PARAMS_ALL.set_of_books_id%TYPE;
3468: l_rate_type PO_REQUISITION_LINES_ALL.rate_type%TYPE;
3469: l_rate PO_REQUISITION_LINES_ALL.rate%TYPE;
3470: BEGIN
3471:

Line 3477: FROM financials_system_params_all fsp, gl_sets_of_books sob,

3473: -- This piece of code is similar to PO_GA_PVT.get_currency_info except that
3474: -- this works for a requisition
3475: SELECT sob.currency_code, fsp.set_of_books_id, psp.default_rate_type
3476: INTO l_functional_currency_code, l_set_of_books_id, l_rate_type
3477: FROM financials_system_params_all fsp, gl_sets_of_books sob,
3478: po_requisition_headers_all prh, po_system_parameters_all psp
3479: WHERE fsp.set_of_books_id = sob.set_of_books_id
3480: AND fsp.org_id = prh.org_id
3481: AND prh.requisition_header_id = p_requisition_header_id

Line 3570: FROM financials_system_params_all fsp

3566: ,prl.unit_price --unit_price
3567: ,prl.item_id --product_id
3568: -- Bug 5335818. Pass in inventory_organization_id
3569: ,(SELECT fsp.inventory_organization_id --product_org_id
3570: FROM financials_system_params_all fsp
3571: WHERE fsp.org_id=prl.org_id)
3572: ,(SELECT mum.uom_code FROM mtl_units_of_measure mum
3573: WHERE mum.unit_of_measure=prl.unit_meas_lookup_code) --uom_code
3574: ,msib.segment1 --product_code