DBA Data[Home] [Help]

APPS.CSTPPINV dependencies on MTL_PARAMETERS

Line 802: FROM MTL_PARAMETERS MP

798: -- Processing the process-discrete txns
799: -- INVCONV sikhanna
800: SELECT MOD(SUM(DECODE(process_enabled_flag,'Y',1,2)), 2)
801: INTO l_pd_txfr_ind
802: FROM MTL_PARAMETERS MP
803: WHERE MP.ORGANIZATION_ID = i_txn_org_id
804: OR MP.ORGANIZATION_ID = i_txfr_org_id;
805:
806: /* Process-Discrete X-fers set the profile to 2 if ICR relations setup and in diff OU */

Line 2851: mtl_parameters mp --INVCONV sikhanna changes

2847: mmt.subinventory_code,
2848: nvl(mmt.transfer_price,0) -- INVCONV
2849: FROM
2850: mtl_material_transactions mmt,
2851: mtl_parameters mp --INVCONV sikhanna changes
2852: WHERE
2853: transaction_date between l_start_date AND l_end_date
2854: AND mmt.organization_id = nvl(mmt.owning_organization_id, mmt.organization_id)
2855: AND nvl(mmt.owning_tp_type,2) = 2

Line 3221: mtl_parameters mp -- INCONV sikhanna

3217: mmt.subinventory_code,
3218: nvl(mmt.transfer_price,0) -- INVCONV
3219: FROM
3220: mtl_material_transactions mmt,
3221: mtl_parameters mp -- INCONV sikhanna
3222: WHERE
3223: transaction_date between l_start_date AND l_end_date
3224: AND mmt.organization_id = nvl(mmt.owning_organization_id, mmt.organization_id)
3225: AND nvl(mmt.owning_tp_type,2) = 2