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_ALL

Line 1023: FROM po_distributions_all

1019:
1020:
1021: CURSOR c_distributions IS
1022: SELECT po_distribution_id
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

Line 1840: FROM po_distributions_all WHERE po_distribution_id = c.po_dist_id and draft_id = DRAFTID;

1836: FOR c IN c_addedObligatedAmounts LOOP
1837: SELECT CLM_MISC_LOA LoaDetails,CLM_AGENCY_ACCT_IDENTIFIER AccountingIdentifier,
1838: ACRN FinancialCodeValue,round(AMOUNT_FUNDED,5) ObligatedAmount,CODE_COMBINATION_ID code_comb_id
1839: INTO l_mod1,l_mod2,l_mod3,l_mod4,l_mod5
1840: FROM po_distributions_all WHERE po_distribution_id = c.po_dist_id and draft_id = DRAFTID;
1841:
1842: l_clob := l_clob || ''||l_mod4||'' ||
1843: 'Accounting Classification Reference Number (ACRN)'||
1844: l_mod3||'';

Line 1865: FROM po_distributions_all WHERE po_distribution_id = c.po_dist_id and draft_id = -1;

1861: FOR c IN c_deletedObligatedAmounts LOOP
1862: SELECT CLM_MISC_LOA LoaDetails,CLM_AGENCY_ACCT_IDENTIFIER AccountingIdentifier,
1863: ACRN FinancialCodeValue,round(AMOUNT_FUNDED,5) ObligatedAmount,CODE_COMBINATION_ID code_comb_id
1864: INTO l_mod1,l_mod2,l_mod3,l_mod4,l_mod5
1865: FROM po_distributions_all WHERE po_distribution_id = c.po_dist_id and draft_id = -1;
1866:
1867: l_clob := l_clob || ''||l_mod4||'' ||
1868: 'Accounting Classification Reference Number (ACRN)'||
1869: l_mod3||'';

Line 1890: FROM po_distributions_all WHERE po_distribution_id = c.po_dist_id and draft_id = DRAFTID;

1886: FOR c IN c_changedObligatedAmounts LOOP
1887: SELECT CLM_MISC_LOA LoaDetails,CLM_AGENCY_ACCT_IDENTIFIER AccountingIdentifier,
1888: ACRN FinancialCodeValue,round(AMOUNT_FUNDED,5) ObligatedAmount,CODE_COMBINATION_ID code_comb_id
1889: INTO l_mod1,l_mod2,l_mod3,l_mod4,l_mod5
1890: FROM po_distributions_all WHERE po_distribution_id = c.po_dist_id and draft_id = DRAFTID;
1891:
1892: SELECT CLM_MISC_LOA LoaDetails,CLM_AGENCY_ACCT_IDENTIFIER AccountingIdentifier,
1893: ACRN FinancialCodeValue,round(AMOUNT_FUNDED,5) ObligatedAmount,CODE_COMBINATION_ID code_comb_id
1894: INTO l_prev1,l_prev2,l_prev3,l_prev4,l_prev5

Line 1895: FROM po_distributions_all WHERE po_distribution_id = c.po_dist_id and draft_id = -1;

1891:
1892: SELECT CLM_MISC_LOA LoaDetails,CLM_AGENCY_ACCT_IDENTIFIER AccountingIdentifier,
1893: ACRN FinancialCodeValue,round(AMOUNT_FUNDED,5) ObligatedAmount,CODE_COMBINATION_ID code_comb_id
1894: INTO l_prev1,l_prev2,l_prev3,l_prev4,l_prev5
1895: FROM po_distributions_all WHERE po_distribution_id = c.po_dist_id and draft_id = -1;
1896:
1897: IF nvl(l_mod1,-99) <> nvl(l_prev1,-98) THEN l_chg1:= 'Modified'; l_chgtxt1:= 'Blob Value modified from '|| l_prev1 || ' to '
1898: ||l_mod1; END IF;
1899: IF nvl(l_mod2,-99) <> nvl(l_prev2,-98) THEN l_chg2:= 'Modified'; l_chgtxt2:= 'AgencyAccountingIdentifier Value modified from '||