DBA Data[Home] [Help]

APPS.PO_ATTRIBUTE_VALUES_PVT dependencies on MTL_PARAMETERS

Line 6483: l_master_organization_id MTL_PARAMETERS.master_organization_id%TYPE;

6479: )
6480: IS
6481: d_mod CONSTANT VARCHAR2(100) := D_get_item_attributes_values;
6482: l_progress VARCHAR2(4);
6483: l_master_organization_id MTL_PARAMETERS.master_organization_id%TYPE;
6484: l_inv_organization_id MTL_PARAMETERS.master_organization_id%TYPE;
6485:
6486: BEGIN
6487: l_progress := '010';

Line 6484: l_inv_organization_id MTL_PARAMETERS.master_organization_id%TYPE;

6480: IS
6481: d_mod CONSTANT VARCHAR2(100) := D_get_item_attributes_values;
6482: l_progress VARCHAR2(4);
6483: l_master_organization_id MTL_PARAMETERS.master_organization_id%TYPE;
6484: l_inv_organization_id MTL_PARAMETERS.master_organization_id%TYPE;
6485:
6486: BEGIN
6487: l_progress := '010';
6488: IF PO_LOG.d_proc THEN

Line 6500: FROM mtl_parameters mtl,

6496: SELECT mtl.master_organization_id,
6497: fsp.inventory_organization_id
6498: INTO l_master_organization_id,
6499: l_inv_organization_id
6500: FROM mtl_parameters mtl,
6501: financials_system_parameters fsp
6502: WHERE fsp.inventory_organization_id = mtl.organization_id;
6503:
6504: IF PO_LOG.d_stmt THEN

Line 6590: FROM mtl_parameters mtl,

6586:
6587: -- Get MASTER_ORGANIZATION_ID
6588: SELECT mtl.master_organization_id
6589: INTO l_master_organization_id
6590: FROM mtl_parameters mtl,
6591: financials_system_parameters fsp
6592: WHERE fsp.inventory_organization_id = mtl.organization_id;
6593:
6594: IF PO_LOG.d_stmt THEN