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_ACCOUNTS

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 804: -- "HZ_CUST_ACCOUNTS", "HZ_RELATIONSHIPS".

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: --
808: --l_customer_id ra_customers.customer_id%TYPE;

Line 819: l_customer_id hz_cust_accounts.cust_account_id%TYPE;

815: --
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;

Line 823: l_invoice_customer_id hz_cust_accounts.cust_account_id%TYPE;

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: --
827: -- Modification End for Bug # - 4418524

Line 824: l_deliver_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: --
827: -- Modification End for Bug # - 4418524
828: --

Line 825: l_ship_to_customer_id hz_cust_accounts.cust_account_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: --
827: -- Modification End for Bug # - 4418524
828: --
829:

Line 841: l_customer_number hz_cust_accounts.account_number%TYPE;

837: l_organization_code mtl_parameters.organization_code%TYPE;
838: l_location_id hz_locations.location_id%TYPE;
839: l_location_name hz_cust_site_uses_all.location%TYPE;
840: l_organization_name org_organization_definitions.organization_name%TYPE;
841: l_customer_number hz_cust_accounts.account_number%TYPE;
842: l_sold_from_location_id hz_locations.location_id%TYPE;
843: l_sold_to_location_id hz_locations.location_id%TYPE;
844: l_ship_from_location_id hz_locations.location_id%TYPE;
845: l_ship_to_location_id hz_locations.location_id%TYPE;

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 942: , hz_cust_accounts CUST_ACCT

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: --
946: -- Modification End for Bug # - 4418524

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 1060: -- "HZ_CUST_ACCOUNTS", "HZ_RELATIONSHIPS".

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
1064: --, ra_contacts rcship

Line 1082: , hz_cust_accounts CUST_ACCT

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,
1086: ACCT_ROLE.cust_account_id customer_id,

Line 1092: hz_cust_accounts ROLE_ACCT

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
1095: AND ACCT_ROLE.role_type = 'CONTACT'
1096: AND REL.subject_id = PARTY.party_id

Line 1109: hz_cust_accounts ROLE_ACCT

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
1112: AND ACCT_ROLE.role_type = 'CONTACT'
1113: AND REL.subject_id = PARTY.party_id

Line 1126: hz_cust_accounts ROLE_ACCT

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
1129: AND ACCT_ROLE.role_type = 'CONTACT'
1130: AND REL.subject_id = PARTY.party_id

Line 1143: hz_cust_accounts ROLE_ACCT

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
1146: AND ACCT_ROLE.role_type = 'CONTACT'
1147: AND REL.subject_id = PARTY.party_id

Line 1160: hz_cust_accounts ROLE_ACCT

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
1163: AND ACCT_ROLE.role_type = 'CONTACT'
1164: AND REL.subject_id = PARTY.party_id

Line 1259: HZ_CUST_ACCOUNTS CUST_ACCT,

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
1263: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_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 1608: -- "HZ_CUST_ACCOUNTS", "HZ_RELATIONSHIPS".

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
1612: --, ra_contacts dcontact

Line 1626: hz_cust_accounts ROLE_ACCT

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
1629: AND ACCT_ROLE.role_type = 'CONTACT'
1630: AND REL.subject_id = PARTY.party_id

Line 1643: hz_cust_accounts ROLE_ACCT

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
1646: AND ACCT_ROLE.role_type = 'CONTACT'
1647: AND REL.subject_id = PARTY.party_id

Line 1660: hz_cust_accounts ROLE_ACCT

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
1663: AND ACCT_ROLE.role_type = 'CONTACT'
1664: AND REL.subject_id = PARTY.party_id

Line 1677: hz_cust_accounts ROLE_ACCT

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
1680: AND ACCT_ROLE.role_type = 'CONTACT'
1681: AND REL.subject_id = PARTY.party_id