APPS.JTF_TTY_ALIGN_WEBADI_INT_PKG dependencies on JTF_TTY_ACCT_METRICS

Line 541: from JTF_TTY_ACCT_METRICS am

537:
538:
539: begin
540: select metric_value into l_dnb_annual_rev
541: from JTF_TTY_ACCT_METRICS am
542: where m.JTF_TTY_WEBADI_INT_ID = am.named_account_id
543: and am.metric_lookup_type = 'JTF_TTY_ALIGN_METRICS'
544: and am.metric_lookup_code = 'DNB_ANNUAL_REVENUE'
545: and rownum<2;

Line 554: from JTF_TTY_ACCT_METRICS am

550: end;
551:
552: begin
553: select metric_value into l_dnb_num_of_emp
554: from JTF_TTY_ACCT_METRICS am
555: where m.JTF_TTY_WEBADI_INT_ID = am.named_account_id
556: and am.metric_lookup_type = 'JTF_TTY_ALIGN_METRICS'
557: and am.metric_lookup_code = 'DNB_NUM_EMPLOYEES'
558: and rownum<2;

Line 567: from JTF_TTY_ACCT_METRICS am

563: end;
564:
565: begin
566: select metric_value into l_prior_won
567: from JTF_TTY_ACCT_METRICS am
568: where m.JTF_TTY_WEBADI_INT_ID = am.named_account_id
569: and am.metric_lookup_type = 'JTF_TTY_ALIGN_METRICS'
570: and am.metric_lookup_code = 'PRIOR_SALES'
571: and rownum<2;

Line 761: from JTF_TTY_ACCT_METRICS AM,

757: , 1
758: from ( select pa.align_proposed_terr_id pterr_id
759: ,sum(am.metric_value) metric_value
760: ,round( (sum(am.metric_value)/ alm.align_metric_val )* 100, 2 ) metric_pct
761: from JTF_TTY_ACCT_METRICS AM,
762: jtf_tty_align_accts ac,
763: JTF_TTY_PTERR_ACCTS pa,
764: jtf_tty_terr_grp_accts ga,
765: jtf_tty_align_pterr ap,

Line 767: from jtf_tty_acct_metrics ams

763: JTF_TTY_PTERR_ACCTS pa,
764: jtf_tty_terr_grp_accts ga,
765: jtf_tty_align_pterr ap,
766: ( select sum(ams.metric_value) align_metric_val
767: from jtf_tty_acct_metrics ams
768: ,jtf_tty_terr_grp_accts tga
769: ,jtf_tty_align_accts ala
770: where ala.alignment_id = l_alignment_id
771: and ala.terr_group_account_id = tga.terr_group_account_id

Line 820: from JTF_TTY_ACCT_METRICS AM,

816: , 1
817: from ( select pa.align_proposed_terr_id pterr_id
818: ,sum(am.metric_value) metric_value
819: ,round( (sum(am.metric_value)/ alm.align_metric_val )* 100, 2 ) metric_pct
820: from JTF_TTY_ACCT_METRICS AM,
821: jtf_tty_align_accts ac,
822: JTF_TTY_PTERR_ACCTS pa,
823: jtf_tty_terr_grp_accts ga,
824: jtf_tty_align_pterr ap,

Line 826: from jtf_tty_acct_metrics ams

822: JTF_TTY_PTERR_ACCTS pa,
823: jtf_tty_terr_grp_accts ga,
824: jtf_tty_align_pterr ap,
825: ( select sum(ams.metric_value) align_metric_val
826: from jtf_tty_acct_metrics ams
827: ,jtf_tty_terr_grp_accts tga
828: ,jtf_tty_align_accts ala
829: where ala.alignment_id = l_alignment_id
830: and ala.terr_group_account_id = tga.terr_group_account_id

Line 925: from JTF_TTY_ACCT_METRICS AM,

921: , 1
922: from ( select pa.align_proposed_terr_id pterr_id
923: ,sum(am.metric_value) metric_value
924: ,round( (sum(am.metric_value)/ alm.align_metric_val )* 100, 2 ) metric_pct
925: from JTF_TTY_ACCT_METRICS AM,
926: jtf_tty_align_accts ac,
927: JTF_TTY_PTERR_ACCTS pa,
928: jtf_tty_terr_grp_accts ga,
929: jtf_tty_align_pterr ap,

Line 931: from jtf_tty_acct_metrics ams

927: JTF_TTY_PTERR_ACCTS pa,
928: jtf_tty_terr_grp_accts ga,
929: jtf_tty_align_pterr ap,
930: ( select sum(ams.metric_value) align_metric_val
931: from jtf_tty_acct_metrics ams
932: ,jtf_tty_terr_grp_accts tga
933: ,jtf_tty_align_accts ala
934: where ala.alignment_id = l_alignment_id
935: and ala.terr_group_account_id = tga.terr_group_account_id