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.FTE_ACS_RULE_UTIL_PKG dependencies on FTE_SEL_GROUP_ASSIGNMENTS

Line 1091: FTE_SEL_GROUP_ASSIGNMENTS FSGA,

1087: fsset.ultimate_dropoff_loc_id,
1088: fsset.fob_code
1089: -- We do not fetch start date and end date here as we are not going to cache this information.
1090: FROM FTE_SEL_SEARCH_ENTITIES_TMP FSSET,
1091: FTE_SEL_GROUP_ASSIGNMENTS FSGA,
1092: FTE_SEL_GROUPS FSG
1093: WHERE fsga.customer_site_id = fsset.customer_site_id
1094: AND fsga.group_id = fsg.group_id
1095: AND fsg.object_id = g_object_id

Line 1121: FTE_SEL_GROUP_ASSIGNMENTS FSGA,

1117: fsset.ultimate_dropoff_loc_id,
1118: fsset.fob_code
1119: -- We do not fetch start date and end date here as we are not going to cache this information.
1120: FROM FTE_SEL_SEARCH_ENTITIES_TMP FSSET,
1121: FTE_SEL_GROUP_ASSIGNMENTS FSGA,
1122: FTE_SEL_GROUPS FSG
1123: WHERE fsga.customer_id = fsset.customer_id
1124: AND fsga.group_id = fsg.group_id
1125: AND fsg.object_id = g_object_id

Line 1151: FTE_SEL_GROUP_ASSIGNMENTS FSGA,

1147: fsset.ultimate_dropoff_loc_id,
1148: fsset.fob_code
1149: -- We do not fetch start date and end date here as we are not going to cache this information.
1150: FROM FTE_SEL_SEARCH_ENTITIES_TMP FSSET,
1151: FTE_SEL_GROUP_ASSIGNMENTS FSGA,
1152: FTE_SEL_GROUPS FSG
1153: WHERE fsga.organization_id = fsset.organization_id
1154: AND fsga.group_id = fsg.group_id
1155: AND fsg.object_id = g_object_id

Line 1183: FTE_SEL_GROUP_ASSIGNMENTS FSGA,

1179: fsset.ultimate_dropoff_loc_id,
1180: fsset.fob_code
1181: -- We do not fetch start date and end date here as we are not going to cache this information.
1182: FROM FTE_SEL_SEARCH_ENTITIES_TMP FSSET,
1183: FTE_SEL_GROUP_ASSIGNMENTS FSGA,
1184: FTE_SEL_GROUPS FSG
1185: WHERE fsga.organization_id = fsset.triporigin_internalorg_id
1186: AND fsga.group_id = fsg.group_id
1187: AND fsg.object_id = g_object_id

Line 1215: FTE_SEL_GROUP_ASSIGNMENTS assign

1211: fsset.fob_code
1212: -- We do not fetch start date and end date here as we are not going to cache this information.
1213: FROM FTE_SEL_SEARCH_ENTITIES_TMP FSSET,
1214: FTE_SEL_GROUPS FSG,
1215: FTE_SEL_GROUP_ASSIGNMENTS assign
1216: WHERE --assigned_flag = 'E'
1217: --AND
1218: fsg.object_id = g_object_id
1219: --AND nvl(fsg.group_status_flag,'A') NOT IN ('D','I')

Line 1240: FROM fte_sel_group_assignments fsga,

1236: p_ship_date DATE) IS
1237: SELECT fsg.group_id,
1238: fsg.start_date,
1239: fsg.end_date
1240: FROM fte_sel_group_assignments fsga,
1241: fte_sel_groups fsg
1242: WHERE fsga.customer_site_id = p_customer_site_id
1243: AND fsga.group_id = fsg.group_id
1244: AND fsg.object_id = g_object_id

Line 1260: FROM fte_sel_group_assignments fsga,

1256: p_ship_date DATE) IS
1257: SELECT fsg.group_id,
1258: fsg.start_date,
1259: fsg.end_date
1260: FROM fte_sel_group_assignments fsga,
1261: fte_sel_groups fsg
1262: WHERE fsga.customer_id = p_customer_id
1263: AND fsga.group_id = fsg.group_id
1264: AND fsg.object_id = g_object_id

Line 1280: FROM fte_sel_group_assignments fsga,

1276: p_ship_date DATE) IS
1277: SELECT fsg.group_id,
1278: fsg.start_date,
1279: fsg.end_date
1280: FROM fte_sel_group_assignments fsga,
1281: fte_sel_groups fsg
1282: WHERE fsga.organization_id = p_org_id
1283: AND fsga.group_id = fsg.group_id
1284: AND fsg.object_id = g_object_id

Line 1300: FTE_SEL_GROUP_ASSIGNMENTS assign

1296: SELECT fsg.group_id,
1297: fsg.start_date,
1298: fsg.end_date
1299: FROM fte_sel_groups fsg,
1300: FTE_SEL_GROUP_ASSIGNMENTS assign
1301: WHERE --assigned_flag = 'E'
1302: --AND
1303: fsg.object_id = g_object_id
1304: --AND nvl(fsg.group_status_flag,'A') NOT IN ('D','I')