APPS.RCV_CHARGES_GRP dependencies on RCV_SHIPMENT_LINES

Line 347: , p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE

343: Procedure Add_Charge_From_Interface
344: ( p_charge_interface IN rcv_charges_interface%ROWTYPE
345: , p_charge_table IN OUT NOCOPY PO_CHARGES_GRP.charge_table_type
346: , p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE
347: , p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE
348: ) IS
349: l_charge po_rcv_charges%ROWTYPE;
350: l_cost_factor_details pon_price_element_types_vl%ROWTYPE;
351: BEGIN

Line 548: FROM rcv_shipment_lines rsl

544: , l_uom_classes
545: , l_primary_units_of_measure
546: , l_unit_volumes
547: , l_volume_uoms
548: FROM rcv_shipment_lines rsl
549: , mtl_system_items msi
550: , mtl_units_of_measure muom_rsl
551: , mtl_units_of_measure muom_unit
552: WHERE rsl.shipment_header_id = p_charge.shipment_header_id

Line 662: FROM rcv_shipment_lines rsl

658: , l_uom_classes
659: , l_primary_units_of_measure
660: , l_unit_weights
661: , l_weight_uoms
662: FROM rcv_shipment_lines rsl
663: , mtl_system_items msi
664: , mtl_units_of_measure muom_rsl
665: , mtl_units_of_measure muom_unit
666: WHERE rsl.shipment_header_id = p_charge.shipment_header_id

Line 740: FROM rcv_shipment_lines

736: SELECT shipment_line_id
737: , decode(quantity_received, 0, quantity_shipped, quantity_received)
738: BULK COLLECT INTO l_shipment_line_ids
739: , l_shipment_line_quantities
740: FROM rcv_shipment_lines
741: WHERE shipment_header_id = p_charge.shipment_header_id;
742:
743: -- prorate the charge according to the quantities
744: Prorate_Charge( p_charge

Line 765: FROM rcv_shipment_lines rsl

761: SELECT rsl.shipment_line_id
762: , decode(rsl.quantity_received, 0, rsl.quantity_shipped, rsl.quantity_received) * pol.unit_price
763: BULK COLLECT INTO l_shipment_line_ids
764: , l_shipment_line_amounts
765: FROM rcv_shipment_lines rsl
766: , po_lines_all pol
767: WHERE rsl.shipment_header_id = p_charge.shipment_header_id
768: AND pol.po_line_id = rsl.po_line_id;
769:

Line 959: , p_shipment_line_id IN RCV_SHIPMENT_LINES.shipment_line_id%TYPE

955: , x_msg_data OUT NOCOPY VARCHAR2
956: , p_rhi_id IN RCV_HEADERS_INTERFACE.header_interface_id%TYPE
957: , p_rti_id IN RCV_TRANSACTIONS_INTERFACE.interface_transaction_id%TYPE
958: , p_shipment_header_id IN RCV_SHIPMENT_HEADERS.shipment_header_id%TYPE
959: , p_shipment_line_id IN RCV_SHIPMENT_LINES.shipment_line_id%TYPE
960: ) IS
961: l_charge_interface_table charge_interface_table_type;
962: l_charge_table PO_CHARGES_GRP.charge_table_type;
963: l_charge_allocation_table PO_CHARGES_GRP.charge_allocation_table_type;