APPS.FTE_ACS_RULE_UTIL_PKG dependencies on FTE_SEL_SEARCH_ENTITIES_TMP

Line 746: INSERT INTO FTE_SEL_SEARCH_ENTITIES_TMP(

742: l_last := i;
743:
744: FORALL j IN l_first..l_last
745:
746: INSERT INTO FTE_SEL_SEARCH_ENTITIES_TMP(
747: delivery_id,
748: trip_id ,
749: delivery_name,
750: trip_name,

Line 1090: FROM FTE_SEL_SEARCH_ENTITIES_TMP FSSET,

1086: fsset.initial_pickup_loc_id,
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

Line 1120: FROM FTE_SEL_SEARCH_ENTITIES_TMP FSSET,

1116: fsset.initial_pickup_loc_id,
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

Line 1150: FROM FTE_SEL_SEARCH_ENTITIES_TMP FSSET,

1146: fsset.initial_pickup_loc_id,
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

Line 1182: FROM FTE_SEL_SEARCH_ENTITIES_TMP FSSET,

1178: fsset.initial_pickup_loc_id,
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

Line 1213: FROM FTE_SEL_SEARCH_ENTITIES_TMP FSSET,

1209: fsset.initial_pickup_loc_id,
1210: fsset.ultimate_dropoff_loc_id,
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