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.ITG_SETUP dependencies on STANDARD

Line 868: p_standard_code VARCHAR2,

864: )
865: IS
866: CURSOR get_tp_detail_id(
867: p_tp_hdr_id VARCHAR2,
868: p_standard_code VARCHAR2,
869: p_ext_type VARCHAR2,
870: p_ext_subtype VARCHAR2,
871: p_direction VARCHAR2,
872: p_txn_type VARCHAR2,

Line 881: ecx_standards svl

877: ecx_tp_details tpd,
878: ecx_tp_headers tph,
879: ecx_ext_processes extp,
880: ecx_transactions txn,
881: ecx_standards svl
882: WHERE 1=1
883: AND tph.tp_header_id = tpd.tp_header_id
884: AND tpd.ext_process_id = extp.ext_process_id
885: AND extp.transaction_id = txn.transaction_id

Line 886: AND extp.standard_id = svl.standard_id

882: WHERE 1=1
883: AND tph.tp_header_id = tpd.tp_header_id
884: AND tpd.ext_process_id = extp.ext_process_id
885: AND extp.transaction_id = txn.transaction_id
886: AND extp.standard_id = svl.standard_id
887: AND svl.standard_code = p_std_code
888: AND extp.ext_type = p_ext_type
889: AND extp.ext_subtype = p_ext_subtype
890: AND extp.direction = p_direction

Line 887: AND svl.standard_code = p_std_code

883: AND tph.tp_header_id = tpd.tp_header_id
884: AND tpd.ext_process_id = extp.ext_process_id
885: AND extp.transaction_id = txn.transaction_id
886: AND extp.standard_id = svl.standard_id
887: AND svl.standard_code = p_std_code
888: AND extp.ext_type = p_ext_type
889: AND extp.ext_subtype = p_ext_subtype
890: AND extp.direction = p_direction
891: AND txn.transaction_type = p_txn_type

Line 970: ecx_standards svl

966: SELECT extp.ext_process_id
967: INTO l_ext_process_id
968: FROM ecx_ext_processes extp,
969: ecx_transactions txn,
970: ecx_standards svl
971: WHERE 1=1
972: AND extp.transaction_id = txn.transaction_id
973: AND extp.standard_id = svl.standard_id
974: AND svl.standard_code = p_std_code

Line 973: AND extp.standard_id = svl.standard_id

969: ecx_transactions txn,
970: ecx_standards svl
971: WHERE 1=1
972: AND extp.transaction_id = txn.transaction_id
973: AND extp.standard_id = svl.standard_id
974: AND svl.standard_code = p_std_code
975: AND extp.ext_type = p_ext_type
976: AND extp.ext_subtype = p_ext_subtype
977: AND extp.direction = p_direction

Line 974: AND svl.standard_code = p_std_code

970: ecx_standards svl
971: WHERE 1=1
972: AND extp.transaction_id = txn.transaction_id
973: AND extp.standard_id = svl.standard_id
974: AND svl.standard_code = p_std_code
975: AND extp.ext_type = p_ext_type
976: AND extp.ext_subtype = p_ext_subtype
977: AND extp.direction = p_direction
978: AND txn.party_type = p_party_type

Line 1002: ecx_standards svl

998: SELECT count(*)
999: INTO l_count
1000: FROM ecx_ext_processes extp,
1001: ecx_tp_details tpd,
1002: ecx_standards svl
1003: WHERE 1=1
1004: AND extp.standard_id = svl.standard_id
1005: AND svl.standard_code = p_std_code
1006: AND extp.ext_process_id = tpd.ext_process_id

Line 1004: AND extp.standard_id = svl.standard_id

1000: FROM ecx_ext_processes extp,
1001: ecx_tp_details tpd,
1002: ecx_standards svl
1003: WHERE 1=1
1004: AND extp.standard_id = svl.standard_id
1005: AND svl.standard_code = p_std_code
1006: AND extp.ext_process_id = tpd.ext_process_id
1007: AND extp.ext_type = p_ext_type
1008: AND extp.ext_subtype = p_ext_subtype

Line 1005: AND svl.standard_code = p_std_code

1001: ecx_tp_details tpd,
1002: ecx_standards svl
1003: WHERE 1=1
1004: AND extp.standard_id = svl.standard_id
1005: AND svl.standard_code = p_std_code
1006: AND extp.ext_process_id = tpd.ext_process_id
1007: AND extp.ext_type = p_ext_type
1008: AND extp.ext_subtype = p_ext_subtype
1009: AND extp.direction = p_direction