[Home] [Help]
3729: rsl.requested_amount requested_amount,
3730: rsl.material_stored_amount material_stored_amount,
3731: pll.matching_basis
3732: FROM
3733: --po_distributions_all pod,
3734: po_line_locations_all pll,
3735: po_lines_all pl,
3736: po_headers_all ph,
3737: rcv_shipment_lines rsl,
3766: pod.quantity_ordered,
3767: pod.amount_ordered,
3768: pod.destination_type_code destination_type_code,
3769: pod.destination_type_code destination_context
3770: from po_distributions_all pod
3771: where pod.line_location_id = l_line_location_id;
3772: cursor get_shipment_lines(l_shipment_header_id number) is
3773: select rsl.shipment_line_id
3774: from rcv_shipment_lines rsl
4921: select count(*)
4922: into l_count
4923: from gms_awards_all awd,
4924: gms_award_distributions adl,
4925: po_distributions_all pod
4926: where adl.award_id = awd.award_id
4927: and adl.adl_line_num = 1
4928: and adl.po_distribution_id =pod.po_distribution_id
4929: and adl.award_set_id = pod.award_id
4935: select awd.award_number
4936: into l_award_number
4937: from gms_awards_all awd,
4938: gms_award_distributions adl,
4939: po_distributions_all pod
4940: where adl.award_id = awd.award_id
4941: and adl.adl_line_num = 1
4942: and adl.po_distribution_id =pod.po_distribution_id
4943: and adl.award_set_id = pod.award_id
4956:
4957: select count(*)
4958: into l_count
4959: from hr_locations_all_tl hl,
4960: po_distributions_all pod
4961: where pod.deliver_to_location_id = hl.location_id and
4962: hl.language (+) =userenv('LANG') and
4963: pod.po_distribution_id = p_wc_id;
4964:
4968: else
4969: select hl.location_code
4970: into l_deliver_to_location
4971: from hr_locations_all_tl hl,
4972: po_distributions_all pod
4973: where pod.deliver_to_location_id = hl.location_id and
4974: hl.language (+) =userenv('LANG') and
4975: pod.po_distribution_id = p_wc_id;
4976:
5045:
5046: select count(*)
5047: into l_count
5048: from pa_projects_all pa,
5049: po_distributions_all pod
5050: where pod.project_id = pa.project_id and
5051: pod.po_distribution_id = p_wc_id;
5052:
5053:
5057:
5058: select pa.name
5059: into l_project_name
5060: from pa_projects_all pa,
5061: po_distributions_all pod
5062: where pod.project_id = pa.project_id and
5063: pod.po_distribution_id = p_wc_id;
5064:
5065:
5075:
5076: select count(*)
5077: into l_count
5078: from pa_tasks pa,
5079: po_distributions_all pod
5080: where pod.task_id = pa.task_id and
5081: pod.po_distribution_id = p_wc_id;
5082:
5083:
5087:
5088: select pa.task_name
5089: into l_task_name
5090: from pa_tasks pa,
5091: po_distributions_all pod
5092: where pod.task_id = pa.task_id and
5093: pod.po_distribution_id = p_wc_id;
5094:
5095: return l_task_name;
5104:
5105: select count(*)
5106: into l_count
5107: from gl_code_combinations_kfv glc,
5108: po_distributions_all pod
5109: where pod.code_combination_id = glc.code_combination_id and
5110: pod.po_distribution_id = p_wc_id;
5111:
5112:
5116:
5117: select glc.concatenated_segments
5118: into l_segments
5119: from gl_code_combinations_kfv glc,
5120: po_distributions_all pod
5121: where pod.code_combination_id = glc.code_combination_id and
5122: pod.po_distribution_id = p_wc_id;
5123:
5124: return l_segments;
5133:
5134: select count(*)
5135: into l_count
5136: from org_organization_definitions ood,
5137: po_distributions_all pod
5138: where pod.expenditure_organization_id = ood.organization_id
5139: and pod.po_distribution_id = p_wc_id;
5140:
5141:
5145:
5146: select ood.organization_name
5147: into l_org_name
5148: from org_organization_definitions ood,
5149: po_distributions_all pod
5150: where pod.expenditure_organization_id = ood.organization_id
5151: and pod.po_distribution_id = p_wc_id;
5152:
5153: return l_org_name;