APPS.GMF_LOT_COSTING_PUB dependencies on CM_WHSE_ASC

Line 1381: FROM cm_whse_asc cstw, mtl_parameters invw

1377: AND gps.start_date <= p_date
1378: AND gps.end_date >= p_date
1379: AND gps.period_id = cst.period_id
1380: AND cst.organization_id = (SELECT NVL (cstw.cost_organization_id, invw.organization_id)
1381: FROM cm_whse_asc cstw, mtl_parameters invw
1382: WHERE cstw.organization_id(+) = invw.organization_id
1383: AND invw.organization_id = p_orgn_id
1384: AND NVL(cstw.eff_start_date(+),p_date) <= p_date -- HALUTHRA Bug 5473138/8533290
1385: AND NVL(cstw.eff_end_date(+),p_date) >= p_date -- HALTURHA Bug 5473138/8533290

Line 1420: FROM cm_whse_asc cstw, mtl_parameters invw

1416: WHERE cst.cost_type_id = p_cost_type_id
1417: AND cst.period_id = p_period_id
1418: AND cst.organization_id =
1419: (SELECT NVL (cstw.cost_organization_id, invw.organization_id)
1420: FROM cm_whse_asc cstw, mtl_parameters invw
1421: WHERE cstw.organization_id(+) = invw.organization_id
1422: AND invw.organization_id = p_orgn_id
1423: AND NVL(cstw.eff_start_date(+),p_date) <= p_date -- HALUTHRA Bug 5473138/8533290
1424: AND NVL(cstw.eff_end_date(+),p_date) >= p_date -- HALUTHRA Bug 5473138/8533290

Line 1462: FROM cm_whse_asc cstw, mtl_parameters invw

1458: AND cst.cost_type_id = p_cost_type_id
1459: AND gps.period_id = cst.period_id
1460: AND cst.organization_id =
1461: (SELECT NVL (cstw.cost_organization_id, invw.organization_id)
1462: FROM cm_whse_asc cstw, mtl_parameters invw
1463: WHERE cstw.organization_id(+) = invw.organization_id
1464: AND invw.organization_id = p_orgn_id
1465: AND NVL(cstw.eff_start_date(+),p_date) <= p_date -- HALUTHRA Bug 5473138/8533290
1466: AND NVL(cstw.eff_end_date(+),p_date) >= p_date -- HALUTHRA Bug 5473138/8533290