eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_LABEL_PVT10 dependencies on HZ_CUST_ACCOUNT_ROLES

Line 803: -- from "HZ_PARTIES", "HZ_CUST_ACCOUNTS", "HZ_CUST_ACCOUNT_ROLES",

799: -- Modification Start for Bug # - 4418524
800: --
801: -- As part of TCA related changes ra_customers, ra_contacts views are
802: -- obsoleted in R12. The columns fetched from these views are fetched
803: -- from "HZ_PARTIES", "HZ_CUST_ACCOUNTS", "HZ_CUST_ACCOUNT_ROLES",
804: -- "HZ_CUST_ACCOUNTS", "HZ_RELATIONSHIPS".
805: --
806: -- Following declarations are commented.
807: --

Line 1059: -- from "HZ_PARTIES", "HZ_CUST_ACCOUNTS", "HZ_CUST_ACCOUNT_ROLES",

1055: -- Modification Start for Bug # - 4418524
1056: --
1057: -- As part of TCA related changes ra_customers, ra_contacts views are
1058: -- obsoleted in R12. The columns fetched from these views are fetched
1059: -- from "HZ_PARTIES", "HZ_CUST_ACCOUNTS", "HZ_CUST_ACCOUNT_ROLES",
1060: -- "HZ_CUST_ACCOUNTS", "HZ_RELATIONSHIPS".
1061: --
1062: -- Following six table alias are commented
1063: --, ra_customers oline_rc

Line 1089: FROM hz_cust_account_roles ACCT_ROLE,

1085: , ( SELECT ACCT_ROLE.cust_account_role_id contact_id,
1086: ACCT_ROLE.cust_account_id customer_id,
1087: SUBSTRB(PARTY.person_last_name,1,50) last_name,
1088: SUBSTRB(PARTY.person_first_name,1,40) first_name
1089: FROM hz_cust_account_roles ACCT_ROLE,
1090: hz_parties PARTY,
1091: hz_relationships REL,
1092: hz_cust_accounts ROLE_ACCT
1093: WHERE

Line 1106: FROM hz_cust_account_roles ACCT_ROLE,

1102: , ( SELECT ACCT_ROLE.cust_account_role_id contact_id,
1103: ACCT_ROLE.cust_account_id customer_id,
1104: SUBSTRB(PARTY.person_last_name,1,50) last_name,
1105: SUBSTRB(PARTY.person_first_name,1,40) first_name
1106: FROM hz_cust_account_roles ACCT_ROLE,
1107: hz_parties PARTY,
1108: hz_relationships REL,
1109: hz_cust_accounts ROLE_ACCT
1110: WHERE

Line 1123: FROM hz_cust_account_roles ACCT_ROLE,

1119: , ( SELECT ACCT_ROLE.cust_account_role_id contact_id,
1120: ACCT_ROLE.cust_account_id customer_id,
1121: SUBSTRB(PARTY.person_last_name,1,50) last_name,
1122: SUBSTRB(PARTY.person_first_name,1,40) first_name
1123: FROM hz_cust_account_roles ACCT_ROLE,
1124: hz_parties PARTY,
1125: hz_relationships REL,
1126: hz_cust_accounts ROLE_ACCT
1127: WHERE

Line 1140: FROM hz_cust_account_roles ACCT_ROLE,

1136: , ( SELECT ACCT_ROLE.cust_account_role_id contact_id,
1137: ACCT_ROLE.cust_account_id customer_id,
1138: SUBSTRB(PARTY.person_last_name,1,50) last_name,
1139: SUBSTRB(PARTY.person_first_name,1,40) first_name
1140: FROM hz_cust_account_roles ACCT_ROLE,
1141: hz_parties PARTY,
1142: hz_relationships REL,
1143: hz_cust_accounts ROLE_ACCT
1144: WHERE

Line 1157: FROM hz_cust_account_roles ACCT_ROLE,

1153: , ( SELECT ACCT_ROLE.cust_account_role_id contact_id,
1154: ACCT_ROLE.cust_account_id customer_id,
1155: SUBSTRB(PARTY.person_last_name,1,50) last_name,
1156: SUBSTRB(PARTY.person_first_name,1,40) first_name
1157: FROM hz_cust_account_roles ACCT_ROLE,
1158: hz_parties PARTY,
1159: hz_relationships REL,
1160: hz_cust_accounts ROLE_ACCT
1161: WHERE

Line 1607: -- from "HZ_PARTIES", "HZ_CUST_ACCOUNTS", "HZ_CUST_ACCOUNT_ROLES",

1603: -- Modification Start for Bug # - 4418524
1604: --
1605: -- As part of TCA related changes ra_customers, ra_contacts views are
1606: -- obsoleted in R12. The columns fetched from these views are fetched
1607: -- from "HZ_PARTIES", "HZ_CUST_ACCOUNTS", "HZ_CUST_ACCOUNT_ROLES",
1608: -- "HZ_CUST_ACCOUNTS", "HZ_RELATIONSHIPS".
1609: --
1610: -- Following six table alias are commented
1611: --, ra_contacts rcship

Line 1623: FROM hz_cust_account_roles ACCT_ROLE,

1619: , ( SELECT ACCT_ROLE.cust_account_role_id contact_id,
1620: ACCT_ROLE.cust_account_id customer_id,
1621: SUBSTRB(PARTY.person_last_name,1,50) last_name,
1622: SUBSTRB(PARTY.person_first_name,1,40) first_name
1623: FROM hz_cust_account_roles ACCT_ROLE,
1624: hz_parties PARTY,
1625: hz_relationships REL,
1626: hz_cust_accounts ROLE_ACCT
1627: WHERE

Line 1640: FROM hz_cust_account_roles ACCT_ROLE,

1636: , ( SELECT ACCT_ROLE.cust_account_role_id contact_id,
1637: ACCT_ROLE.cust_account_id customer_id,
1638: SUBSTRB(PARTY.person_last_name,1,50) last_name,
1639: SUBSTRB(PARTY.person_first_name,1,40) first_name
1640: FROM hz_cust_account_roles ACCT_ROLE,
1641: hz_parties PARTY,
1642: hz_relationships REL,
1643: hz_cust_accounts ROLE_ACCT
1644: WHERE

Line 1657: FROM hz_cust_account_roles ACCT_ROLE,

1653: , ( SELECT ACCT_ROLE.cust_account_role_id contact_id,
1654: ACCT_ROLE.cust_account_id customer_id,
1655: SUBSTRB(PARTY.person_last_name,1,50) last_name,
1656: SUBSTRB(PARTY.person_first_name,1,40) first_name
1657: FROM hz_cust_account_roles ACCT_ROLE,
1658: hz_parties PARTY,
1659: hz_relationships REL,
1660: hz_cust_accounts ROLE_ACCT
1661: WHERE

Line 1674: FROM hz_cust_account_roles ACCT_ROLE,

1670: , ( SELECT ACCT_ROLE.cust_account_role_id contact_id,
1671: ACCT_ROLE.cust_account_id customer_id,
1672: SUBSTRB(PARTY.person_last_name,1,50) last_name,
1673: SUBSTRB(PARTY.person_first_name,1,40) first_name
1674: FROM hz_cust_account_roles ACCT_ROLE,
1675: hz_parties PARTY,
1676: hz_relationships REL,
1677: hz_cust_accounts ROLE_ACCT
1678: WHERE