APPS.GML_RECV_TRANS_PKG dependencies on PO_DISTRIBUTIONS

Line 849: v_deliver_to_person_id po_distributions.deliver_to_person_id%TYPE;

845: tmp_group_id rcv_headers_interface.group_id%TYPE;
846: new_interface_transaction_id rcv_transactions_interface.interface_transaction_id%TYPE;
847: tmp_interface_transaction_id rcv_transactions_interface.interface_transaction_id%TYPE;
848:
849: v_deliver_to_person_id po_distributions.deliver_to_person_id%TYPE;
850: v_po_distribution_id po_distributions.po_distribution_id%TYPE;
851: v_auto_transact_code rcv_transactions.transaction_type%TYPE;
852: v_destination_type_code rcv_transactions.transaction_type%TYPE;
853: v_transacion_id rcv_transactions.transaction_id%TYPE;

Line 850: v_po_distribution_id po_distributions.po_distribution_id%TYPE;

846: new_interface_transaction_id rcv_transactions_interface.interface_transaction_id%TYPE;
847: tmp_interface_transaction_id rcv_transactions_interface.interface_transaction_id%TYPE;
848:
849: v_deliver_to_person_id po_distributions.deliver_to_person_id%TYPE;
850: v_po_distribution_id po_distributions.po_distribution_id%TYPE;
851: v_auto_transact_code rcv_transactions.transaction_type%TYPE;
852: v_destination_type_code rcv_transactions.transaction_type%TYPE;
853: v_transacion_id rcv_transactions.transaction_id%TYPE;
854: v_header_interface_id rcv_transactions_interface.header_interface_id%TYPE;

Line 939: FROM po_distributions

935: CURSOR po_dist_cur(vc_apps_po_header_id NUMBER,
936: vc_apps_po_line_id NUMBER,
937: vc_apps_po_line_location_id NUMBER) IS
938: SELECT deliver_to_person_id,po_distribution_id
939: FROM po_distributions
940: WHERE po_header_id = vc_apps_po_header_id AND
941: po_line_id = vc_apps_po_line_id AND
942: line_location_id = vc_apps_po_line_location_id;
943: