DBA Data[Home] [Help]

APPS.OE_MARGIN_PVT dependencies on MTL_PARAMETERS

Line 250: FROM mtl_parameters p

246: --INVCONV
247: /*Cursor OPM_CODE(p_organization_id Number) Is -- INVCONV
248: SELECT w.whse_code
249: , s.orgn_code
250: FROM mtl_parameters p
251: , ic_whse_mst w
252: , sy_orgn_mst s
253: , gl_plcy_mst plcy
254: WHERE plcy.co_code = s.co_code

Line 487: FROM mtl_parameters

483:
484: G_PROJECT_ID := NULL;
485: SELECT NVL(default_cost_group_id,-1)
486: INTO l_cost_group_id
487: FROM mtl_parameters
488: WHERE organization_id = G_SHIP_FROM_ORG_ID;
489: IF l_debug_level > 0 THEN
490: oe_debug_pub.add( ' COST GROUP ID FOR NONE PROJECT ITEM:'||L_COST_GROUP_ID ) ;
491: END IF;

Line 591: FROM mtl_parameters

587: --Pricing and Availbility call
588: IF l_PA_CALL THEN
589: SELECT NVL(default_cost_group_id,-1)
590: INTO l_cost_group_id
591: FROM mtl_parameters
592: WHERE organization_id = G_SHIP_FROM_ORG_ID;
593:
594: debug(' cost group id for none project item:'||l_cost_group_id);
595: