Thursday, 11 September 2014

Lov Process

/* Formatted on 9/11/2014 11:38:40 AM (QP5 v5.115.810.9015) */
SELECT fds.doc_category_name, fds.description, fds.doc_category_code
FROM fnd_document_sequences_ap_v fds
WHERE fds.doc_category_name IN
            (SELECT code
             FROM fnd_doc_sequence_categories a, fnd_lookup_values b
             WHERE b.meaning = a.code AND lookup_type = 'AP_DOC_CATG_MANAGER')
      OR (doc_category_name IN
                (SELECT subscriber_name
                 FROM la_br_subscriber_lists a, la_br_subscriber_elements b
                 WHERE     b.filter_value = fnd_profile.VALUE ('USER_ID')
                       AND b.filter_type = 6
                       AND a.subscriber_list_id = b.subscriber_list_id
                       AND description LIKE '%AP Invoice Type%'))


/* Formatted on 9/11/2014 3:50:27 PM (QP5 v5.115.810.9015) */
SELECT lookup_code, displayed_field, description
FROM ap_lc_invoice_types_v
WHERE (lookup_code IN ('STANDARD', 'CREDIT')
       OR (lookup_code IN
                 (SELECT subscriber_name
                  FROM la_br_subscriber_lists a, la_br_subscriber_elements b
                  WHERE     b.filter_value = fnd_profile.VALUE ('USER_ID')
                        AND b.filter_type = 6
                        AND a.subscriber_list_id = b.subscriber_list_id
                        AND description LIKE '%AP Invoice Type%')))
ORDER BY DECODE (lookup_code, 'STANDARD', 1, 'MIXED', 99, 2), displayed_field

1 comment:

  1. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, BI Publisher, OAF, ADF, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete