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_PARTIES

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 820: l_party_id hz_parties.party_id%TYPE;

816: -- Following declarations are added to replace the above commented
817: -- declarations
818: --
819: l_customer_id hz_cust_accounts.cust_account_id%TYPE;
820: l_party_id hz_parties.party_id%TYPE;
821: l_party_number hz_parties.party_number%TYPE;
822: l_customer_name hz_parties.party_name%TYPE;
823: l_invoice_customer_id hz_cust_accounts.cust_account_id%TYPE;
824: l_deliver_customer_id hz_cust_accounts.cust_account_id%TYPE;

Line 821: l_party_number hz_parties.party_number%TYPE;

817: -- declarations
818: --
819: l_customer_id hz_cust_accounts.cust_account_id%TYPE;
820: l_party_id hz_parties.party_id%TYPE;
821: l_party_number hz_parties.party_number%TYPE;
822: l_customer_name hz_parties.party_name%TYPE;
823: l_invoice_customer_id hz_cust_accounts.cust_account_id%TYPE;
824: l_deliver_customer_id hz_cust_accounts.cust_account_id%TYPE;
825: l_ship_to_customer_id hz_cust_accounts.cust_account_id%TYPE;

Line 822: l_customer_name hz_parties.party_name%TYPE;

818: --
819: l_customer_id hz_cust_accounts.cust_account_id%TYPE;
820: l_party_id hz_parties.party_id%TYPE;
821: l_party_number hz_parties.party_number%TYPE;
822: l_customer_name hz_parties.party_name%TYPE;
823: l_invoice_customer_id hz_cust_accounts.cust_account_id%TYPE;
824: l_deliver_customer_id hz_cust_accounts.cust_account_id%TYPE;
825: l_ship_to_customer_id hz_cust_accounts.cust_account_id%TYPE;
826: --

Line 925: -- from hz_parties and hz_cust_accounts.

921: -- Modification Start for Bug # - 4418524
922: --
923: -- As part of TCA related changes ra_customers, ra_contacts views are
924: -- obsoleted in R12. The columns fetched from these views are fetched
925: -- from hz_parties and hz_cust_accounts.
926: --
927: -- Following table alias are commented
928: --, ra_customers ohead_rcs
929: --

Line 941: FROM hz_parties PARTY

937: PARTY.person_first_name person_first_name,
938: PARTY.person_middle_name person_middle_name,
939: PARTY.person_last_name person_last_name,
940: CUST_ACCT.customer_type customer_type
941: FROM hz_parties PARTY
942: , hz_cust_accounts CUST_ACCT
943: WHERE CUST_ACCT.party_id = PARTY.party_id
944: ) ohead_rcs
945: --

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 1081: FROM hz_parties PARTY

1077: PARTY.person_first_name person_first_name,
1078: PARTY.person_middle_name person_middle_name,
1079: PARTY.person_last_name person_last_name,
1080: CUST_ACCT.customer_type customer_type
1081: FROM hz_parties PARTY
1082: , hz_cust_accounts CUST_ACCT
1083: WHERE CUST_ACCT.party_id = PARTY.party_id
1084: ) oline_rc
1085: , ( SELECT ACCT_ROLE.cust_account_role_id contact_id,

Line 1090: hz_parties PARTY,

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
1094: ACCT_ROLE.party_id = REL.party_id

Line 1097: AND REL.subject_table_name = 'HZ_PARTIES'

1093: WHERE
1094: ACCT_ROLE.party_id = REL.party_id
1095: AND ACCT_ROLE.role_type = 'CONTACT'
1096: AND REL.subject_id = PARTY.party_id
1097: AND REL.subject_table_name = 'HZ_PARTIES'
1098: AND REL.object_table_name = 'HZ_PARTIES'
1099: AND ACCT_ROLE.cust_account_id = ROLE_ACCT.cust_account_id
1100: AND ROLE_ACCT.party_id = REL.object_id
1101: ) rcship

Line 1098: AND REL.object_table_name = 'HZ_PARTIES'

1094: ACCT_ROLE.party_id = REL.party_id
1095: AND ACCT_ROLE.role_type = 'CONTACT'
1096: AND REL.subject_id = PARTY.party_id
1097: AND REL.subject_table_name = 'HZ_PARTIES'
1098: AND REL.object_table_name = 'HZ_PARTIES'
1099: AND ACCT_ROLE.cust_account_id = ROLE_ACCT.cust_account_id
1100: AND ROLE_ACCT.party_id = REL.object_id
1101: ) rcship
1102: , ( SELECT ACCT_ROLE.cust_account_role_id contact_id,

Line 1107: hz_parties PARTY,

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
1111: ACCT_ROLE.party_id = REL.party_id

Line 1114: AND REL.subject_table_name = 'HZ_PARTIES'

1110: WHERE
1111: ACCT_ROLE.party_id = REL.party_id
1112: AND ACCT_ROLE.role_type = 'CONTACT'
1113: AND REL.subject_id = PARTY.party_id
1114: AND REL.subject_table_name = 'HZ_PARTIES'
1115: AND REL.object_table_name = 'HZ_PARTIES'
1116: AND ACCT_ROLE.cust_account_id = ROLE_ACCT.cust_account_id
1117: AND ROLE_ACCT.party_id = REL.object_id
1118: ) dcontact

Line 1115: AND REL.object_table_name = 'HZ_PARTIES'

1111: ACCT_ROLE.party_id = REL.party_id
1112: AND ACCT_ROLE.role_type = 'CONTACT'
1113: AND REL.subject_id = PARTY.party_id
1114: AND REL.subject_table_name = 'HZ_PARTIES'
1115: AND REL.object_table_name = 'HZ_PARTIES'
1116: AND ACCT_ROLE.cust_account_id = ROLE_ACCT.cust_account_id
1117: AND ROLE_ACCT.party_id = REL.object_id
1118: ) dcontact
1119: , ( SELECT ACCT_ROLE.cust_account_role_id contact_id,

Line 1124: hz_parties PARTY,

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
1128: ACCT_ROLE.party_id = REL.party_id

Line 1131: AND REL.subject_table_name = 'HZ_PARTIES'

1127: WHERE
1128: ACCT_ROLE.party_id = REL.party_id
1129: AND ACCT_ROLE.role_type = 'CONTACT'
1130: AND REL.subject_id = PARTY.party_id
1131: AND REL.subject_table_name = 'HZ_PARTIES'
1132: AND REL.object_table_name = 'HZ_PARTIES'
1133: AND ACCT_ROLE.cust_account_id = ROLE_ACCT.cust_account_id
1134: AND ROLE_ACCT.party_id = REL.object_id
1135: ) isc

Line 1132: AND REL.object_table_name = 'HZ_PARTIES'

1128: ACCT_ROLE.party_id = REL.party_id
1129: AND ACCT_ROLE.role_type = 'CONTACT'
1130: AND REL.subject_id = PARTY.party_id
1131: AND REL.subject_table_name = 'HZ_PARTIES'
1132: AND REL.object_table_name = 'HZ_PARTIES'
1133: AND ACCT_ROLE.cust_account_id = ROLE_ACCT.cust_account_id
1134: AND ROLE_ACCT.party_id = REL.object_id
1135: ) isc
1136: , ( SELECT ACCT_ROLE.cust_account_role_id contact_id,

Line 1141: hz_parties PARTY,

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
1145: ACCT_ROLE.party_id = REL.party_id

Line 1148: AND REL.subject_table_name = 'HZ_PARTIES'

1144: WHERE
1145: ACCT_ROLE.party_id = REL.party_id
1146: AND ACCT_ROLE.role_type = 'CONTACT'
1147: AND REL.subject_id = PARTY.party_id
1148: AND REL.subject_table_name = 'HZ_PARTIES'
1149: AND REL.object_table_name = 'HZ_PARTIES'
1150: AND ACCT_ROLE.cust_account_id = ROLE_ACCT.cust_account_id
1151: AND ROLE_ACCT.party_id = REL.object_id
1152: ) invc

Line 1149: AND REL.object_table_name = 'HZ_PARTIES'

1145: ACCT_ROLE.party_id = REL.party_id
1146: AND ACCT_ROLE.role_type = 'CONTACT'
1147: AND REL.subject_id = PARTY.party_id
1148: AND REL.subject_table_name = 'HZ_PARTIES'
1149: AND REL.object_table_name = 'HZ_PARTIES'
1150: AND ACCT_ROLE.cust_account_id = ROLE_ACCT.cust_account_id
1151: AND ROLE_ACCT.party_id = REL.object_id
1152: ) invc
1153: , ( SELECT ACCT_ROLE.cust_account_role_id contact_id,

Line 1158: hz_parties PARTY,

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
1162: ACCT_ROLE.party_id = REL.party_id

Line 1165: AND REL.subject_table_name = 'HZ_PARTIES'

1161: WHERE
1162: ACCT_ROLE.party_id = REL.party_id
1163: AND ACCT_ROLE.role_type = 'CONTACT'
1164: AND REL.subject_id = PARTY.party_id
1165: AND REL.subject_table_name = 'HZ_PARTIES'
1166: AND REL.object_table_name = 'HZ_PARTIES'
1167: AND ACCT_ROLE.cust_account_id = ROLE_ACCT.cust_account_id
1168: AND ROLE_ACCT.party_id = REL.object_id
1169: ) shiptoc,

Line 1166: AND REL.object_table_name = 'HZ_PARTIES'

1162: ACCT_ROLE.party_id = REL.party_id
1163: AND ACCT_ROLE.role_type = 'CONTACT'
1164: AND REL.subject_id = PARTY.party_id
1165: AND REL.subject_table_name = 'HZ_PARTIES'
1166: AND REL.object_table_name = 'HZ_PARTIES'
1167: AND ACCT_ROLE.cust_account_id = ROLE_ACCT.cust_account_id
1168: AND ROLE_ACCT.party_id = REL.object_id
1169: ) shiptoc,
1170: --

Line 1258: HZ_PARTIES PARTY,

1254: FROM
1255: HZ_CUST_ACCT_SITES_ALL ACCT_SITE,
1256: HZ_PARTY_SITES PARTY_SITE,
1257: HZ_CUST_SITE_USES_ALL SITE,
1258: HZ_PARTIES PARTY,
1259: HZ_CUST_ACCOUNTS CUST_ACCT,
1260: ORG_ORGANIZATION_DEFINITIONS ORG
1261: WHERE SITE.ORG_ID = ORG.ORGANIZATION_ID
1262: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID

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 1624: hz_parties PARTY,

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
1628: ACCT_ROLE.party_id = REL.party_id

Line 1631: AND REL.subject_table_name = 'HZ_PARTIES'

1627: WHERE
1628: ACCT_ROLE.party_id = REL.party_id
1629: AND ACCT_ROLE.role_type = 'CONTACT'
1630: AND REL.subject_id = PARTY.party_id
1631: AND REL.subject_table_name = 'HZ_PARTIES'
1632: AND REL.object_table_name = 'HZ_PARTIES'
1633: AND ACCT_ROLE.cust_account_id = ROLE_ACCT.cust_account_id
1634: AND ROLE_ACCT.party_id = REL.object_id
1635: ) rcship

Line 1632: AND REL.object_table_name = 'HZ_PARTIES'

1628: ACCT_ROLE.party_id = REL.party_id
1629: AND ACCT_ROLE.role_type = 'CONTACT'
1630: AND REL.subject_id = PARTY.party_id
1631: AND REL.subject_table_name = 'HZ_PARTIES'
1632: AND REL.object_table_name = 'HZ_PARTIES'
1633: AND ACCT_ROLE.cust_account_id = ROLE_ACCT.cust_account_id
1634: AND ROLE_ACCT.party_id = REL.object_id
1635: ) rcship
1636: , ( SELECT ACCT_ROLE.cust_account_role_id contact_id,

Line 1641: hz_parties PARTY,

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
1645: ACCT_ROLE.party_id = REL.party_id

Line 1648: AND REL.subject_table_name = 'HZ_PARTIES'

1644: WHERE
1645: ACCT_ROLE.party_id = REL.party_id
1646: AND ACCT_ROLE.role_type = 'CONTACT'
1647: AND REL.subject_id = PARTY.party_id
1648: AND REL.subject_table_name = 'HZ_PARTIES'
1649: AND REL.object_table_name = 'HZ_PARTIES'
1650: AND ACCT_ROLE.cust_account_id = ROLE_ACCT.cust_account_id
1651: AND ROLE_ACCT.party_id = REL.object_id
1652: ) dcontact

Line 1649: AND REL.object_table_name = 'HZ_PARTIES'

1645: ACCT_ROLE.party_id = REL.party_id
1646: AND ACCT_ROLE.role_type = 'CONTACT'
1647: AND REL.subject_id = PARTY.party_id
1648: AND REL.subject_table_name = 'HZ_PARTIES'
1649: AND REL.object_table_name = 'HZ_PARTIES'
1650: AND ACCT_ROLE.cust_account_id = ROLE_ACCT.cust_account_id
1651: AND ROLE_ACCT.party_id = REL.object_id
1652: ) dcontact
1653: , ( SELECT ACCT_ROLE.cust_account_role_id contact_id,

Line 1658: hz_parties PARTY,

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
1662: ACCT_ROLE.party_id = REL.party_id

Line 1665: AND REL.subject_table_name = 'HZ_PARTIES'

1661: WHERE
1662: ACCT_ROLE.party_id = REL.party_id
1663: AND ACCT_ROLE.role_type = 'CONTACT'
1664: AND REL.subject_id = PARTY.party_id
1665: AND REL.subject_table_name = 'HZ_PARTIES'
1666: AND REL.object_table_name = 'HZ_PARTIES'
1667: AND ACCT_ROLE.cust_account_id = ROLE_ACCT.cust_account_id
1668: AND ROLE_ACCT.party_id = REL.object_id
1669: ) isc

Line 1666: AND REL.object_table_name = 'HZ_PARTIES'

1662: ACCT_ROLE.party_id = REL.party_id
1663: AND ACCT_ROLE.role_type = 'CONTACT'
1664: AND REL.subject_id = PARTY.party_id
1665: AND REL.subject_table_name = 'HZ_PARTIES'
1666: AND REL.object_table_name = 'HZ_PARTIES'
1667: AND ACCT_ROLE.cust_account_id = ROLE_ACCT.cust_account_id
1668: AND ROLE_ACCT.party_id = REL.object_id
1669: ) isc
1670: , ( SELECT ACCT_ROLE.cust_account_role_id contact_id,

Line 1675: hz_parties PARTY,

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
1679: ACCT_ROLE.party_id = REL.party_id

Line 1682: AND REL.subject_table_name = 'HZ_PARTIES'

1678: WHERE
1679: ACCT_ROLE.party_id = REL.party_id
1680: AND ACCT_ROLE.role_type = 'CONTACT'
1681: AND REL.subject_id = PARTY.party_id
1682: AND REL.subject_table_name = 'HZ_PARTIES'
1683: AND REL.object_table_name = 'HZ_PARTIES'
1684: AND ACCT_ROLE.cust_account_id = ROLE_ACCT.cust_account_id
1685: AND ROLE_ACCT.party_id = REL.object_id
1686: ) invc,

Line 1683: AND REL.object_table_name = 'HZ_PARTIES'

1679: ACCT_ROLE.party_id = REL.party_id
1680: AND ACCT_ROLE.role_type = 'CONTACT'
1681: AND REL.subject_id = PARTY.party_id
1682: AND REL.subject_table_name = 'HZ_PARTIES'
1683: AND REL.object_table_name = 'HZ_PARTIES'
1684: AND ACCT_ROLE.cust_account_id = ROLE_ACCT.cust_account_id
1685: AND ROLE_ACCT.party_id = REL.object_id
1686: ) invc,
1687: PA_PROJECTS pp,