DBA Data[Home] [Help]

APPS.CSTPPINV dependencies on MTL_PARAMETERS

Line 844: FROM MTL_PARAMETERS MP

840: -- Processing the process-discrete txns
841: -- INVCONV sikhanna
842: SELECT MOD(SUM(DECODE(process_enabled_flag,'Y',1,2)), 2)
843: INTO l_pd_txfr_ind
844: FROM MTL_PARAMETERS MP
845: WHERE MP.ORGANIZATION_ID = i_txn_org_id
846: OR MP.ORGANIZATION_ID = i_txfr_org_id;
847:
848: /* Process-Discrete X-fers set the profile to 2 if ICR relations setup and in diff OU */

Line 2901: mtl_parameters mp --INVCONV sikhanna changes

2897: mmt.subinventory_code,
2898: nvl(mmt.transfer_price,0) -- INVCONV
2899: FROM
2900: mtl_material_transactions mmt,
2901: mtl_parameters mp --INVCONV sikhanna changes
2902: WHERE
2903: transaction_date between l_start_date AND l_end_date
2904: AND mmt.organization_id = nvl(mmt.owning_organization_id, mmt.organization_id)
2905: AND nvl(mmt.owning_tp_type,2) = 2

Line 3273: mtl_parameters mp -- INCONV sikhanna

3269: mmt.subinventory_code,
3270: nvl(mmt.transfer_price,0) -- INVCONV
3271: FROM
3272: mtl_material_transactions mmt,
3273: mtl_parameters mp -- INCONV sikhanna
3274: WHERE
3275: transaction_date between l_start_date AND l_end_date
3276: AND mmt.organization_id = nvl(mmt.owning_organization_id, mmt.organization_id)
3277: AND nvl(mmt.owning_tp_type,2) = 2