APPS.MRP_DEFAULT_FLOW_SCHEDULE SQL Statements

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

Line: 35

  SELECT alternate_routing_designator
  FROM bom_operational_routings
  WHERE line_id = p_line_id
  AND assembly_item_id = p_item_id
  AND organization_id = p_org_id
  AND cfm_routing_flag = 1
  ORDER BY alternate_routing_designator desc;

Line: 243

            SELECT wip_acct_class_code, project_number
            INTO l_class_code, l_project_name
            FROM mrp_project_parameters_v
            WHERE project_id = l_project_id
            AND organization_id = g_flow_schedule_rec.organization_id;

Line: 285

                SELECT default_discrete_class
                INTO l_default_class
                FROM wip_parameters
                WHERE organization_id = g_flow_schedule_rec.organization_id;

Line: 509

      SELECT line_id
      INTO l_line_id
      FROM bom_operational_routings
      WHERE cfm_routing_flag = 1
        AND ((alternate_routing_designator IS NULL) OR
		(alternate_routing_designator IS NOT NULL
		AND priority = (SELECT min(priority)
		FROM bom_operational_routings
		WHERE cfm_routing_flag = 1
                  AND assembly_item_id = g_flow_schedule_rec.primary_item_id
                  AND organization_id = g_flow_schedule_rec.organization_id
                  AND NOT EXISTS (SELECT line_id FROM bom_operational_routings
              		WHERE cfm_routing_flag = 1
			AND alternate_routing_designator IS NULL
                        AND assembly_item_id = g_flow_schedule_rec.primary_item_id
                        AND organization_id = g_flow_schedule_rec.organization_id
			))))
        AND assembly_item_id = g_flow_schedule_rec.primary_item_id
        AND organization_id = g_flow_schedule_rec.organization_id;

Line: 557

        SELECT MATERIAL_ACCOUNT
        INTO l_material_account
        FROM WIP_ACCOUNTING_CLASSES
        WHERE CLASS_CODE = g_flow_schedule_rec.class_code
        AND ORGANIZATION_ID = g_flow_schedule_rec.organization_id;

Line: 599

        SELECT MATERIAL_OVERHEAD_ACCOUNT
        INTO l_material_overhead_account
        FROM WIP_ACCOUNTING_CLASSES
        WHERE CLASS_CODE = g_flow_schedule_rec.class_code
        AND ORGANIZATION_ID = g_flow_schedule_rec.organization_id;

Line: 641

        SELECT MATERIAL_VARIANCE_ACCOUNT
        INTO l_material_variance_account
        FROM WIP_ACCOUNTING_CLASSES
        WHERE CLASS_CODE = g_flow_schedule_rec.class_code
        AND ORGANIZATION_ID = g_flow_schedule_rec.organization_id;

Line: 710

        SELECT OUTSIDE_PROCESSING_ACCOUNT
        INTO l_outside_processing_acct
        FROM WIP_ACCOUNTING_CLASSES
        WHERE CLASS_CODE = g_flow_schedule_rec.class_code
        AND ORGANIZATION_ID = g_flow_schedule_rec.organization_id;

Line: 752

        SELECT OUTSIDE_PROC_VARIANCE_ACCOUNT
        INTO l_outside_proc_var_acct
        FROM WIP_ACCOUNTING_CLASSES
        WHERE CLASS_CODE = g_flow_schedule_rec.class_code
        AND ORGANIZATION_ID = g_flow_schedule_rec.organization_id;

Line: 794

        SELECT OVERHEAD_ACCOUNT
        INTO l_overhead_account
        FROM WIP_ACCOUNTING_CLASSES
        WHERE CLASS_CODE = g_flow_schedule_rec.class_code
        AND ORGANIZATION_ID = g_flow_schedule_rec.organization_id;

Line: 836

        SELECT OVERHEAD_VARIANCE_ACCOUNT
        INTO l_overhead_variance_account
        FROM WIP_ACCOUNTING_CLASSES
        WHERE CLASS_CODE = g_flow_schedule_rec.class_code
        AND ORGANIZATION_ID = g_flow_schedule_rec.organization_id;

Line: 908

    SELECT USERENV( 'SESSIONID' )
    INTO l_request_id
    FROM DUAL;

Line: 928

        SELECT RESOURCE_ACCOUNT
        INTO l_resource_account
        FROM WIP_ACCOUNTING_CLASSES
        WHERE CLASS_CODE = g_flow_schedule_rec.class_code
        AND ORGANIZATION_ID = g_flow_schedule_rec.organization_id;

Line: 970

        SELECT RESOURCE_VARIANCE_ACCOUNT
        INTO l_resource_variance_account
        FROM WIP_ACCOUNTING_CLASSES
        WHERE CLASS_CODE = g_flow_schedule_rec.class_code
        AND ORGANIZATION_ID = g_flow_schedule_rec.organization_id;

Line: 1145

        SELECT NVL(FIXED_LEAD_TIME,0),
		NVL(VARIABLE_LEAD_TIME,0)
	INTO l_fixed_lead_time, l_variable_lead_time
        FROM MTL_SYSTEM_ITEMS
        WHERE INVENTORY_ITEM_ID = g_flow_schedule_rec.primary_item_id
        AND ORGANIZATION_ID = g_flow_schedule_rec.organization_id;

Line: 1152

        SELECT start_time, stop_time
        INTO   l_start_time, l_end_time
        FROM   wip_lines
        WHERE  line_id = g_flow_schedule_rec.line_id
        AND  organization_id = g_flow_schedule_rec.organization_id;

Line: 1282

        SELECT STD_COST_ADJUSTMENT_ACCOUNT
        INTO l_std_cost_adjustment_acct
        FROM WIP_ACCOUNTING_CLASSES
        WHERE CLASS_CODE = g_flow_schedule_rec.class_code
        AND ORGANIZATION_ID = g_flow_schedule_rec.organization_id;

Line: 1328

    SELECT WIP_ENTITIES_S.nextval
    INTO l_wip_entity_id
    FROM DUAL;

Line: 2540

    IF g_flow_schedule_rec.last_updated_by = FND_API.G_MISS_NUM THEN

        g_flow_schedule_rec.last_updated_by := NULL;

Line: 2546

    IF g_flow_schedule_rec.last_update_date = FND_API.G_MISS_DATE THEN

        g_flow_schedule_rec.last_update_date := NULL;

Line: 2552

    IF g_flow_schedule_rec.last_update_login = FND_API.G_MISS_NUM THEN

        g_flow_schedule_rec.last_update_login := NULL;

Line: 2570

    IF g_flow_schedule_rec.program_update_date = FND_API.G_MISS_DATE THEN

        g_flow_schedule_rec.program_update_date := NULL;

Line: 2624

    OR  g_flow_schedule_rec.last_updated_by = FND_API.G_MISS_NUM
    OR  g_flow_schedule_rec.last_update_date = FND_API.G_MISS_DATE
    OR  g_flow_schedule_rec.last_update_login = FND_API.G_MISS_NUM
    OR  g_flow_schedule_rec.line_id = FND_API.G_MISS_NUM
    OR  g_flow_schedule_rec.material_account = FND_API.G_MISS_NUM
    OR  g_flow_schedule_rec.material_overhead_account = FND_API.G_MISS_NUM
    OR  g_flow_schedule_rec.material_variance_account = FND_API.G_MISS_NUM
    OR  g_flow_schedule_rec.mps_net_quantity = FND_API.G_MISS_NUM
    OR  g_flow_schedule_rec.mps_scheduled_comp_date = FND_API.G_MISS_DATE
    OR  g_flow_schedule_rec.organization_id = FND_API.G_MISS_NUM
    OR  g_flow_schedule_rec.outside_processing_acct = FND_API.G_MISS_NUM
    OR  g_flow_schedule_rec.outside_proc_var_acct = FND_API.G_MISS_NUM
    OR  g_flow_schedule_rec.overhead_account = FND_API.G_MISS_NUM
    OR  g_flow_schedule_rec.overhead_variance_account = FND_API.G_MISS_NUM
    OR  g_flow_schedule_rec.planned_quantity = FND_API.G_MISS_NUM
    OR  g_flow_schedule_rec.primary_item_id = FND_API.G_MISS_NUM
    OR  g_flow_schedule_rec.program_application_id = FND_API.G_MISS_NUM
    OR  g_flow_schedule_rec.program_id = FND_API.G_MISS_NUM
    OR  g_flow_schedule_rec.program_update_date = FND_API.G_MISS_DATE
    OR  g_flow_schedule_rec.project_id = FND_API.G_MISS_NUM
    OR  g_flow_schedule_rec.quantity_completed = FND_API.G_MISS_NUM
    OR  g_flow_schedule_rec.request_id = FND_API.G_MISS_NUM
    OR  g_flow_schedule_rec.resource_account = FND_API.G_MISS_NUM
    OR  g_flow_schedule_rec.resource_variance_account = FND_API.G_MISS_NUM
    OR  g_flow_schedule_rec.routing_revision = FND_API.G_MISS_CHAR
    OR  g_flow_schedule_rec.routing_revision_date = FND_API.G_MISS_DATE
    OR  g_flow_schedule_rec.scheduled_completion_date = FND_API.G_MISS_DATE
    OR  g_flow_schedule_rec.scheduled_flag = FND_API.G_MISS_NUM
    OR  g_flow_schedule_rec.scheduled_start_date = FND_API.G_MISS_DATE
    OR  g_flow_schedule_rec.schedule_group_id = FND_API.G_MISS_NUM
    OR  g_flow_schedule_rec.schedule_number = FND_API.G_MISS_CHAR
    OR  g_flow_schedule_rec.status = FND_API.G_MISS_NUM
    OR  g_flow_schedule_rec.std_cost_adjustment_acct = FND_API.G_MISS_NUM
    OR  g_flow_schedule_rec.task_id = FND_API.G_MISS_NUM
    OR  g_flow_schedule_rec.wip_entity_id = FND_API.G_MISS_NUM
    THEN

        MRP_Default_Flow_Schedule.Attributes
        (   p_flow_schedule_rec           => g_flow_schedule_rec
        ,   p_iteration                   => nvl(p_iteration, 1) + 1
        ,   x_flow_schedule_rec           => x_flow_schedule_rec
        );