APPS.INV_PO_THIRD_PARTY_STOCK_MDTR SQL Statements

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

Line: 91

  SELECT
    NVL(org_id,-99)
  FROM
    financials_system_parameters;

Line: 107

  SELECT
    vendor_id
  , org_id
  INTO
    l_vendor_id
  , l_vs_org_id
  FROM
    po_vendor_sites_all
  WHERE vendor_site_id = l_vendor_site_id;

Line: 197

      SELECT
        org_id
      INTO
        l_org_id
      FROM
        po_vendor_sites_all
      WHERE vendor_site_id = l_vendor_site_id;

Line: 205

      SELECT
        user_defined_po_num_code
      INTO
        l_po_num_code
      FROM
        po_system_parameters_all
      WHERE  NVL(org_id,-99) = NVL(l_org_id,-99);

Line: 897

  SELECT COUNT(*)
  INTO l_bill_date_elapsed
  FROM po_asl_attributes
  WHERE TRUNC(last_billing_date) +
        NVL(consigned_billing_cycle,0) > TRUNC(SYSDATE)
  AND asl_id = l_asl_id ;

Line: 913

PROCEDURE update_asl
( p_asl_id        IN NUMBER
)
IS
l_asl_id             NUMBER;

Line: 924

  UPDATE
    po_asl_attributes
  SET last_billing_date = SYSDATE
  WHERE asl_id = l_asl_id;

Line: 929

END update_asl;

Line: 1132

  SELECT
    NVL(global_agreement_flag,'N')
  INTO
    l_global_agreement_flag
  FROM
    po_headers_all
  WHERE
    po_header_id = l_transaction_source_id;