APPS.POS_OSP_JOB SQL Statements

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

Line: 8

  select count(*)
  into x_count
  from po_distributions_all
  where line_location_id = po_line_location_id and
        wip_entity_id is not null;

Line: 27

    select ltrim(wipe.wip_entity_name || '-' || wipl.line_code || '-' || pod.wip_operation_seq_num)
    into job_info
    from po_distributions_all pod,
         wip_entities wipe,
         wip_lines wipl
    where pod.line_location_id = po_line_location_id and
          pod.wip_entity_id is not null and
          pod.wip_entity_id = wipe.wip_entity_id and
          pod.wip_line_id = wipl.line_id(+);

Line: 55

    select ltrim(wipe.wip_entity_name || '-' || wipl.line_code || '-' || pod.wip_operation_seq_num)
    into job_info
    from po_distributions_all pod,
         wip_entities wipe,
         wip_lines wipl
    where pod.po_distribution_id = po_distributions_id and
          pod.wip_entity_id is not null and
          pod.wip_entity_id = wipe.wip_entity_id and
          pod.wip_line_id = wipl.line_id(+);

Line: 75

    select po_distribution_id
    into x_id
    from po_distributions_all
    where line_location_id = po_line_location_id and
         wip_entity_id is not null;

Line: 94

    select wip_entity_id
    into x_id
    from po_distributions_all
    where line_location_id = po_line_location_id and
         wip_entity_id is not null;

Line: 113

    select wip_operation_seq_num
    into x_id
    from po_distributions_all
    where line_location_id = po_line_location_id and
         wip_entity_id is not null;

Line: 132

    select wip_line_id
    into x_id
    from po_distributions_all
    where line_location_id = po_line_location_id and
         wip_entity_id is not null;