APPS.JTY_TAE_GEN_PVT dependencies on JTY_DEA_ATTR_PRODUCTS

Line 372: jty_dea_attr_products jtqp,

368: ,jqu.op_between
369: ,jqu.op_common_where
370: FROM jtf_qual_usgs_all jqu,
371: jty_dea_attr_factors jtqf,
372: jty_dea_attr_products jtqp,
373: jty_dea_attr_prod_factors jtpf
374: WHERE jqu.org_id = -3113
375: AND jqu.qual_usg_id = jtqf.qual_usg_id
376: AND jtpf.dea_attr_factors_id = jtqf.dea_attr_factors_id

Line 584: ,jty_dea_attr_products jtqp

580: ,jqu.op_common_where
581: FROM
582: jtf_qual_usgs_all jqu
583: ,jty_dea_attr_factors jtqf
584: ,jty_dea_attr_products jtqp
585: ,jty_dea_attr_prod_factors jtpf
586: WHERE jqu.org_id = -3113
587: AND jqu.qual_usg_id = jtqf.qual_usg_id
588: AND jtpf.dea_attr_factors_id = jtqf.dea_attr_factors_id

Line 786: ,jty_dea_attr_products jtqp

782: ,jqu.op_common_where
783: FROM
784: jtf_qual_usgs_all jqu
785: ,jty_dea_attr_factors jtqf
786: ,jty_dea_attr_products jtqp
787: ,jty_dea_attr_prod_factors jtpf
788: WHERE jqu.org_id = -3113
789: AND jqu.qual_usg_id = jtqf.qual_usg_id
790: AND jtpf.dea_attr_factors_id = jtqf.dea_attr_factors_id

Line 1542: FROM jty_dea_attr_products_sql

1538:
1539: IF ((p_mode = 'DATE EFFECTIVE') or (p_mode = 'DEA INCREMENTAL')) THEN
1540: SELECT count(*)
1541: INTO l_no_of_records
1542: FROM jty_dea_attr_products_sql
1543: WHERE source_id = p_source_id
1544: AND trans_type_id = p_trans_id
1545: AND program_name = l_pgm_name_tbl(i)
1546: AND attr_relation_product = p_qual_prd_tbl(j);

Line 1672: INSERT INTO JTY_DEA_ATTR_PRODUCTS_SQL(

1668: );
1669:
1670: ELSE
1671: l_match_sql_terr_based := l_match_sql || ' AND B.terr_id = :p_territory_id';
1672: INSERT INTO JTY_DEA_ATTR_PRODUCTS_SQL(
1673: DEA_ATTR_PRODUCTS_SQL_ID
1674: ,SOURCE_ID
1675: ,TRANS_TYPE_ID
1676: ,PROGRAM_NAME

Line 1692: JTY_DEA_ATTR_PRODUCTS_SQL_S.NEXTVAL

1688: ,REQUEST_ID
1689: ,PROGRAM_UPDATE_DATE
1690: ,BATCH_DEA_MATCH_SQL_WITH_TERR)
1691: VALUES(
1692: JTY_DEA_ATTR_PRODUCTS_SQL_S.NEXTVAL
1693: ,p_source_id
1694: ,p_trans_id
1695: ,l_pgm_name_tbl(i)
1696: ,p_qual_prd_tbl(j)