APPS.CSD_WF_PROCESS_PVT SQL Statements

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

Line: 34

select sr.cont_email,
       sr.incident_number,
       ro.repair_number,
       ro.serial_number,
       sr.item,
       decode(sr.contact_type,'EMPLOYEE',sr.first_name||' '||sr.last_name,sr.full_name) contact_name
from csd_incidents_v sr,
     csd_repairs ro
where ro.incident_id  = sr.incident_id
and ro.repair_line_id = p_repair_line_id;

Line: 47

Select wr.name
from wf_roles wr,
     cs_incidents_v sr,
     csd_repairs    ro
where ro.repair_line_id = p_repair_line_id
and ro.incident_id = sr.incident_id
and wr.orig_system_id = sr.contact_party_id
and wr.orig_system = 'HZ_PARTY'
and nvl(wr.expiration_date,sysdate) >= sysdate
and wr.status = 'ACTIVE';

Line: 183

select sr.cont_email,
       sr.incident_number,
       ro.repair_number,
       ro.serial_number,
       ro.item,
       ro.flow_status,
       decode(sr.contact_type,'EMPLOYEE',sr.first_name||' '||sr.last_name,sr.full_name) contact_name
from csd_incidents_v sr,
     csd_repairs_v ro
where ro.incident_id  = sr.incident_id
and ro.repair_line_id = p_repair_line_id;

Line: 197

Select wr.name
from wf_roles wr,
     cs_incidents_v sr,
     csd_repairs    ro
where ro.repair_line_id = p_repair_line_id
and ro.incident_id = sr.incident_id
and wr.orig_system_id = sr.contact_party_id
and wr.orig_system = 'HZ_PARTY'
and nvl(wr.expiration_date,sysdate) >= sysdate
and wr.status = 'ACTIVE';

Line: 335

Select wr.name, wr.email_address, sr.incident_number,
           ro.repair_number, ro.serial_number,
           ro.flow_status, ro.item,
           cjr.source_first_name, cjr.source_last_name
From wf_roles wr,
     csd_incidents_v sr,
     csd_repairs_v ro,
     CS_JTF_RS_RESOURCE_EXTNS_SEC cjr
Where ro.repair_line_id = p_repair_line_id
and ro.incident_id = sr.incident_id
and wr.orig_system_id = cjr.source_id
and cjr.resource_id = sr.incident_owner_id
and wr.orig_system = 'PER'
and nvl(wr.expiration_date,sysdate) >= sysdate
and wr.status = 'ACTIVE';

Line: 459

select csi.internal_party_id,
       hca.cust_account_id
from csi_install_parameters csi,
     hz_cust_accounts hca
where csi.internal_party_id = hca.party_id(+)
and hca.status(+) = 'A';

Line: 468

select MMT.transaction_id,
       CWTD.wip_entity_id,
       MMT.inventory_item_id,
       MMT.transaction_uom,
       MMT.transaction_quantity,
       MMT.currency_code,
       MMT.organization_id,
       MSI.serial_number_control_code,
       MSI.comms_nl_trackable_flag,
       MUT.serial_number
from csd_repair_job_xref CRJX,
     csd_wip_transaction_details CWTD,
     mtl_material_transactions MMT,
     mtl_system_items MSI,
     mtl_unit_transactions MUT
where CRJX.repair_line_id = p_repair_line_id
and CRJX.wip_entity_id = CWTD.wip_entity_id
and CWTD.create_ro_flag ='T'
and CWTD.wip_entity_id = MMT.transaction_source_id
and MMT.transaction_type_id = 43         --43: WIP Return
and MMT.transaction_source_type_id = 5   -- 5: WIP-related txns
and CWTD.inventory_item_id = MMT.inventory_item_id
and MMT.inventory_item_id = MSI.inventory_item_id
and MMT.organization_id = MSI.organization_id
and MMT.transaction_id = MUT.transaction_id(+)
and NOT EXISTS (select CWT.from_mtl_transaction_id    -- check if RO was previously created for this txn
                from csd_ro_creation_wip_txns CWT
                where CWT.from_mtl_transaction_id = MMT.transaction_id);

Line: 499

select price_list_header_id,
       repair_mode
from csd_repair_types_b
where repair_type_id = p_repair_type_id;

Line: 506

Select instance_id
from csi_item_instances
where serial_number = p_serial_number
and inventory_item_id = p_inventory_item_id;

Line: 744

    INSERT INTO CSD_RO_CREATION_WIP_TXNS(
        repair_order_creation_id,
        repair_line_id,
        from_mtl_transaction_id,
        from_wip_entity_id,
        object_version_number,
        last_update_login,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date)
    VALUES(
        CSD_RO_CREATION_ID_S1.nextval,
        l_repair_line_id,
        l_transaction_id,
        l_wip_entity_id,
        1,
        NVL(fnd_global.LOGIN_ID, -1),
        NVL(fnd_global.USER_ID, -1),
        sysdate,
        NVL(fnd_global.USER_ID, -1),
        sysdate
    );

Line: 771

                        'Inserted transaction id = ' || l_transaction_id || ' into CSD_RO_CREATION_WIP_TXNS');