DBA Data[Home] [Help]

APPS.PO_CORE_S dependencies on PO_SYSTEM_PARAMETERS

Line 348: po_system_parameters and rcv_parameters tables.

344:
345:
346: ALGORITHM : Retreive po parameters from
347: financials_system_parameters,gl_sets_of_books,
348: po_system_parameters and rcv_parameters tables.
349:
350: NOTES :
351:
352: =========================================================================== */

Line 463: PO_SYSTEM_PARAMETERS_ALL */

459: end get_po_parameters;
460:
461: /* Bug 7518967: ER Default Acceptance Required Check : Overloading the procedure
462: get_po_parameters to get the default acceptance_required_flag from
463: PO_SYSTEM_PARAMETERS_ALL */
464:
465: /* ===========================================================================
466: PROCEDURE NAME: get_po_parameters
467:

Line 526: po_system_parameters and rcv_parameters tables.

522:
523:
524: ALGORITHM : Retreive po parameters from
525: financials_system_parameters,gl_sets_of_books,
526: po_system_parameters and rcv_parameters tables.
527:
528: NOTES :
529:
530: =========================================================================== */

Line 682: po_system_parameters psp,

678: x_qty_rcv_tolerance,
679: x_acceptance_required_flag
680: FROM financials_system_parameters fsp,
681: gl_sets_of_books sob,
682: po_system_parameters psp,
683: rcv_parameters rcv,
684: ap_product_setup aps
685: WHERE fsp.set_of_books_id = sob.set_of_books_id
686: AND rcv.organization_id (+) = fsp.inventory_organization_id;

Line 8496: || ' FROM PO_SYSTEM_PARAMETERS_ALL '

8492: p_message_text => 'p_option_column :' || p_option_column);
8493:
8494:
8495: l_query := 'SELECT ' || p_option_column
8496: || ' FROM PO_SYSTEM_PARAMETERS_ALL '
8497: || ' WHERE ORG_ID=' || p_org_id;
8498:
8499: l_progress :=30;
8500: PO_LOG.stmt(p_module_base => 'PO_PURCHASING_OPTIONS_UTIL',