DBA Data[Home] [Help]

APPS.MRP_ID_TO_VALUE SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 20

    FND_API.g_attr_tbl.DELETE;
Line: 110

        SELECT  LINE_CODE
        INTO    l_line
        FROM    WIP_LINES
        WHERE   LINE_ID = p_line_id;
Line: 157

        SELECT  ORGANIZATION_CODE
        INTO    l_organization
        FROM    ORG_ORGANIZATION_DEFINITIONS
        WHERE   ORGANIZATION_ID = p_organization_id;
Line: 253

        SELECT  PROJECT_NAME
        INTO    l_project
        FROM    MTL_PROJECT_V
        WHERE   PROJECT_ID = p_project_id;
Line: 300

        SELECT  SCHEDULE_GROUP_NAME
        INTO    l_schedule_group
        FROM    WIP_SCHEDULE_GROUPS
        WHERE   SCHEDULE_GROUP_ID = p_schedule_group_id;