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.ASO_SHIPMENT_PVT dependencies on HZ_PARTIES

Line 965: from hz_relationships HPR,hz_parties HP where hpr.party_id = p_party_id

961: ) RETURN VARCHAR2
962: IS
963: CURSOR C1 IS
964: select HP.party_id,HP.party_name
965: from hz_relationships HPR,hz_parties HP where hpr.party_id = p_party_id
966: and hp.party_id=HPR.object_id
967: and SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
968: and OBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
969: and HPR.directional_flag = 'B'; -- Added for bug 8634067

Line 967: and SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'

963: CURSOR C1 IS
964: select HP.party_id,HP.party_name
965: from hz_relationships HPR,hz_parties HP where hpr.party_id = p_party_id
966: and hp.party_id=HPR.object_id
967: and SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
968: and OBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
969: and HPR.directional_flag = 'B'; -- Added for bug 8634067
970:
971: CURSOR C2 IS

Line 968: and OBJECT_TABLE_NAME(+) = 'HZ_PARTIES'

964: select HP.party_id,HP.party_name
965: from hz_relationships HPR,hz_parties HP where hpr.party_id = p_party_id
966: and hp.party_id=HPR.object_id
967: and SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
968: and OBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
969: and HPR.directional_flag = 'B'; -- Added for bug 8634067
970:
971: CURSOR C2 IS
972: select party_id,party_name

Line 973: from hz_parties HP where party_id = p_party_id;

969: and HPR.directional_flag = 'B'; -- Added for bug 8634067
970:
971: CURSOR C2 IS
972: select party_id,party_name
973: from hz_parties HP where party_id = p_party_id;
974: l_party_name VARCHAR2(360);
975: l_party_id NUMBER;
976: BEGIN
977: IF p_party_type = 'PARTY_RELATIONSHIP' THEN

Line 1008: from hz_relationships HPR,hz_parties HP where hpr.party_id = p_party_id

1004: ) RETURN VARCHAR2
1005: IS
1006: CURSOR C1 IS
1007: select HP.party_id,HP.person_first_name
1008: from hz_relationships HPR,hz_parties HP where hpr.party_id = p_party_id
1009: and hp.party_id=HPR.subject_id
1010: and SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
1011: and OBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
1012: and HPR.directional_flag = 'F'; -- 8634067

Line 1010: and SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'

1006: CURSOR C1 IS
1007: select HP.party_id,HP.person_first_name
1008: from hz_relationships HPR,hz_parties HP where hpr.party_id = p_party_id
1009: and hp.party_id=HPR.subject_id
1010: and SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
1011: and OBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
1012: and HPR.directional_flag = 'F'; -- 8634067
1013:
1014: CURSOR C2 IS

Line 1011: and OBJECT_TABLE_NAME(+) = 'HZ_PARTIES'

1007: select HP.party_id,HP.person_first_name
1008: from hz_relationships HPR,hz_parties HP where hpr.party_id = p_party_id
1009: and hp.party_id=HPR.subject_id
1010: and SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
1011: and OBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
1012: and HPR.directional_flag = 'F'; -- 8634067
1013:
1014: CURSOR C2 IS
1015: select party_id,person_first_name

Line 1016: from hz_parties HP where party_id = p_party_id;

1012: and HPR.directional_flag = 'F'; -- 8634067
1013:
1014: CURSOR C2 IS
1015: select party_id,person_first_name
1016: from hz_parties HP where party_id = p_party_id;
1017: l_f_party_name VARCHAR2(150);
1018: l_party_id NUMBER;
1019: BEGIN
1020: IF p_party_type = 'PARTY_RELATIONSHIP' THEN

Line 1051: from hz_relationships HPR,hz_parties HP where hpr.party_id = p_party_id

1047: ) RETURN VARCHAR2
1048: IS
1049: CURSOR C1 IS
1050: select HP.party_id,HP.person_middle_name
1051: from hz_relationships HPR,hz_parties HP where hpr.party_id = p_party_id
1052: and hp.party_id=HPR.subject_id
1053: and SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
1054: and OBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
1055: and HPR.directional_flag = 'F'; -- 8634067

Line 1053: and SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'

1049: CURSOR C1 IS
1050: select HP.party_id,HP.person_middle_name
1051: from hz_relationships HPR,hz_parties HP where hpr.party_id = p_party_id
1052: and hp.party_id=HPR.subject_id
1053: and SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
1054: and OBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
1055: and HPR.directional_flag = 'F'; -- 8634067
1056:
1057: CURSOR C2 IS

Line 1054: and OBJECT_TABLE_NAME(+) = 'HZ_PARTIES'

1050: select HP.party_id,HP.person_middle_name
1051: from hz_relationships HPR,hz_parties HP where hpr.party_id = p_party_id
1052: and hp.party_id=HPR.subject_id
1053: and SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
1054: and OBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
1055: and HPR.directional_flag = 'F'; -- 8634067
1056:
1057: CURSOR C2 IS
1058: select party_id,person_middle_name

Line 1059: from hz_parties HP where party_id = p_party_id;

1055: and HPR.directional_flag = 'F'; -- 8634067
1056:
1057: CURSOR C2 IS
1058: select party_id,person_middle_name
1059: from hz_parties HP where party_id = p_party_id;
1060: l_m_party_name VARCHAR2(60);
1061: l_party_id NUMBER;
1062: BEGIN
1063: IF p_party_type = 'PARTY_RELATIONSHIP' THEN

Line 1093: from hz_relationships HPR,hz_parties HP where hpr.party_id = p_party_id

1089: ) RETURN VARCHAR2
1090: IS
1091: CURSOR C1 IS
1092: select HP.party_id,HP.person_last_name
1093: from hz_relationships HPR,hz_parties HP where hpr.party_id = p_party_id
1094: and hp.party_id=HPR.subject_id
1095: and SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
1096: and OBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
1097: and HPR.directional_flag = 'F'; -- 8634067

Line 1095: and SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'

1091: CURSOR C1 IS
1092: select HP.party_id,HP.person_last_name
1093: from hz_relationships HPR,hz_parties HP where hpr.party_id = p_party_id
1094: and hp.party_id=HPR.subject_id
1095: and SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
1096: and OBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
1097: and HPR.directional_flag = 'F'; -- 8634067
1098:
1099: CURSOR C2 IS

Line 1096: and OBJECT_TABLE_NAME(+) = 'HZ_PARTIES'

1092: select HP.party_id,HP.person_last_name
1093: from hz_relationships HPR,hz_parties HP where hpr.party_id = p_party_id
1094: and hp.party_id=HPR.subject_id
1095: and SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
1096: and OBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
1097: and HPR.directional_flag = 'F'; -- 8634067
1098:
1099: CURSOR C2 IS
1100: select party_id,person_last_name

Line 1101: from hz_parties HP where party_id = p_party_id;

1097: and HPR.directional_flag = 'F'; -- 8634067
1098:
1099: CURSOR C2 IS
1100: select party_id,person_last_name
1101: from hz_parties HP where party_id = p_party_id;
1102: l_l_party_name VARCHAR2(150);
1103: l_party_id NUMBER;
1104: BEGIN
1105: IF p_party_type = 'PARTY_RELATIONSHIP' THEN