APPS.JL_ZZ_PO_LIBRARY_1_PKG SQL Statements

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

Line: 14

    SELECT fcc.meaning,
           tn.meaning
    INTO   fcc_code,
           tran_nat
    FROM   mtl_system_items mtl, fnd_lookups fcc, fnd_lookups tn
    WHERE  fcc.lookup_code = SUBSTR (mtl.global_attribute1, 1, 25)
    AND    fcc.lookup_type = fcc_code_type
    AND    tn.lookup_code = SUBSTR (mtl.global_attribute2, 1, 25)
    AND    tn.lookup_type = tran_nat_type
    AND    mtl.organization_id = so_org_id
    AND    mtl.inventory_item_id = inv_item_id
    AND    rownum = row_number;

Line: 38

    SELECT SUM (global_attribute6)
    INTO   total_tax
    FROM   po_line_locations_all
    WHERE  po_header_id = po_header_id
    AND    rownum = row_number;

Line: 56

    SELECT global_attribute1
    INTO   fc_code
    FROM   mtl_system_items mtl
    WHERE  mtl.organization_id = form_org_id
    AND    inventory_item_id = form_item_id
    AND    rownum = row_number;

Line: 79

    SELECT global_attribute1, global_attribute2,
           global_attribute3, global_attribute4,
           global_attribute5, global_attribute6
    INTO   ga1, ga2, ga3, ga4, ga5, ga6
    FROM   po_line_locations_all
    WHERE  line_location_id = form_line_loca_id
    AND    rownum = row_number;

Line: 99

    SELECT SUM (global_attribute6)
    INTO   total_tax
    FROM   po_line_locations_all
    WHERE  po_header_id = po_header_id2
    AND    po_release_id = po_release_id2
    AND    rownum = row_number;

Line: 116

    SELECT SUBSTR (description, 1, 30)
    INTO   global_description
    FROM   fnd_descr_flex_contexts_vl
    WHERE  application_id = 7003
    AND    descriptive_flexfield_name  = 'JG_PO_SYSTEM_PARAMETERS'
    AND    descriptive_flex_context_code = 'JL.BR.POXSTDPO.PO_OPTIONS'
    AND    enabled_flag = 'Y'
    AND    rownum = row_number;

Line: 138

    SELECT global_attribute2, global_attribute1
    INTO   trx_reason, fcc
    FROM   mtl_system_items mtl
    WHERE  mtl.organization_id = org_id
    AND    mtl.inventory_item_id = item_id
    AND    rownum = row_number;

Line: 155

    SELECT global_attribute1
    INTO   trx_reason
    FROM   po_system_parameters
    WHERE    rownum = row_number;

Line: 171

    SELECT displayed_field
    INTO   disp_field
    FROM   po_lookup_codes
    WHERE  lookup_code = tran_code
    AND    rownum = row_number;

Line: 201

    SELECT   global_attribute3
      FROM   PO_SYSTEM_PARAMETERS_ALL
      WHERE  org_id = c_org_id;

Line: 207

    SELECT   global_attribute3
      FROM   PO_SYSTEM_PARAMETERS_ALL;

Line: 258

    SELECT   global_attribute1
      FROM   PO_SYSTEM_PARAMETERS_ALL;

Line: 264

    SELECT   global_attribute1
      FROM   PO_SYSTEM_PARAMETERS_ALL
      WHERE  org_id = c_org_id;