APPS.WIP_REQUIREMENT_DEFAULT SQL Statements

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

Line: 51

        SELECT start_quantity, scheduled_start_date
          INTO X_start_quantity, x_scheduled_start_date
          FROM WIP_DISCRETE_JOBS
         WHERE wip_entity_id = p_wip_entity_id
           AND organization_id = p_organization_id;

Line: 73

         SELECT department_Id, first_unit_start_date, first_unit_start_date
           INTO x_department_id, x_date_required, x_MPS_date_required
           FROM WIP_OPERATIONS
          WHERE wip_entity_id = p_wip_entity_id
            AND organization_id = p_organization_id
            AND operation_seq_num = p_operation_seq_num;

Line: 89

         SELECT wip_supply_type, wip_supply_subinventory, wip_supply_locator_id
           INTO  x_wip_supply_type, x_supply_subinventory, x_supply_locator_id
           FROM MTL_SYSTEM_ITEMS
          WHERE inventory_item_id = p_inventory_item_id_new
            AND organization_id = p_organization_id;

Line: 98

	SELECT  wip_supply_type
	INTO    X_temp_wip_supply_type
	FROM    WIP_JOB_DTLS_INTERFACE
	WHERE   group_id = p_group_id
        AND     wip_entity_id = p_wip_entity_id
        AND     organization_id = p_organization_id
        AND     load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT
        AND     substitution_type = p_substitution_type
        AND     operation_seq_num = p_operation_seq_num
        AND     inventory_item_id_new = p_inventory_item_id_new;

Line: 112

	   SELECT default_pull_supply_subinv, default_pull_supply_locator_id
	     INTO x_supply_subinventory, x_supply_locator_id
	     FROM WIP_PARAMETERS
	    WHERE organization_id = p_organization_id;

Line: 122

        select wdj.wip_supply_type, wdj.job_type, we.entity_type
        into   X_temp_wip_supply_type, X_job_type, X_entity_type
        from wip_entities we,
           wip_discrete_jobs wdj
        where  wdj.wip_entity_id = p_wip_entity_id
        and    wdj.organization_id = p_organization_id
        and wdj.wip_entity_id = we.wip_entity_id
        and wdj.organization_id = we.organization_id ;

Line: 154

            SELECT component_sequence_id
            into   X_comp_seq_id
            FROM   wip_requirement_operations
            WHERE  wip_entity_id            = p_wip_entity_id
            AND    organization_id          = p_organization_id
            AND    operation_seq_num        = p_operation_seq_num
            AND    inventory_item_id        = p_inventory_item_id_old;

Line: 162

            select substitute_item_quantity
            into   X_substitute_item_quantity
            from   bom_substitute_components
            where  substitute_component_id = p_inventory_item_id_new
            and    component_sequence_id = X_comp_seq_id
            and    acd_type is null ;

Line: 179

        UPDATE WIP_JOB_DTLS_INTERFACE
        SET     quantity_issued         = Decode(p_substitution_type,WIP_JOB_DETAILS.WIP_ADD,0,quantity_issued),
                quantity_per_assembly   = round(X_quantity_per_assembly, 6),
                department_id           = x_department_id,
                wip_supply_type         = nvl(wip_supply_type,x_wip_supply_type),
                date_required           = nvl(date_required,x_date_required),
                required_quantity       = nvl(required_quantity,x_required_quantity),
                supply_subinventory     = nvl(supply_subinventory,x_supply_subinventory),
/* Fix for bug 3138448. Added Decode to default supply locator id only when supply
   subinventory is null.
                supply_locator_id       = nvl(supply_locator_id,x_supply_locator_id),
*/
                supply_locator_id       = Decode(nvl(supply_subinventory,'@@@'),
                                                  '@@@',x_supply_locator_id,
                                                   supply_locator_id),
                mrp_net_flag            = nvl(mrp_net_flag,x_mrp_net_flag),
                mps_required_quantity   = nvl(required_quantity,x_mps_required_quantity), /*Bug 4369064 */
                mps_date_required       = nvl(mps_date_required,x_mps_date_required),
                component_yield_factor  = round(x_quantity_per_assembly * decode(p_basis_type,
                                                                                 wip_constants.lot_based_mtl,
                                                                                 1,
                                                                                 X_start_quantity) /
                                          nvl(required_quantity,x_required_quantity),6)
                             /*Component Yield Enhancement(Bug 4369064)->default component yield factor based on
                               required quantity and qpa */
        WHERE   group_id = p_group_id
        AND     wip_entity_id = p_wip_entity_id
        AND     organization_id = p_organization_id
        AND     load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT
        AND     substitution_type = p_substitution_type
        AND     operation_seq_num = p_operation_seq_num
        AND     inventory_item_id_new = p_inventory_item_id_new;