[Home] [Help]
3299: SELECT b.requisition_line_id req_line_id
3300: , Nvl(b.project_id,-99) project_id
3301: , Nvl(b.task_id, -99) task_id
3302: -- , sum(a.quantity_ordered) quantity_ordered
3303: FROM po_distributions_all a
3304: , po_req_distributions_all b
3305: WHERE a.line_location_id = v_po_shipment_id
3306: AND a.req_distribution_id = b.distribution_id
3307: AND a.distribution_type <> 'AGREEMENT' --
3310: , b.task_id;
3311:
3312: CURSOR get_pt_count_po_shipment(v_po_shipment_id IN NUMBER) IS
3313: SELECT COUNT(min(po_distribution_id)) count
3314: FROM po_distributions_all pd
3315: WHERE pd.line_location_id = v_po_shipment_id
3316: GROUP BY project_id, task_id;
3317:
3318: CURSOR get_proj_task_of_po_shipment(v_po_shipment_id IN NUMBER) IS
3316: GROUP BY project_id, task_id;
3317:
3318: CURSOR get_proj_task_of_po_shipment(v_po_shipment_id IN NUMBER) IS
3319: SELECT Nvl(project_id, -99) project_id, Nvl(task_id, -99) task_id
3320: FROM po_distributions_all
3321: WHERE line_location_id = v_po_shipment_id
3322: GROUP BY project_id,task_id;
3323:
3324: CURSOR get_po_res_qty(v_po_header_id IN NUMBER
3435: , po_line_id
3436: , line_location_id
3437: , req_distribution_id
3438: , quantity_ordered
3439: FROM po_distributions_all --
3441:
3442: CURSOR get_source_doc_code (v_transaction_id IN NUMBER) IS
3443: SELECT source_document_code, organization_id FROM rcv_transactions
3465: , c.project_id
3466: , c.task_id
3467: FROM rcv_transactions a
3468: , rcv_shipment_lines b
3469: , po_distributions_all c
3470: , mtl_units_of_measure d
3471: WHERE transaction_id = v_transaction_id
3472: AND a.shipment_line_id = b.shipment_line_id
3473: AND c.po_distribution_id = a.po_distribution_id
3509: , c.project_id
3510: , c.task_id
3511: FROM rcv_transactions a
3512: , rcv_shipment_lines b
3513: , po_distributions_all c
3514: , mtl_units_of_measure d
3515: WHERE a.transaction_id = v_transaction_id
3516: AND a.source_document_code = 'PO'
3517: AND b.shipment_line_id = a.shipment_line_id