DBA Data[Home] [Help]

APPS.PO_ATTRIBUTE_VALUES_PVT dependencies on MTL_PARAMETERS

Line 6616: l_master_organization_id MTL_PARAMETERS.master_organization_id%TYPE;

6612: )
6613: IS
6614: d_mod CONSTANT VARCHAR2(100) := D_get_item_attributes_values;
6615: l_progress VARCHAR2(4);
6616: l_master_organization_id MTL_PARAMETERS.master_organization_id%TYPE;
6617: l_inv_organization_id MTL_PARAMETERS.master_organization_id%TYPE;
6618:
6619: BEGIN
6620: l_progress := '010';

Line 6617: l_inv_organization_id MTL_PARAMETERS.master_organization_id%TYPE;

6613: IS
6614: d_mod CONSTANT VARCHAR2(100) := D_get_item_attributes_values;
6615: l_progress VARCHAR2(4);
6616: l_master_organization_id MTL_PARAMETERS.master_organization_id%TYPE;
6617: l_inv_organization_id MTL_PARAMETERS.master_organization_id%TYPE;
6618:
6619: BEGIN
6620: l_progress := '010';
6621: IF PO_LOG.d_proc THEN

Line 6633: FROM mtl_parameters mtl,

6629: SELECT mtl.master_organization_id,
6630: fsp.inventory_organization_id
6631: INTO l_master_organization_id,
6632: l_inv_organization_id
6633: FROM mtl_parameters mtl,
6634: financials_system_parameters fsp
6635: WHERE fsp.inventory_organization_id = mtl.organization_id;
6636:
6637: IF PO_LOG.d_stmt THEN

Line 6728: FROM mtl_parameters mtl,

6724:
6725: -- Get MASTER_ORGANIZATION_ID
6726: SELECT mtl.master_organization_id
6727: INTO l_master_organization_id
6728: FROM mtl_parameters mtl,
6729: financials_system_parameters fsp
6730: WHERE fsp.inventory_organization_id = mtl.organization_id;
6731:
6732: IF PO_LOG.d_stmt THEN