DBA Data[Home] [Help]

APPS.OE_MARGIN_PVT dependencies on MTL_PARAMETERS

Line 323: FROM mtl_parameters p

319: --INVCONV
320: /*Cursor OPM_CODE(p_organization_id Number) Is -- INVCONV
321: SELECT w.whse_code
322: , s.orgn_code
323: FROM mtl_parameters p
324: , ic_whse_mst w
325: , sy_orgn_mst s
326: , gl_plcy_mst plcy
327: WHERE plcy.co_code = s.co_code

Line 560: FROM mtl_parameters

556:
557: G_PROJECT_ID := NULL;
558: SELECT NVL(default_cost_group_id,-1)
559: INTO l_cost_group_id
560: FROM mtl_parameters
561: WHERE organization_id = G_SHIP_FROM_ORG_ID;
562: G_COST_GROUP_ID := l_cost_group_id; --bug14282027
563: IF l_debug_level > 0 THEN
564: oe_debug_pub.add( ' COST GROUP ID FOR NONE PROJECT ITEM:'||L_COST_GROUP_ID ) ;

Line 668: FROM mtl_parameters

664: --Pricing and Availbility call
665: IF l_PA_CALL THEN
666: SELECT NVL(default_cost_group_id,-1)
667: INTO l_cost_group_id
668: FROM mtl_parameters
669: WHERE organization_id = G_SHIP_FROM_ORG_ID;
670:
671: debug(' cost group id for none project item:'||l_cost_group_id);
672: