DBA Data[Home] [Help]

APPS.PO_TAX_INTERFACE_PVT dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

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

2540: ,ph.po_header_id --trx_id
2541: ,sysdate --trx_date
2542: ,ph.revision_num --trx_doc_revision
2543: ,(SELECT set_of_books_id --ledger_id
2544: FROM financials_system_params_all WHERE org_id=ph.org_id)
2545: ,ph.currency_code --trx_currency_code
2546: ,ph.rate_date --currency_conversion_date
2547: ,ph.rate --currency_conversion_rate
2548: ,ph.rate_type --currency_conversion_type

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

2652: ,ph.po_header_id --trx_id
2653: ,sysdate --trx_date
2654: ,ph.revision_num --trx_doc_revision
2655: ,(SELECT set_of_books_id --ledger_id
2656: FROM financials_system_params_all WHERE org_id=ph.org_id)
2657: ,ph.currency_code --trx_currency_code
2658: ,ph.rate_date --currency_conversion_date
2659: ,ph.rate --currency_conversion_rate
2660: ,ph.rate_type --currency_conversion_type

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

2757: ,pr.po_release_id --trx_id
2758: ,sysdate --trx_date
2759: ,pr.revision_num --trx_doc_revision
2760: ,(select set_of_books_id --ledger_id
2761: from financials_system_params_all where org_id=pr.org_id)
2762: ,ph.currency_code --trx_currency_code
2763: ,ph.rate_date --currency_conversion_date
2764: ,ph.rate --currency_conversion_rate
2765: ,ph.rate_type --currency_conversion_type

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

2880: ,pr.po_release_id --trx_id
2881: ,sysdate --trx_date
2882: ,pr.revision_num --trx_doc_revision
2883: ,(select set_of_books_id --ledger_id
2884: from financials_system_params_all where org_id=pr.org_id)
2885: ,ph.currency_code --trx_currency_code
2886: ,ph.rate_date --currency_conversion_date
2887: ,ph.rate --currency_conversion_rate
2888: ,ph.rate_type --currency_conversion_type

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

2974: PO_CONSTANTS_SV.REQ_CREATED)
2975: ,prh.requisition_header_id --trx_id
2976: ,sysdate --trx_date
2977: ,(select set_of_books_id --ledger_id
2978: from financials_system_params_all where org_id=prh.org_id)
2979: ,PO_CORE_S.get_default_legal_entity_id(prh.org_id) --legal_entity_id
2980: ,prh.org_id --rounding_bill_to_party_id
2981: ,'Y' --quote_flag
2982: ,zxldet.document_sub_type --document_sub_type

Line 3134: FROM financials_system_params_all fsp

3130: ,pll.quantity --trx_line_quantity
3131: ,pl.item_id --product_id
3132: -- Bug 5335818. Pass in inventory_organization_id
3133: ,(SELECT fsp.inventory_organization_id --product_org_id
3134: FROM financials_system_params_all fsp
3135: WHERE fsp.org_id=pll.org_id)
3136: ,DECODE(p_calling_program, --product_fisc_classification
3137: 'COPY_DOCUMENT', null,
3138: zxldet.product_fisc_classification)

Line 3456: FROM financials_system_params_all fsp

3452: ,pll.quantity --trx_line_quantity
3453: ,pl.item_id --product_id
3454: -- Bug 5335818. Pass in inventory_organization_id
3455: ,(SELECT fsp.inventory_organization_id --product_org_id
3456: FROM financials_system_params_all fsp
3457: WHERE fsp.org_id=pll.org_id)
3458: ,zxldet.product_fisc_classification --product_fisc_classification
3459: ,(SELECT mum.uom_code FROM mtl_units_of_measure mum
3460: WHERE mum.unit_of_measure=pll.unit_meas_lookup_code) --uom_code

Line 3794: FROM financials_system_params_all fsp

3790: ,pll.quantity --trx_line_quantity
3791: ,pl.item_id --product_id
3792: -- Bug 5335818. Pass in inventory_organization_id
3793: ,(SELECT fsp.inventory_organization_id --product_org_id
3794: FROM financials_system_params_all fsp
3795: WHERE fsp.org_id=pll.org_id)
3796: ,DECODE(p_calling_program, --product_fisc_classification
3797: 'COPY_DOCUMENT', null,
3798: zxldet.product_fisc_classification)

Line 4112: FROM financials_system_params_all fsp

4108: ,pll.quantity --trx_line_quantity
4109: ,pl.item_id --product_id
4110: -- Bug 5335818. Pass in inventory_organization_id
4111: ,(SELECT fsp.inventory_organization_id --product_org_id
4112: FROM financials_system_params_all fsp
4113: WHERE fsp.org_id=pll.org_id)
4114: ,zxldet.product_fisc_classification --product_fisc_classification
4115: ,(SELECT mum.uom_code FROM mtl_units_of_measure mum
4116: WHERE mum.unit_of_measure=pll.unit_meas_lookup_code) --uom_code

Line 4344: l_set_of_books_id FINANCIALS_SYSTEM_PARAMS_ALL.set_of_books_id%TYPE;

4340: PROCEDURE populate_zx_lines_with_req(p_requisition_header_id IN NUMBER,
4341: p_calling_program IN VARCHAR2
4342: ) IS
4343: l_functional_currency_code PO_REQUISITION_LINES_ALL.currency_code%TYPE;
4344: l_set_of_books_id FINANCIALS_SYSTEM_PARAMS_ALL.set_of_books_id%TYPE;
4345: l_rate_type PO_REQUISITION_LINES_ALL.rate_type%TYPE;
4346: l_rate PO_REQUISITION_LINES_ALL.rate%TYPE;
4347: BEGIN
4348:

Line 4354: FROM financials_system_params_all fsp, gl_sets_of_books sob,

4350: -- This piece of code is similar to PO_GA_PVT.get_currency_info except that
4351: -- this works for a requisition
4352: SELECT sob.currency_code, fsp.set_of_books_id, psp.default_rate_type
4353: INTO l_functional_currency_code, l_set_of_books_id, l_rate_type
4354: FROM financials_system_params_all fsp, gl_sets_of_books sob,
4355: po_requisition_headers_all prh, po_system_parameters_all psp
4356: WHERE fsp.set_of_books_id = sob.set_of_books_id
4357: AND fsp.org_id = prh.org_id
4358: AND prh.requisition_header_id = p_requisition_header_id

Line 4448: FROM financials_system_params_all fsp

4444: ,prl.unit_price --unit_price
4445: ,prl.item_id --product_id
4446: -- Bug 5335818. Pass in inventory_organization_id
4447: ,(SELECT fsp.inventory_organization_id --product_org_id
4448: FROM financials_system_params_all fsp
4449: WHERE fsp.org_id=prl.org_id)
4450: ,(SELECT mum.uom_code FROM mtl_units_of_measure mum
4451: WHERE mum.unit_of_measure=prl.unit_meas_lookup_code) --uom_code
4452: ,msib.segment1 --product_code