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.PA_ADJUSTMENTS dependencies on PA_TRANSACTION_SOURCES

Line 199: pa_transaction_sources ts

195: decode(X_reversed_orig_txn_reference,NULL,
196: i.orig_transaction_reference,
197: X_reversed_orig_txn_reference) orig_txn_reference
198: FROM
199: pa_transaction_sources ts
200: , pa_expenditure_items i
201: , pa_expenditures e
202: WHERE
203: i.expenditure_item_date = X_item_date

Line 1245: , pa_transaction_sources txs

1241: , trx_source_burden
1242: , system_linkage
1243: FROM
1244: pa_expenditure_items_all ei
1245: , pa_transaction_sources txs
1246: WHERE
1247: ei.transaction_source = txs.transaction_source(+)
1248: AND ei.expenditure_item_id = ItemsIdTab(i);
1249:

Line 1414: , pa_transaction_sources txs

1410: trx_source_burden,
1411: system_linkage
1412: FROM
1413: pa_expenditure_items_all ei
1414: , pa_transaction_sources txs
1415: WHERE
1416: ei.transaction_source = txs.transaction_source(+)
1417: AND ei.expenditure_item_id = ItemsIdTab(i);
1418:

Line 1618: , pa_transaction_sources txs

1614: , trx_source_burden
1615: , system_linkage
1616: FROM
1617: pa_expenditure_items_all ei
1618: , pa_transaction_sources txs
1619: WHERE
1620: ei.transaction_source = txs.transaction_source(+)
1621: AND ei.expenditure_item_id = ItemsIdTab(i);
1622:

Line 1792: , pa_transaction_sources txs

1788: trx_source_burden,
1789: system_linkage
1790: FROM
1791: pa_expenditure_items_all ei
1792: , pa_transaction_sources txs
1793: WHERE
1794: ei.transaction_source = txs.transaction_source(+)
1795: AND ei.expenditure_item_id = ItemsIdTab(i);
1796:

Line 2194: pa_transaction_sources tr

2190: l_projfunc_cost_rate_type,
2191: l_projfunc_cost_exchg_rate,
2192: l_work_type_id
2193: FROM pa_expenditure_items_all ei,
2194: pa_transaction_sources tr
2195: WHERE tr.transaction_source(+) = ei.transaction_source
2196: AND expenditure_item_id = p_exp_item_id;
2197:
2198: IF P_DEBUG_MODE THEN

Line 2310: ,pa_transaction_sources tr

2306: ,l_gl_accounted_flag
2307: ,l_proj_type_class_code
2308: ,l_old_billability
2309: FROM pa_expenditure_items_all EI
2310: ,pa_transaction_sources tr
2311: ,pa_project_types_all pt /** Bug fix 2262118 **/
2312: ,pa_projects_all pp
2313: -- ,pa_tasks t /* Bug 3457922 */
2314: WHERE tr.transaction_source(+) = ei.transaction_source

Line 2628: pa_transaction_sources tr

2624: l_projfunc_cost_rate_type,
2625: l_projfunc_cost_exchg_rate,
2626: l_work_type_id
2627: FROM pa_expenditure_items_all ei,
2628: pa_transaction_sources tr
2629: WHERE tr.transaction_source = ei.transaction_source
2630: AND expenditure_item_id = ItemsIdTab(i) ;
2631:
2632: -- Added to IF condition below: p_system_linkage_function <> 'VI' to resolve bug # 1764279

Line 2780: pa_transaction_sources tr

2776: l_projfunc_cost_rate_type,
2777: l_projfunc_cost_exchg_rate,
2778: l_work_type_id
2779: FROM pa_expenditure_items_all ei,
2780: pa_transaction_sources tr
2781: WHERE tr.transaction_source = ei.transaction_source
2782: AND expenditure_item_id = AdjustsIdTab(i) ;
2783:
2784: IF p_gl_accounted_flag = 'Y' THEN

Line 3618: , pa_transaction_sources ts

3614: FROM
3615: pa_expenditures_all e
3616: , pa_expenditure_items_all ei
3617: , pa_expenditure_items_all ei2
3618: , pa_transaction_sources ts
3619: , pa_expenditure_comments ec
3620: /* R12 changes - Removed table pa_cost_distribution_lines */
3621: WHERE
3622: e.expenditure_id = ei.expenditure_id

Line 5445: l_allow_adjustments_flag PA_TRANSACTION_SOURCES.ALLOW_ADJUSTMENTS_FLAG%TYPE;

5441: l_application_short_name varchar2(30);
5442: l_net_zero_adjustment_flag PA_EXPENDITURE_ITEMS_ALL.NET_ZERO_ADJUSTMENT_FLAG%TYPE;
5443: l_converted_flag PA_EXPENDITURE_ITEMS_ALL.CONVERTED_FLAG%TYPE;
5444: l_expenditure_status_code PA_EXPENDITURES_ALL.EXPENDITURE_STATUS_CODE%TYPE;
5445: l_allow_adjustments_flag PA_TRANSACTION_SOURCES.ALLOW_ADJUSTMENTS_FLAG%TYPE;
5446: l_burden_sum_dest_run_id PA_EXPENDITURE_ITEMS_ALL.BURDEN_SUM_DEST_RUN_ID%TYPE;
5447: l_document_distribution_type PA_EXPENDITURE_ITEMS_ALL.DOCUMENT_DISTRIBUTION_TYPE%TYPE;
5448: l_source_expenditure_item_id PA_EXPENDITURE_ITEMS_ALL.SOURCE_EXPENDITURE_ITEM_ID%TYPE;
5449: l_acct_currency_code PA_EXPENDITURE_ITEMS_ALL.ACCT_CURRENCY_CODE%TYPE;

Line 5456: l_transaction_source_cache PA_TRANSACTION_SOURCES.TRANSACTION_SOURCE%TYPE := 'NULL'; /* Bug 5441891 */

5452: l_project_status_code PA_PROJECTS_ALL.PROJECT_STATUS_CODE%TYPE;
5453: l_adjust_allowed BOOLEAN := TRUE;
5454: l_award_id GMS_AWARDS_ALL.AWARD_ID%TYPE; /* Bug 5436420 */
5455: l_project_id_cache PA_PROJECTS_ALL.PROJECT_ID%TYPE := -1; /* Bug 5441891 */
5456: l_transaction_source_cache PA_TRANSACTION_SOURCES.TRANSACTION_SOURCE%TYPE := 'NULL'; /* Bug 5441891 */
5457: l_commit_count NUMBER := 0; /* Bug 5501593 */
5458: /* R12 Changes - End */
5459: BEGIN
5460: /* R12 Changes - Start */

Line 6256: FROM pa_transaction_sources tr

6252: SELECT tr.allow_adjustments_flag
6253: , tr.gl_accounted_flag
6254: INTO l_allow_adjustments_flag
6255: , l_gl_accounted
6256: FROM pa_transaction_sources tr
6257: WHERE tr.transaction_source = l_transaction_source;
6258: l_transaction_source_cache := l_transaction_source;
6259: END IF;
6260: END IF;

Line 9169: FROM pa_transaction_sources

9165: l_predefined_flag VARCHAR2(1);
9166:
9167: CURSOR allow_adjustment IS
9168: SELECT allow_adjustments_flag, predefined_flag
9169: FROM pa_transaction_sources
9170: WHERE transaction_source = p_transaction_source;
9171:
9172: CURSOR sst_adjustment IS
9173: SELECT net_zero_adjustment_flag_1,

Line 9367: l_gl_accounted_flag pa_transaction_sources.gl_accounted_flag%type;

9363: , p_ei_date IN DATE default NULL /*Bugfix:2798742 */
9364: ) RETURN VARCHAR2 IS
9365:
9366: l_return_currency_code pa_expenditure_items_all.denom_currency_code%type;
9367: l_gl_accounted_flag pa_transaction_sources.gl_accounted_flag%type;
9368: l_costed_flag pa_transaction_sources.costed_flag%type; /* added bug 3142879 */
9369: l_cost_rate_flag pa_expenditure_types.cost_rate_flag%type;
9370: l_job_id pa_expenditure_items_all.job_id%TYPE;
9371: l_organization_id pa_expenditures_all.incurred_by_organization_id%TYPE;

Line 9368: l_costed_flag pa_transaction_sources.costed_flag%type; /* added bug 3142879 */

9364: ) RETURN VARCHAR2 IS
9365:
9366: l_return_currency_code pa_expenditure_items_all.denom_currency_code%type;
9367: l_gl_accounted_flag pa_transaction_sources.gl_accounted_flag%type;
9368: l_costed_flag pa_transaction_sources.costed_flag%type; /* added bug 3142879 */
9369: l_cost_rate_flag pa_expenditure_types.cost_rate_flag%type;
9370: l_job_id pa_expenditure_items_all.job_id%TYPE;
9371: l_organization_id pa_expenditures_all.incurred_by_organization_id%TYPE;
9372: l_cost_rate pa_bill_rates_all.rate%TYPE;

Line 9396: FROM pa_transaction_sources

9392: l_costed_flag := 'N';/* added bug 3142879 */
9393: ELSE
9394: SELECT gl_accounted_flag, costed_flag
9395: INTO l_gl_accounted_flag, l_costed_flag /* added costed flag bug 3142879 */
9396: FROM pa_transaction_sources
9397: WHERE transaction_source = p_transaction_source;
9398: END IF;
9399:
9400: /* Get the cost_rate_flag */