DBA Data[Home] [Help]

APPS.PO_EDA_DATATEMPLATE_PKG dependencies on FND_ID_FLEX_SEGMENTS_VL

Line 1054: FROM fnd_id_flex_segments_vl flv, gl_code_combinations glc, po_distributions_merge_v pda

1050: CURSOR c_obligatedAmountcomponents(p_dist_id number,p_draft_id NUMBER) IS
1051: SELECT NVL((select eda from po_eda_mapping where GROUPING = 'LOA' and attribute = 'ComponentTitle' and
1052: ebs = flv.SEGMENT_NAME),flv.SEGMENT_NAME) ComponentTitle,
1053: PO_EDA_DATATEMPLATE_PKG.get_charge_acc_comp_val(flv.APPLICATION_COLUMN_NAME,pda.CODE_COMBINATION_ID) ComponentValue
1054: FROM fnd_id_flex_segments_vl flv, gl_code_combinations glc, po_distributions_merge_v pda
1055: WHERE po_distribution_id = p_dist_id and draft_id = p_draft_id
1056: AND glc.CODE_COMBINATION_ID = pda.CODE_COMBINATION_ID
1057: AND flv.ID_FLEX_CODE = 'GL#' AND flv.ID_FLEX_NUM = glc.CHART_OF_ACCOUNTS_ID ;
1058: