[Home] [Help]
3897: rsl.material_stored_amount material_stored_amount,
3898: pll.matching_basis,
3899: Nvl(pdsh.clm_flag,'N') clm_flag
3900: FROM
3901: --po_distributions_all pod,
3902: po_line_locations_all pll,
3903: po_lines_all pl,
3904: po_headers_all ph,
3905: rcv_shipment_lines rsl,
3940: pod.amount_funded,
3941: Nvl(pod.partial_funded_flag,'N') partial_funded_flag,
3942: pod.destination_type_code destination_type_code,
3943: pod.destination_type_code destination_context
3944: from po_distributions_all pod
3945: where pod.line_location_id = l_line_location_id
3946: order by pod.distribution_num;
3947:
3948: /* Bug 11869822 */
4003: l_full_fund_amt NUMBER;
4004: l_full_fund_qty NUMBER;
4005:
4006: /* Added for the Bug #: 13924722 */
4007: l_currency_conversion_rate po_distributions_all.rate%TYPE;
4008: l_currency_conversion_date po_distributions_all.rate_date%TYPE;
4009: x_sob_Id NUMBER;
4010: /* End of Bug #: 13924722 */
4011:
4004: l_full_fund_qty NUMBER;
4005:
4006: /* Added for the Bug #: 13924722 */
4007: l_currency_conversion_rate po_distributions_all.rate%TYPE;
4008: l_currency_conversion_date po_distributions_all.rate_date%TYPE;
4009: x_sob_Id NUMBER;
4010: /* End of Bug #: 13924722 */
4011:
4012: begin
4133:
4134: -- getting the number of distributions associated at the current pay item level
4135: SELECT Count(*)
4136: INTO l_max_dist
4137: FROM po_distributions_all pod
4138: where pod.line_location_id = wcr_line_info.po_line_location_id;
4139:
4140: l_dist_count := 0;
4141:
4743: IF (l_clm_flag = 'Y' AND (l_remaining_amount > 0 OR l_remaining_quantity >0) ) THEN
4744: BEGIN
4745: select min(pod.po_distribution_id)
4746: INTO l_full_fund_dist_id
4747: from po_distributions_all pod
4748: where pod.line_location_id = wcr_line_info.po_line_location_id AND
4749: Nvl(pod.partial_funded_flag,'N') = 'N';
4750:
4751: IF(l_full_fund_dist_id IS NOT null) THEN
5248: select count(*)
5249: into l_count
5250: from gms_awards_all awd,
5251: gms_award_distributions adl,
5252: po_distributions_all pod
5253: where adl.award_id = awd.award_id
5254: and adl.adl_line_num = 1
5255: and adl.po_distribution_id =pod.po_distribution_id
5256: and adl.award_set_id = pod.award_id
5262: select awd.award_number
5263: into l_award_number
5264: from gms_awards_all awd,
5265: gms_award_distributions adl,
5266: po_distributions_all pod
5267: where adl.award_id = awd.award_id
5268: and adl.adl_line_num = 1
5269: and adl.po_distribution_id =pod.po_distribution_id
5270: and adl.award_set_id = pod.award_id
5283:
5284: select count(*)
5285: into l_count
5286: from hr_locations_all_tl hl,
5287: po_distributions_all pod
5288: where pod.deliver_to_location_id = hl.location_id and
5289: hl.language (+) =userenv('LANG') and
5290: pod.po_distribution_id = p_wc_id;
5291:
5295: else
5296: select hl.location_code
5297: into l_deliver_to_location
5298: from hr_locations_all_tl hl,
5299: po_distributions_all pod
5300: where pod.deliver_to_location_id = hl.location_id and
5301: hl.language (+) =userenv('LANG') and
5302: pod.po_distribution_id = p_wc_id;
5303:
5372:
5373: select count(*)
5374: into l_count
5375: from pa_projects_all pa,
5376: po_distributions_all pod
5377: where pod.project_id = pa.project_id and
5378: pod.po_distribution_id = p_wc_id;
5379:
5380:
5384:
5385: select pa.name
5386: into l_project_name
5387: from pa_projects_all pa,
5388: po_distributions_all pod
5389: where pod.project_id = pa.project_id and
5390: pod.po_distribution_id = p_wc_id;
5391:
5392:
5402:
5403: select count(*)
5404: into l_count
5405: from pa_tasks_expend_v pa,
5406: po_distributions_all pod
5407: where pod.task_id = pa.task_id and
5408: pod.po_distribution_id = p_wc_id;
5409:
5410:
5414:
5415: select pa.task_name
5416: into l_task_name
5417: from pa_tasks_expend_v pa,
5418: po_distributions_all pod
5419: where pod.task_id = pa.task_id and
5420: pod.po_distribution_id = p_wc_id;
5421:
5422: return l_task_name;
5431:
5432: select count(*)
5433: into l_count
5434: from gl_code_combinations_kfv glc,
5435: po_distributions_all pod
5436: where pod.code_combination_id = glc.code_combination_id and
5437: pod.po_distribution_id = p_wc_id;
5438:
5439:
5443:
5444: select glc.concatenated_segments
5445: into l_segments
5446: from gl_code_combinations_kfv glc,
5447: po_distributions_all pod
5448: where pod.code_combination_id = glc.code_combination_id and
5449: pod.po_distribution_id = p_wc_id;
5450:
5451: return l_segments;
5460:
5461: select count(*)
5462: into l_count
5463: from org_organization_definitions ood,
5464: po_distributions_all pod
5465: where pod.expenditure_organization_id = ood.organization_id
5466: and pod.po_distribution_id = p_wc_id;
5467:
5468:
5472:
5473: select ood.organization_name
5474: into l_org_name
5475: from org_organization_definitions ood,
5476: po_distributions_all pod
5477: where pod.expenditure_organization_id = ood.organization_id
5478: and pod.po_distribution_id = p_wc_id;
5479:
5480: return l_org_name;