[Home] [Help]
498: AND NOT EXISTS
499: (
500: SELECT
501: NULL
502: FROM wip_transaction_accounts wta
503: WHERE wta.transaction_id = wt.transaction_id
504: )
505: )
506: OR wt.source_code = 'IPV' -- Bug 2130771
1411: wta.basis_resource_id c_basis_resource_id,
1412: wta.reference_account c_reference_account,
1413: wta.wip_sub_ledger_id c_wip_dr_sub_ledger_id,
1414: nvl2(ppf.npw_number,'CTW',null) c_person_type
1415: FROM wip_transaction_accounts wta,
1416: wip_transactions wt,
1417: bom_resources br,
1418: bom_departments bd,
1419: per_people_f ppf
1464: wta.basis_resource_id c_basis_resource_id,
1465: wta.reference_account c_reference_account,
1466: wta.wip_sub_ledger_id c_wip_dr_sub_ledger_id,
1467: NULL c_person_type
1468: FROM wip_transaction_accounts wta,
1469: wip_transactions wt,
1470: pjm_project_parameters ppp,
1471: po_lines_all pla
1472: WHERE wt.transaction_type = 17
1604: */
1605:
1606: SELECT NVL(reference_account,-99)
1607: INTO l_cr_code_combination_id
1608: FROM wip_transaction_accounts
1609: WHERE transaction_id = p_transaction_id
1610: AND organization_id = p_org_id
1611: AND cost_element_id = wt_rec.c_cost_element_id
1612: AND accounting_line_type = l_accounting_line_type
1617: l_stmt_num := 16;
1618:
1619: SELECT MAX(WIP_SUB_LEDGER_ID)
1620: INTO l_wip_cr_sub_ledger_id
1621: FROM wip_transaction_accounts wta
1622: WHERE transaction_id = p_transaction_id
1623: AND reference_account = l_cr_code_combination_id
1624: AND organization_id = p_org_id
1625: AND cost_element_id = wt_rec.c_cost_element_id
5924: into l_cc_rate,
5925: l_cc_type,
5926: l_cc_date,
5927: l_cc_foreign_currency
5928: from wip_transaction_accounts wta
5929: where wta.transaction_id = p_transaction_id
5930: and wta.transaction_value is not null
5931: and accounting_line_type <> 15 /*Changes for encumbrance SF project */
5932: and rownum<2;