Oracle Apps Technical Information

SELECT ROWNUM, rc.customer_name customer_name, rct_og.trx_number trx_number,rct.trx_number credit_note_num ,       rct.trx_date trx_date, msi.segment1 item_code,        rcta.quantity_invoiced quantity, rcta.description description,        TRUNC (rct_og.creation_date) "CREATION_DATE", f.user_name user_name,        xx_tax_utl_pub.get_tax_reg_num (rc.customer_id,                                        rct.org_id) tax_reg_num,        raa.address1 address1, raa.address2 address2,        apsa_og.amount_line_items_original original_amount,        apsa_og.amount_line_items_remaining credit_amount, rcta.line_type    FROM ra_customer_trx_all rct, --       ra_customer_trx_partial_v rctpv,      ...

What is VPD VPD combines these two features, enabling you to enforce security policies to control access at the row level. This control is based on application or session attributes, which can be made available during execution. CREATE OR REPLACE FUNCTION hide_sal_comm (  v_schema IN VARCHAR2,   v_objname IN VARCHAR2) RETURN VARCHAR2 AS con VARCHAR2 (200); BEGIN -- con := 'LINE_TYPE_LOOKUP_CODE=''ITEM'''; con := 'INVOICE_ID=81552';  RETURN (con); END hide_sal_comm; BEGIN  DBMS_RLS.ADD_POLICY (   object_schema     => 'apps',    object_name       => 'AP_INVOICE_LINES_ALL',   policy_name       => 'hide_sal_policy',    policy_function   => 'hide_sal_comm',   sec_relevant_cols => null); END; BEGIN    -- to drop a existing policy    DBMS_RLS.drop_POLICY (object_schema  ...