DBA Data[Home] [Help]

APPS.GML_RECV_TRANS_PKG dependencies on PO_LINE_LOCATIONS_ALL

Line 49: v_apps_po_line_location_id po_line_locations_all.line_location_id%TYPE;

45: v_dtl_recv_date po_recv_dtl.recv_date%TYPE;
46:
47: v_apps_po_header_id po_headers_all.po_header_id%TYPE;
48: v_apps_po_line_id po_lines_all.po_line_id%TYPE;
49: v_apps_po_line_location_id po_line_locations_all.line_location_id%TYPE;
50: v_ship_to_organization_id po_line_locations_all.ship_to_organization_id%TYPE;
51:
52: new_header_interface_id rcv_headers_interface.header_interface_id%TYPE;
53: new_group_id rcv_headers_interface.group_id%TYPE;

Line 50: v_ship_to_organization_id po_line_locations_all.ship_to_organization_id%TYPE;

46:
47: v_apps_po_header_id po_headers_all.po_header_id%TYPE;
48: v_apps_po_line_id po_lines_all.po_line_id%TYPE;
49: v_apps_po_line_location_id po_line_locations_all.line_location_id%TYPE;
50: v_ship_to_organization_id po_line_locations_all.ship_to_organization_id%TYPE;
51:
52: new_header_interface_id rcv_headers_interface.header_interface_id%TYPE;
53: new_group_id rcv_headers_interface.group_id%TYPE;
54: new_interface_transaction_id rcv_transactions_interface.interface_transaction_id%TYPE;

Line 86: FROM po_line_locations_all

82: CURSOR po_line_loc_cur(vc_apps_po_header_id NUMBER,
83: vc_apps_po_line_id NUMBER,
84: vc_apps_po_line_location_id NUMBER) IS
85: SELECT ship_to_organization_id
86: FROM po_line_locations_all
87: WHERE po_header_id = vc_apps_po_header_id AND
88: po_line_id = vc_apps_po_line_id AND
89: line_location_id = vc_apps_po_line_location_id;
90:

Line 838: v_apps_po_line_location_id po_line_locations_all.line_location_id%TYPE;

834: v_item_rev po_lines_all.item_revision%TYPE;
835: v_org_id po_lines_all.org_id%TYPE;
836: v_unit_price po_lines_all.unit_price%TYPE;
837:
838: v_apps_po_line_location_id po_line_locations_all.line_location_id%TYPE;
839: v_ship_to_location_id po_line_locations_all.ship_to_location_id%TYPE;
840: v_ship_to_organization_id po_line_locations_all.ship_to_organization_id%TYPE;
841: v_po_release_id po_line_locations_all.po_release_id%TYPE;
842:

Line 839: v_ship_to_location_id po_line_locations_all.ship_to_location_id%TYPE;

835: v_org_id po_lines_all.org_id%TYPE;
836: v_unit_price po_lines_all.unit_price%TYPE;
837:
838: v_apps_po_line_location_id po_line_locations_all.line_location_id%TYPE;
839: v_ship_to_location_id po_line_locations_all.ship_to_location_id%TYPE;
840: v_ship_to_organization_id po_line_locations_all.ship_to_organization_id%TYPE;
841: v_po_release_id po_line_locations_all.po_release_id%TYPE;
842:
843: new_header_interface_id rcv_headers_interface.header_interface_id%TYPE;

Line 840: v_ship_to_organization_id po_line_locations_all.ship_to_organization_id%TYPE;

836: v_unit_price po_lines_all.unit_price%TYPE;
837:
838: v_apps_po_line_location_id po_line_locations_all.line_location_id%TYPE;
839: v_ship_to_location_id po_line_locations_all.ship_to_location_id%TYPE;
840: v_ship_to_organization_id po_line_locations_all.ship_to_organization_id%TYPE;
841: v_po_release_id po_line_locations_all.po_release_id%TYPE;
842:
843: new_header_interface_id rcv_headers_interface.header_interface_id%TYPE;
844: new_group_id rcv_headers_interface.group_id%TYPE;

Line 841: v_po_release_id po_line_locations_all.po_release_id%TYPE;

837:
838: v_apps_po_line_location_id po_line_locations_all.line_location_id%TYPE;
839: v_ship_to_location_id po_line_locations_all.ship_to_location_id%TYPE;
840: v_ship_to_organization_id po_line_locations_all.ship_to_organization_id%TYPE;
841: v_po_release_id po_line_locations_all.po_release_id%TYPE;
842:
843: new_header_interface_id rcv_headers_interface.header_interface_id%TYPE;
844: new_group_id rcv_headers_interface.group_id%TYPE;
845: tmp_group_id rcv_headers_interface.group_id%TYPE;

Line 962: /* Uday Phadtare B1785880 select price_override from po_line_locations_all */

958: FROM po_lines_all
959: WHERE po_header_id = vc_apps_po_header_id AND
960: po_line_id = vc_apps_po_line_id;
961:
962: /* Uday Phadtare B1785880 select price_override from po_line_locations_all */
963: CURSOR po_line_loc_cur(vc_apps_po_header_id NUMBER,
964: vc_apps_po_line_id NUMBER,
965: vc_apps_po_line_location_id NUMBER) IS
966: SELECT ship_to_location_id,po_release_id,ship_to_organization_id,price_override

Line 967: FROM po_line_locations_all

963: CURSOR po_line_loc_cur(vc_apps_po_header_id NUMBER,
964: vc_apps_po_line_id NUMBER,
965: vc_apps_po_line_location_id NUMBER) IS
966: SELECT ship_to_location_id,po_release_id,ship_to_organization_id,price_override
967: FROM po_line_locations_all
968: WHERE po_header_id = vc_apps_po_header_id AND
969: po_line_id = vc_apps_po_line_id AND
970: line_location_id = vc_apps_po_line_location_id;
971:

Line 1030: from po_headers_all po, po_lines_all lines, po_line_locations_all shipments

1026: CURSOR doc_nums_cur(vc_apps_po_header_id NUMBER,
1027: vc_apps_po_line_id NUMBER,
1028: vc_apps_po_line_location_id NUMBER) IS
1029: select po.segment1, lines.line_num, shipments.shipment_num
1030: from po_headers_all po, po_lines_all lines, po_line_locations_all shipments
1031: where po.po_header_id = vc_apps_po_header_id
1032: and lines.po_header_id = po.po_header_id
1033: and lines.po_line_id = vc_apps_po_line_id
1034: and shipments.po_header_id = po.po_header_id

Line 1112: /* Uday Phadtare B1785880 v_unit_price fetched from po_line_locations_all */

1108: OPEN app_po_line_cur(v_apps_po_header_id, v_apps_po_line_id);
1109: FETCH app_po_line_cur INTO v_item_rev, v_org_id;
1110: CLOSE app_po_line_cur;
1111:
1112: /* Uday Phadtare B1785880 v_unit_price fetched from po_line_locations_all */
1113: OPEN po_line_loc_cur(v_apps_po_header_id, v_apps_po_line_id,
1114: v_apps_po_line_location_id);
1115: FETCH po_line_loc_cur INTO v_ship_to_location_id,v_po_release_id,
1116: v_ship_to_organization_id,v_unit_price;