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_ACCOUNT_HELPER dependencies on PO_DISTRIBUTIONS_ALL

Line 396: SELECT DISTINCT line_num into x_token FROM po_lines_all pol, po_distributions_all pod

392: IS
393:
394: BEGIN
395:
396: SELECT DISTINCT line_num into x_token FROM po_lines_all pol, po_distributions_all pod
397: WHERE pol.po_line_id=pod.po_line_id
398: AND pod.po_distribution_id= p_distibution_id;
399:
400:

Line 444: from po_distributions_all pod,gl_code_combinations gcc

440: BEGIN
441:
442: select distinct pod.CODE_COMBINATION_ID,CHART_OF_ACCOUNTS_ID
443: into l_combination_id,l_structure_number
444: from po_distributions_all pod,gl_code_combinations gcc
445: where pod.po_distribution_id= p_distibution_id
446: and pod.code_combination_id=gcc.code_combination_id;
447:
448: x_token := FND_FLEX_EXT.GET_SEGS

Line 950: x_ou_id po_distributions_all.org_id%TYPE;

946: l_entity_type wip_entities.entity_type%type;
947: l_osp_flag po_line_types_b.outside_operation_flag%TYPE;
948: l_expense_accrual_code po_system_parameters_all.EXPENSE_ACCRUAL_CODE%TYPE;
949: l_coa_id gl_sets_of_books.chart_of_accounts_id%TYPE;
950: x_ou_id po_distributions_all.org_id%TYPE;
951: l_current_ou_id po_headers_all.org_id%TYPE;
952: l_old_code_combination_id po_distributions_all.CODE_COMBINATION_ID%TYPE;
953: l_dest_charge_account_id po_distributions_all.DEST_CHARGE_ACCOUNT_ID%TYPE;
954: l_dest_variance_account_id po_distributions_all.DEST_VARIANCE_ACCOUNT_ID%TYPE;

Line 952: l_old_code_combination_id po_distributions_all.CODE_COMBINATION_ID%TYPE;

948: l_expense_accrual_code po_system_parameters_all.EXPENSE_ACCRUAL_CODE%TYPE;
949: l_coa_id gl_sets_of_books.chart_of_accounts_id%TYPE;
950: x_ou_id po_distributions_all.org_id%TYPE;
951: l_current_ou_id po_headers_all.org_id%TYPE;
952: l_old_code_combination_id po_distributions_all.CODE_COMBINATION_ID%TYPE;
953: l_dest_charge_account_id po_distributions_all.DEST_CHARGE_ACCOUNT_ID%TYPE;
954: l_dest_variance_account_id po_distributions_all.DEST_VARIANCE_ACCOUNT_ID%TYPE;
955: l_dest_charge_account_desc VARCHAR2(2000);
956: l_dest_variance_account_desc VARCHAR2(2000);

Line 953: l_dest_charge_account_id po_distributions_all.DEST_CHARGE_ACCOUNT_ID%TYPE;

949: l_coa_id gl_sets_of_books.chart_of_accounts_id%TYPE;
950: x_ou_id po_distributions_all.org_id%TYPE;
951: l_current_ou_id po_headers_all.org_id%TYPE;
952: l_old_code_combination_id po_distributions_all.CODE_COMBINATION_ID%TYPE;
953: l_dest_charge_account_id po_distributions_all.DEST_CHARGE_ACCOUNT_ID%TYPE;
954: l_dest_variance_account_id po_distributions_all.DEST_VARIANCE_ACCOUNT_ID%TYPE;
955: l_dest_charge_account_desc VARCHAR2(2000);
956: l_dest_variance_account_desc VARCHAR2(2000);
957: l_dest_charge_account_flex VARCHAR2(2000);

Line 954: l_dest_variance_account_id po_distributions_all.DEST_VARIANCE_ACCOUNT_ID%TYPE;

950: x_ou_id po_distributions_all.org_id%TYPE;
951: l_current_ou_id po_headers_all.org_id%TYPE;
952: l_old_code_combination_id po_distributions_all.CODE_COMBINATION_ID%TYPE;
953: l_dest_charge_account_id po_distributions_all.DEST_CHARGE_ACCOUNT_ID%TYPE;
954: l_dest_variance_account_id po_distributions_all.DEST_VARIANCE_ACCOUNT_ID%TYPE;
955: l_dest_charge_account_desc VARCHAR2(2000);
956: l_dest_variance_account_desc VARCHAR2(2000);
957: l_dest_charge_account_flex VARCHAR2(2000);
958: l_dest_variance_account_flex VARCHAR2(2000);

Line 967: l_code_combination_id po_distributions_all.CODE_COMBINATION_ID%TYPE;

963: l_charge_account_desc VARCHAR2(2000);
964: l_budget_account_desc VARCHAR2(2000);
965: l_accrual_account_desc VARCHAR2(2000);
966: l_variance_account_desc VARCHAR2(2000);
967: l_code_combination_id po_distributions_all.CODE_COMBINATION_ID%TYPE;
968: l_budget_account_id po_distributions_all.BUDGET_ACCOUNT_ID%TYPE;
969: l_accrual_account_id po_distributions_all.ACCRUAL_ACCOUNT_ID%TYPE;
970: l_variance_account_id po_distributions_all.VARIANCE_ACCOUNT_ID%TYPE;
971: l_award_number gms_awards_all.award_number%TYPE;

Line 968: l_budget_account_id po_distributions_all.BUDGET_ACCOUNT_ID%TYPE;

964: l_budget_account_desc VARCHAR2(2000);
965: l_accrual_account_desc VARCHAR2(2000);
966: l_variance_account_desc VARCHAR2(2000);
967: l_code_combination_id po_distributions_all.CODE_COMBINATION_ID%TYPE;
968: l_budget_account_id po_distributions_all.BUDGET_ACCOUNT_ID%TYPE;
969: l_accrual_account_id po_distributions_all.ACCRUAL_ACCOUNT_ID%TYPE;
970: l_variance_account_id po_distributions_all.VARIANCE_ACCOUNT_ID%TYPE;
971: l_award_number gms_awards_all.award_number%TYPE;
972:

Line 969: l_accrual_account_id po_distributions_all.ACCRUAL_ACCOUNT_ID%TYPE;

965: l_accrual_account_desc VARCHAR2(2000);
966: l_variance_account_desc VARCHAR2(2000);
967: l_code_combination_id po_distributions_all.CODE_COMBINATION_ID%TYPE;
968: l_budget_account_id po_distributions_all.BUDGET_ACCOUNT_ID%TYPE;
969: l_accrual_account_id po_distributions_all.ACCRUAL_ACCOUNT_ID%TYPE;
970: l_variance_account_id po_distributions_all.VARIANCE_ACCOUNT_ID%TYPE;
971: l_award_number gms_awards_all.award_number%TYPE;
972:
973: CURSOR dists_csr(p_doc_id IN NUMBER, p_draftid IN NUMBER) --bug16628805

Line 970: l_variance_account_id po_distributions_all.VARIANCE_ACCOUNT_ID%TYPE;

966: l_variance_account_desc VARCHAR2(2000);
967: l_code_combination_id po_distributions_all.CODE_COMBINATION_ID%TYPE;
968: l_budget_account_id po_distributions_all.BUDGET_ACCOUNT_ID%TYPE;
969: l_accrual_account_id po_distributions_all.ACCRUAL_ACCOUNT_ID%TYPE;
970: l_variance_account_id po_distributions_all.VARIANCE_ACCOUNT_ID%TYPE;
971: l_award_number gms_awards_all.award_number%TYPE;
972:
973: CURSOR dists_csr(p_doc_id IN NUMBER, p_draftid IN NUMBER) --bug16628805
974: IS

Line 1224: PO_DISTRIBUTIONS_ALL POD

1220: BEGIN
1221: IF NVL(p_draft_id,-1) = -1 THEN --bug 16628805
1222: SELECT NULL INTO l_dummy
1223: FROM
1224: PO_DISTRIBUTIONS_ALL POD
1225: WHERE POD.po_distribution_id = l_dists.po_distribution_id
1226: FOR UPDATE
1227: NOWAIT;
1228: ELSE

Line 1589: update po_distributions_all

1585: IF l_isPoChargeAccountReadOnly = FALSE
1586: THEN
1587: --update current distribution code_combination_id with l_code_combination_id
1588: IF NVL(p_draft_id,-1) = -1 THEN --bug 16628805
1589: update po_distributions_all
1590: set code_combination_id = l_code_combination_id
1591: , last_update_date = sysdate
1592: , last_updated_by = FND_GLOBAL.user_id
1593: where po_distribution_id = l_dists.po_distribution_id;

Line 1615: update po_distributions_all

1611: PO_LOG.stmt(d_module,d_position,'new_budget_account_id', l_budget_account_id);
1612: END IF;
1613: --update current distribution budget_account_id with l_budget_account_id
1614: IF NVL(p_draft_id, -1) = -1 THEN --bug 16628805
1615: update po_distributions_all
1616: set budget_account_id = l_budget_account_id
1617: , last_update_date = sysdate
1618: , last_updated_by = FND_GLOBAL.user_id
1619: where po_distribution_id = l_dists.po_distribution_id;

Line 1637: update po_distributions_all

1633: END IF;
1634: --update current distribution accrual_account_id with l_accrual_account_id
1635: --update current distribution variance_account_id with l_variance_account_id
1636: IF NVL(p_draft_id, -1) = -1 THEN --bug 16628805
1637: update po_distributions_all
1638: set accrual_account_id = l_accrual_account_id
1639: , variance_account_id = l_variance_account_id
1640: , last_update_date = sysdate
1641: , last_updated_by = FND_GLOBAL.user_id

Line 1661: update po_distributions_all

1657: IF l_isSPSDistribution THEN
1658: --update current distribution dest_charge_account_id with l_dest_charge_account_id
1659: --update current distribution dest_variance_account_id with l_dest_variance_account_id
1660: IF NVL(p_draft_id, -1) = -1 THEN --bug 16628805
1661: update po_distributions_all
1662: set dest_charge_account_id = l_dest_charge_account_id
1663: , dest_variance_account_id = l_dest_variance_account_id
1664: , last_update_date = sysdate
1665: , last_updated_by = FND_GLOBAL.user_id