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

Line 1090: igs_pe_hz_parties ipz,

1086: edi_remittance_instruction,
1087: edi_tp_header_id,
1088: edi_ece_tp_location_code
1089: FROM hz_contact_points cont,
1090: igs_pe_hz_parties ipz,
1091: hz_parties org
1092: WHERE cont.owner_table_name = 'HZ_PARTIES'
1093: AND cont.owner_table_id = org.party_id
1094: AND ipz.party_id = org.party_id

Line 1091: hz_parties org

1087: edi_tp_header_id,
1088: edi_ece_tp_location_code
1089: FROM hz_contact_points cont,
1090: igs_pe_hz_parties ipz,
1091: hz_parties org
1092: WHERE cont.owner_table_name = 'HZ_PARTIES'
1093: AND cont.owner_table_id = org.party_id
1094: AND ipz.party_id = org.party_id
1095: AND ipz.oss_org_unit_cd = p_inst_code;

Line 1092: WHERE cont.owner_table_name = 'HZ_PARTIES'

1088: edi_ece_tp_location_code
1089: FROM hz_contact_points cont,
1090: igs_pe_hz_parties ipz,
1091: hz_parties org
1092: WHERE cont.owner_table_name = 'HZ_PARTIES'
1093: AND cont.owner_table_id = org.party_id
1094: AND ipz.party_id = org.party_id
1095: AND ipz.oss_org_unit_cd = p_inst_code;
1096: cur_edi c_edi%ROWTYPE;

Line 2696: p_admin_person_id IN hz_parties.party_id%TYPE,

2692: p_trans_type IN igs_as_doc_details.document_type%TYPE,
2693: p_deliv_meth IN igs_as_doc_details.delivery_method_type%TYPE,
2694: p_incl_ind IN VARCHAR2,
2695: p_num_copies IN NUMBER,
2696: p_admin_person_id IN hz_parties.party_id%TYPE,
2697: p_order_desc IN igs_as_order_hdr.order_description%TYPE,
2698: p_purpose IN igs_as_doc_details.doc_purpose_code%TYPE,
2699: p_effbuff OUT NOCOPY VARCHAR2,
2700: p_status OUT NOCOPY VARCHAR2

Line 2945: p_admin_person_id IN hz_parties.party_id%TYPE,

2941: p_trans_type IN igs_as_doc_details.document_type%TYPE,
2942: p_deliv_meth IN igs_as_doc_details.delivery_method_type%TYPE,
2943: p_incl_ind IN VARCHAR2,
2944: p_num_copies IN NUMBER,
2945: p_admin_person_id IN hz_parties.party_id%TYPE,
2946: p_order_desc IN igs_as_order_hdr.order_description%TYPE,
2947: p_purpose IN igs_as_doc_details.doc_purpose_code%TYPE
2948: ) AS
2949: l_person_id VARCHAR2 (15);

Line 2969: CURSOR c_prsn_info (p_person_id hz_parties.party_id%TYPE) IS

2965: l_oss_country_cd VARCHAR2 (10);
2966: l_rep_name VARCHAR2 (10);
2967: l_message VARCHAR2 (2000);
2968:
2969: CURSOR c_prsn_info (p_person_id hz_parties.party_id%TYPE) IS
2970: SELECT party_name,
2971: address1,
2972: address2,
2973: address3,

Line 2983: FROM hz_parties

2979: county,
2980: country,
2981: email_address,
2982: party_number
2983: FROM hz_parties
2984: WHERE party_id = p_person_id;
2985: -- kdande; 12-Jan-2004; Bug# 3220696
2986: CURSOR c_lkup_meaning IS
2987: SELECT meaning

Line 3333: FUNCTION get_latest_yop (p_person_id hz_parties.party_id%TYPE, p_course_cd igs_ps_ver.course_cd%TYPE)

3329: retcode := 2; --l_RETURN_STATUS;
3330: RETURN;
3331: END bulk_order_job;
3332:
3333: FUNCTION get_latest_yop (p_person_id hz_parties.party_id%TYPE, p_course_cd igs_ps_ver.course_cd%TYPE)
3334: RETURN VARCHAR2 IS
3335: CURSOR c_susa IS
3336: SELECT susa.unit_set_cd
3337: FROM igs_as_su_setatmpt susa