DBA Data[Home] [Help]

APPS.XDP_ENGINE dependencies on XDP_FE_GENERIC_CONFIG

Line 1347: XDP_FE_GENERIC_CONFIG fge

1343: xdp_fe_attribute_def fan,
1344: (select fe_attribute_id, fe_attribute_value
1345: from
1346: XDP_FE_ATTRIBUTE_VAL fae,
1347: XDP_FE_GENERIC_CONFIG fge
1348: where
1349: fae.fe_generic_config_id = fge.fe_generic_config_id and
1350: fge.fe_id = l_fe_id and
1351: fge.fe_sw_gen_lookup_id = l_gen_lookup_id ) fae2

Line 1416: XDP_FE_GENERIC_CONFIG fge

1412: xdp_fe_attribute_def fan,
1413: (select fe_attribute_id, fe_attribute_value
1414: from
1415: XDP_FE_ATTRIBUTE_VAL fae,
1416: XDP_FE_GENERIC_CONFIG fge
1417: where
1418: fae.fe_generic_config_id = fge.fe_generic_config_id and
1419: fge.fe_id = l_fe_id and
1420: fge.fe_sw_gen_lookup_id = l_gen_lookup_id ) fae2

Line 3140: XDP_FE_GENERIC_CONFIG fge,

3136: decode(fge.sw_start_proc,NULL,fsp.sw_start_proc,fge.sw_start_proc) connect_proc,
3137: decode(fge.sw_exit_proc,NULL,fsp.sw_exit_proc,fge.sw_exit_proc) disconnect_proc
3138: from
3139: XDP_FES fet,
3140: XDP_FE_GENERIC_CONFIG fge,
3141: XDP_FE_TYPES fee,
3142: XDP_FE_SW_GEN_LOOKUP fsp
3143: where
3144: fet.fulfillment_element_name = p_fe and

Line 3150: from XDP_FE_GENERIC_CONFIG fge2

3146: fet.fetype_id = fee.fetype_id and
3147: fge.FE_SW_GEN_LOOKUP_ID = fsp.FE_SW_GEN_LOOKUP_ID and
3148: fge.START_DATE = (
3149: select MAX( FGE2.START_DATE )
3150: from XDP_FE_GENERIC_CONFIG fge2
3151: where fge2.FE_ID= fet.FE_ID and
3152: lv_date >= fge2.START_DATE and
3153: lv_date <= NVL(fge2.END_DATE,lv_date));
3154:

Line 3205: XDP_FE_GENERIC_CONFIG fge,

3201: decode(fge.sw_start_proc,NULL,fsp.sw_start_proc,fge.sw_start_proc) connect_proc,
3202: decode(fge.sw_exit_proc,NULL,fsp.sw_exit_proc,fge.sw_exit_proc) disconnect_proc
3203: from
3204: XDP_FES fet,
3205: XDP_FE_GENERIC_CONFIG fge,
3206: XDP_FE_TYPES fee,
3207: XDP_FE_SW_GEN_LOOKUP fsp
3208: where
3209: fet.fe_id = p_fe_id and

Line 3215: from XDP_FE_GENERIC_CONFIG fge2

3211: fet.fetype_id = fee.fetype_id and
3212: fge.FE_SW_GEN_LOOKUP_ID = fsp.FE_SW_GEN_LOOKUP_ID and
3213: fge.START_DATE = (
3214: select MAX( FGE2.START_DATE )
3215: from XDP_FE_GENERIC_CONFIG fge2
3216: where fge2.FE_ID= fet.FE_ID and
3217: lv_date >= fge2.START_DATE and
3218: lv_date <= NVL(fge2.END_DATE,lv_date));
3219:

Line 3266: XDP_FE_GENERIC_CONFIG fge

3262: xdp_fe_attribute_def fan,
3263: (select fe_attribute_id, fe_attribute_value
3264: from
3265: XDP_FE_ATTRIBUTE_VAL fae,
3266: XDP_FE_GENERIC_CONFIG fge
3267: where
3268: fae.fe_generic_config_id = fge.fe_generic_config_id and
3269: fge.fe_id = GetAttrVal.p_fe_id and
3270: fge.fe_sw_gen_lookup_id = GetAttrVal.p_fe_sw_gen_lookup ) fae2