DBA Data[Home] [Help]

APPS.MRP_SELECT_ALL_FOR_RELEASE_PUB dependencies on MRP_PROJECT_PARAMETERS

Line 1482: from mrp_project_parameters mpp

1478: begin
1479: if X_PROJECT_ID IS NOT NULL then
1480: select wip_acct_class_code
1481: into V_PRJ_DEF_CLASS
1482: from mrp_project_parameters mpp
1483: where
1484: mpp.project_id = X_PROJECT_ID and
1485: mpp.organization_id = X_ORG_ID;
1486: end if;

Line 1496: from mrp_project_parameters mpp

1492: -- Average Costing Organization
1493: if X_PROJECT_ID IS NOT NULL then
1494: select NVL(costing_group_id,1), wip_acct_class_code
1495: into V_COST_GROUP_ID, V_PRJ_DEF_CLASS
1496: from mrp_project_parameters mpp
1497: where
1498: mpp.project_id = X_PROJECT_ID and
1499: mpp.organization_id = X_ORG_ID;
1500: else

Line 1550: -- Default from mrp_project_parameters

1546: return(NULL);
1547: end if;
1548: end if;
1549: elsif X_PROJECT_ID is not NULL and V_PRJ_DEF_CLASS is not null then
1550: -- Default from mrp_project_parameters
1551:
1552: V_DISC_CLASS := V_PRJ_DEF_CLASS;
1553: v_ret := relall_check_disabled(V_DISC_CLASS, X_ORG_ID, X_ENTITY_TYPE);
1554: if( v_ret = 1) then

Line 1562: -- in mrp_project_parameters or wip_def_cat_acc_classes

1558: end if;
1559: else
1560: return(NULL);
1561: -- Project Id is defined but no class defined
1562: -- in mrp_project_parameters or wip_def_cat_acc_classes
1563: end if;
1564:
1565: exception
1566: when NO_DATA_FOUND then