[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
3436: , po_line_id
3437: , line_location_id
3438: , req_distribution_id
3439: , quantity_ordered
3440: FROM po_distributions_all --
3442:
3443: CURSOR get_source_doc_code (v_transaction_id IN NUMBER) IS
3444: SELECT source_document_code, organization_id FROM rcv_transactions
3468: , c.project_id
3469: , c.task_id
3470: FROM rcv_transactions a
3471: , rcv_shipment_lines b
3472: , po_distributions_all c
3473: , mtl_units_of_measure d
3474: WHERE transaction_id = v_transaction_id
3475: AND a.shipment_line_id = b.shipment_line_id
3476: AND c.po_distribution_id = a.po_distribution_id
3516: , c.project_id
3517: , c.task_id
3518: FROM rcv_transactions a
3519: , rcv_shipment_lines b
3520: , po_distributions_all c
3521: , mtl_units_of_measure d
3522: WHERE a.transaction_id = v_transaction_id
3523: AND a.source_document_code = 'PO'
3524: AND b.shipment_line_id = a.shipment_line_id