DBA Data[Home] [Help]

APPS.PO_INQ_SV dependencies on HZ_RELATIONSHIPS

Line 2000: --SQL Why: Get vendor_name from hz_parties via hz_relationships starting

1996:
1997: BEGIN
1998:
1999: --SQL What: Query vendor name based on log on name
2000: --SQL Why: Get vendor_name from hz_parties via hz_relationships starting
2001: -- from fnd_user.user_name
2002: /* Patch 12345138 Modified the query because the query based on old
2003: datamodel was not fetching any records*/
2004: SELECT ap.vendor_name

Line 2006: FROM hz_relationships hzr,

2002: /* Patch 12345138 Modified the query because the query based on old
2003: datamodel was not fetching any records*/
2004: SELECT ap.vendor_name
2005: INTO x_vendor_name
2006: FROM hz_relationships hzr,
2007: hz_parties hp,
2008: fnd_user fu,
2009: ap_suppliers ap,
2010: hz_party_usg_assignments hpua