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.

[Home] [Help]

APPS.IGF_SL_CL_LI_IMP_PKG dependencies on IGS_OR_ORG_ALT_IDS

Line 537: igs_or_org_alt_ids oli,

533: CURSOR c_source_or_branch_id(cp_source_or_branch_id VARCHAR2, cp_source_type VARCHAR2)
534: IS
535: SELECT 1
536: FROM hz_parties hz,
537: igs_or_org_alt_ids oli,
538: igs_or_org_alt_idtyp olt
539: WHERE oli.org_structure_id = hz.party_number
540: AND oli.org_alternate_id_type = olt.org_alternate_id_type
541: AND SYSDATE BETWEEN oli.start_date AND NVL(oli.end_date, SYSDATE)

Line 1337: igs_or_org_alt_ids oli,

1333: CURSOR c_source_or_branch_id(cp_sch_non_ed_brc_id VARCHAR2, cp_source_type VARCHAR2)
1334: IS
1335: SELECT 1
1336: FROM hz_parties hz,
1337: igs_or_org_alt_ids oli,
1338: igs_or_org_alt_idtyp olt
1339: WHERE oli.org_structure_id = hz.party_number
1340: AND oli.org_alternate_id_type = olt.org_alternate_id_type
1341: AND SYSDATE BETWEEN oli.start_date AND NVL(oli.end_date, SYSDATE)