This discussion is archived
0 Replies Latest reply: Jul 5, 2013 4:14 AM by user605933 RSS

po_tax_codes_summary_v is not available in R12

user605933 Newbie
Currently Being Moderated

Hi All,

 

po_tax_codes_summary_v is not available in R12, Could you please let me know the equivalent table in R12.

 

Somewhere in document I came to know we have to follow the below step. Could you please advise how to follow the same.

Added ORG_ID

• Removed the

references to

client_info

• Only driving table

would have secured

synonym so that the

security policy function

is invoked just once,

rest of the tables should

be base tables (_ALL

tables).

• Join for ORG_ID

across _ALL tables if

the table UK/PK

includes ORG_ID.

Example for this would

be

PO_DOCUMENT_TY

PES that needs

ORG_ID join when

joining to other tables

with Document Type /

Subtype.

• Removed NVL for

ORG_ID joins

 

Regards,

Sushant

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points