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 916: from hz_relationships HPR,hz_parties HP where hpr.party_id = p_party_id

912: ) RETURN VARCHAR2
913: IS
914: CURSOR C1 IS
915: select HP.party_id,HP.party_name
916: from hz_relationships HPR,hz_parties HP where hpr.party_id = p_party_id
917: and hp.party_id=HPR.object_id
918: and SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
919: and OBJECT_TABLE_NAME(+) = 'HZ_PARTIES';
920:

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

914: CURSOR C1 IS
915: select HP.party_id,HP.party_name
916: from hz_relationships HPR,hz_parties HP where hpr.party_id = p_party_id
917: and hp.party_id=HPR.object_id
918: and SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
919: and OBJECT_TABLE_NAME(+) = 'HZ_PARTIES';
920:
921: CURSOR C2 IS
922: select party_id,party_name

Line 919: and OBJECT_TABLE_NAME(+) = 'HZ_PARTIES';

915: select HP.party_id,HP.party_name
916: from hz_relationships HPR,hz_parties HP where hpr.party_id = p_party_id
917: and hp.party_id=HPR.object_id
918: and SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
919: and OBJECT_TABLE_NAME(+) = 'HZ_PARTIES';
920:
921: CURSOR C2 IS
922: select party_id,party_name
923: from hz_parties HP where party_id = p_party_id;

Line 923: from hz_parties HP where party_id = p_party_id;

919: and OBJECT_TABLE_NAME(+) = 'HZ_PARTIES';
920:
921: CURSOR C2 IS
922: select party_id,party_name
923: from hz_parties HP where party_id = p_party_id;
924: l_party_name VARCHAR2(360);
925: l_party_id NUMBER;
926: BEGIN
927: IF p_party_type = 'PARTY_RELATIONSHIP' THEN

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

954: ) RETURN VARCHAR2
955: IS
956: CURSOR C1 IS
957: select HP.party_id,HP.person_first_name
958: from hz_relationships HPR,hz_parties HP where hpr.party_id = p_party_id
959: and hp.party_id=HPR.subject_id
960: and SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
961: and OBJECT_TABLE_NAME(+) = 'HZ_PARTIES';
962:

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

956: CURSOR C1 IS
957: select HP.party_id,HP.person_first_name
958: from hz_relationships HPR,hz_parties HP where hpr.party_id = p_party_id
959: and hp.party_id=HPR.subject_id
960: and SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
961: and OBJECT_TABLE_NAME(+) = 'HZ_PARTIES';
962:
963: CURSOR C2 IS
964: select party_id,person_first_name

Line 961: and OBJECT_TABLE_NAME(+) = 'HZ_PARTIES';

957: select HP.party_id,HP.person_first_name
958: from hz_relationships HPR,hz_parties HP where hpr.party_id = p_party_id
959: and hp.party_id=HPR.subject_id
960: and SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
961: and OBJECT_TABLE_NAME(+) = 'HZ_PARTIES';
962:
963: CURSOR C2 IS
964: select party_id,person_first_name
965: from hz_parties HP where party_id = p_party_id;

Line 965: from hz_parties HP where party_id = p_party_id;

961: and OBJECT_TABLE_NAME(+) = 'HZ_PARTIES';
962:
963: CURSOR C2 IS
964: select party_id,person_first_name
965: from hz_parties HP where party_id = p_party_id;
966: l_f_party_name VARCHAR2(150);
967: l_party_id NUMBER;
968: BEGIN
969: IF p_party_type = 'PARTY_RELATIONSHIP' THEN

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

996: ) RETURN VARCHAR2
997: IS
998: CURSOR C1 IS
999: select HP.party_id,HP.person_middle_name
1000: from hz_relationships HPR,hz_parties HP where hpr.party_id = p_party_id
1001: and hp.party_id=HPR.subject_id
1002: and SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
1003: and OBJECT_TABLE_NAME(+) = 'HZ_PARTIES';
1004:

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

998: CURSOR C1 IS
999: select HP.party_id,HP.person_middle_name
1000: from hz_relationships HPR,hz_parties HP where hpr.party_id = p_party_id
1001: and hp.party_id=HPR.subject_id
1002: and SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
1003: and OBJECT_TABLE_NAME(+) = 'HZ_PARTIES';
1004:
1005: CURSOR C2 IS
1006: select party_id,person_middle_name

Line 1003: and OBJECT_TABLE_NAME(+) = 'HZ_PARTIES';

999: select HP.party_id,HP.person_middle_name
1000: from hz_relationships HPR,hz_parties HP where hpr.party_id = p_party_id
1001: and hp.party_id=HPR.subject_id
1002: and SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
1003: and OBJECT_TABLE_NAME(+) = 'HZ_PARTIES';
1004:
1005: CURSOR C2 IS
1006: select party_id,person_middle_name
1007: from hz_parties HP where party_id = p_party_id;

Line 1007: from hz_parties HP where party_id = p_party_id;

1003: and OBJECT_TABLE_NAME(+) = 'HZ_PARTIES';
1004:
1005: CURSOR C2 IS
1006: select party_id,person_middle_name
1007: from hz_parties HP where party_id = p_party_id;
1008: l_m_party_name VARCHAR2(60);
1009: l_party_id NUMBER;
1010: BEGIN
1011: IF p_party_type = 'PARTY_RELATIONSHIP' THEN

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

1036: ) RETURN VARCHAR2
1037: IS
1038: CURSOR C1 IS
1039: select HP.party_id,HP.person_last_name
1040: from hz_relationships HPR,hz_parties HP where hpr.party_id = p_party_id
1041: and hp.party_id=HPR.subject_id
1042: and SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
1043: and OBJECT_TABLE_NAME(+) = 'HZ_PARTIES';
1044:

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

1038: CURSOR C1 IS
1039: select HP.party_id,HP.person_last_name
1040: from hz_relationships HPR,hz_parties HP where hpr.party_id = p_party_id
1041: and hp.party_id=HPR.subject_id
1042: and SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
1043: and OBJECT_TABLE_NAME(+) = 'HZ_PARTIES';
1044:
1045: CURSOR C2 IS
1046: select party_id,person_last_name

Line 1043: and OBJECT_TABLE_NAME(+) = 'HZ_PARTIES';

1039: select HP.party_id,HP.person_last_name
1040: from hz_relationships HPR,hz_parties HP where hpr.party_id = p_party_id
1041: and hp.party_id=HPR.subject_id
1042: and SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
1043: and OBJECT_TABLE_NAME(+) = 'HZ_PARTIES';
1044:
1045: CURSOR C2 IS
1046: select party_id,person_last_name
1047: from hz_parties HP where party_id = p_party_id;

Line 1047: from hz_parties HP where party_id = p_party_id;

1043: and OBJECT_TABLE_NAME(+) = 'HZ_PARTIES';
1044:
1045: CURSOR C2 IS
1046: select party_id,person_last_name
1047: from hz_parties HP where party_id = p_party_id;
1048: l_l_party_name VARCHAR2(150);
1049: l_party_id NUMBER;
1050: BEGIN
1051: IF p_party_type = 'PARTY_RELATIONSHIP' THEN