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.PO_EDA_DATATEMPLATE_PKG dependencies on PO_DISTRIBUTIONS_MERGE_V

Line 1027: SELECT po_distribution_id po_dist_id,'Added' change_status FROM po_distributions_merge_v a WHERE po_header_id = DOCUMENTID

1023: FROM po_distributions_all
1024: WHERE po_header_id = DOCUMENTID;
1025:
1026: CURSOR c_addedObligatedAmounts IS
1027: SELECT po_distribution_id po_dist_id,'Added' change_status FROM po_distributions_merge_v a WHERE po_header_id = DOCUMENTID
1028: AND draft_id = DRAFTID
1029: AND NOT EXISTS (SELECT 1 FROM po_distributions_merge_v WHERE po_distribution_id = a.po_distribution_id AND
1030: draft_id = -1);
1031:

Line 1029: AND NOT EXISTS (SELECT 1 FROM po_distributions_merge_v WHERE po_distribution_id = a.po_distribution_id AND

1025:
1026: CURSOR c_addedObligatedAmounts IS
1027: SELECT po_distribution_id po_dist_id,'Added' change_status FROM po_distributions_merge_v a WHERE po_header_id = DOCUMENTID
1028: AND draft_id = DRAFTID
1029: AND NOT EXISTS (SELECT 1 FROM po_distributions_merge_v WHERE po_distribution_id = a.po_distribution_id AND
1030: draft_id = -1);
1031:
1032: --this is not needed as delete operation is not allowed as of now
1033: CURSOR c_deletedObligatedAmounts IS

Line 1034: SELECT po_distribution_id po_dist_id,'Deleted' change_status FROM po_distributions_merge_v a WHERE po_header_id = DOCUMENTID

1030: draft_id = -1);
1031:
1032: --this is not needed as delete operation is not allowed as of now
1033: CURSOR c_deletedObligatedAmounts IS
1034: SELECT po_distribution_id po_dist_id,'Deleted' change_status FROM po_distributions_merge_v a WHERE po_header_id = DOCUMENTID
1035: AND draft_id = -1
1036: AND NOT EXISTS (SELECT 1 FROM po_distributions_merge_v WHERE po_distribution_id = a.po_distribution_id AND
1037: draft_id = DRAFTID);
1038:

Line 1036: AND NOT EXISTS (SELECT 1 FROM po_distributions_merge_v WHERE po_distribution_id = a.po_distribution_id AND

1032: --this is not needed as delete operation is not allowed as of now
1033: CURSOR c_deletedObligatedAmounts IS
1034: SELECT po_distribution_id po_dist_id,'Deleted' change_status FROM po_distributions_merge_v a WHERE po_header_id = DOCUMENTID
1035: AND draft_id = -1
1036: AND NOT EXISTS (SELECT 1 FROM po_distributions_merge_v WHERE po_distribution_id = a.po_distribution_id AND
1037: draft_id = DRAFTID);
1038:
1039: CURSOR c_changedObligatedAmounts IS
1040: SELECT modi.po_distribution_id po_dist_id,'Modified' change_status FROM po_distributions_merge_v base,po_distributions_merge_v modi

Line 1040: SELECT modi.po_distribution_id po_dist_id,'Modified' change_status FROM po_distributions_merge_v base,po_distributions_merge_v modi

1036: AND NOT EXISTS (SELECT 1 FROM po_distributions_merge_v WHERE po_distribution_id = a.po_distribution_id AND
1037: draft_id = DRAFTID);
1038:
1039: CURSOR c_changedObligatedAmounts IS
1040: SELECT modi.po_distribution_id po_dist_id,'Modified' change_status FROM po_distributions_merge_v base,po_distributions_merge_v modi
1041: WHERE base.po_header_id = DOCUMENTID AND modi.po_header_id = base.po_header_id
1042: AND modi.draft_id = DRAFTID AND base.draft_id = -1
1043: AND modi.CHANGE_STATUS = 'UPDATE'
1044: AND (modi.CODE_COMBINATION_ID <> base.CODE_COMBINATION_ID

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:

Line 2316: FROM PO_DISTRIBUTIONS_merge_v ploc

2312: and nvl(CLM_EXERCISED_FLAG,'N') = 'N';
2313:
2314: cursor c_amount4 is
2315: select sum(FUNDED_VALUE)
2316: FROM PO_DISTRIBUTIONS_merge_v ploc
2317: WHERE
2318: ( ( (isMod = 'N') AND (ploc.po_header_id = DOCUMENTID AND ploc.draft_id = -1 AND ploc.change_status is NULL)) OR
2319: ( (isMod = 'Y') AND (ploc.draft_id = DRAFTID AND ploc.change_status is not null) ) ) ;
2320: