APPS.PO_INVOICES_SV2 dependencies on PO_LINE_LOCATIONS

Line 28: RETURN PO_LINE_LOCATIONS.SHIP_TO_LOCATION_ID%TYPE IS

24: Bug: 5125624
25: ==================================================================*/
26:
27: FUNCTION get_ship_to_location_id (p_po_line_location_id IN NUMBER)
28: RETURN PO_LINE_LOCATIONS.SHIP_TO_LOCATION_ID%TYPE IS
29: l_ship_to_location_id PO_LINE_LOCATIONS.SHIP_TO_LOCATION_ID%TYPE;
30: BEGIN
31:
32: SELECT

Line 29: l_ship_to_location_id PO_LINE_LOCATIONS.SHIP_TO_LOCATION_ID%TYPE;

25: ==================================================================*/
26:
27: FUNCTION get_ship_to_location_id (p_po_line_location_id IN NUMBER)
28: RETURN PO_LINE_LOCATIONS.SHIP_TO_LOCATION_ID%TYPE IS
29: l_ship_to_location_id PO_LINE_LOCATIONS.SHIP_TO_LOCATION_ID%TYPE;
30: BEGIN
31:
32: SELECT
33: ship_to_location_id INTO l_ship_to_location_id

Line 35: po_line_locations_all

31:
32: SELECT
33: ship_to_location_id INTO l_ship_to_location_id
34: FROM
35: po_line_locations_all
36: WHERE
37: line_location_id = p_po_line_location_id;
38: IF (g_asn_debug = 'Y') THEN
39: asn_debug.put_line('po_line_location_id = ' || p_po_line_location_id || ' has ship to location id = ' || l_ship_to_location_id);

Line 222: po_line_locations_all plls,

218: --Bugfix 5407632 - Using _all tables instead of views.
219: po_headers_all phs,
220: -- po_releases_all prs, /*Bug 5443196*/
221: po_lines_all pls,
222: po_line_locations_all plls,
223: rcv_shipment_headers rsh,
224: rcv_shipment_lines rsl,
225: rcv_transactions rts
226: WHERE rts.shipment_header_id = rsh.shipment_header_id

Line 300: po_line_locations_all plls,

296: --Bugfix 5407632 - Using _all tables instead of views.
297: po_headers_all phs,
298: po_releases_all prs,
299: po_lines_all pls,
300: po_line_locations_all plls,
301: rcv_shipment_headers rsh,
302: rcv_shipment_lines rsl,
303: rcv_transactions rts
304: WHERE rts.shipment_header_id = rsh.shipment_header_id

Line 397: po_line_locations plls,

393: po_vendors pvds,
394: po_headers phs,
395: po_releases prs,
396: po_lines pls,
397: po_line_locations plls,
398: rcv_shipment_headers rsh,
399: rcv_shipment_lines rsl,
400: rcv_transactions rts
401: WHERE rts.shipment_header_id = rsh.shipment_header_id

Line 531: x_curr_shipment_type po_line_locations_all.shipment_type%type;

527: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
528: /* */
529:
530: /* R12 Complex Work.*/
531: x_curr_shipment_type po_line_locations_all.shipment_type%type;
532:
533: /*Bug: 5125624*/
534: l_ship_to_location_id PO_LINE_LOCATIONS.SHIP_TO_LOCATION_ID%TYPE;
535: l_tax_classification_code VARCHAR2(30);

Line 534: l_ship_to_location_id PO_LINE_LOCATIONS.SHIP_TO_LOCATION_ID%TYPE;

530: /* R12 Complex Work.*/
531: x_curr_shipment_type po_line_locations_all.shipment_type%type;
532:
533: /*Bug: 5125624*/
534: l_ship_to_location_id PO_LINE_LOCATIONS.SHIP_TO_LOCATION_ID%TYPE;
535: l_tax_classification_code VARCHAR2(30);
536:
537: X_curr_receipt_num rcv_shipment_headers.receipt_num%TYPE := NULL; /* bug 7512542 */
538: X_curr_por_summary_code po_vendor_sites.pay_on_receipt_summary_code%TYPE := NULL; /* bug 7512542 */

Line 1137: update rcv_txns, po_line_locations and po_distributions accordingly *****/

1133:
1134: END IF; /** change in one of the curr_ variables **/
1135:
1136: /**** Create invoice distribution(s) , tax distribution(s) and
1137: update rcv_txns, po_line_locations and po_distributions accordingly *****/
1138:
1139:
1140: X_progress := '140'; -- receipt_invoices
1141:

Line 2213: l_ship_to_location_id PO_LINE_LOCATIONS.SHIP_TO_LOCATION_ID%TYPE;

2209: X_line_count NUMBER;
2210: x_org_id NUMBER; --Bug# 2492041
2211:
2212: /*Bug: 5125624*/
2213: l_ship_to_location_id PO_LINE_LOCATIONS.SHIP_TO_LOCATION_ID%TYPE;
2214: l_tax_classification_code VARCHAR2(30);
2215: x_invoiced_quantity NUMBER :=0; -- Added for bug 6822594
2216: x_invoiced_unit_price NUMBER :=0; -- Added for bug 6822594
2217: X_invoiced_amount NUMBER :=0; -- Added for bug 6822594

Line 3427: l_ship_to_location_id PO_LINE_LOCATIONS.SHIP_TO_LOCATION_ID%TYPE;

3423: l_api_name VARCHAR2(50) := 'create_invoice_distr';
3424: i NUMBER;
3425:
3426: /*Bug: 5125624*/
3427: l_ship_to_location_id PO_LINE_LOCATIONS.SHIP_TO_LOCATION_ID%TYPE;
3428: l_tax_classification_code VARCHAR2(30);
3429:
3430: BEGIN
3431: SAVEPOINT create_invoice_distr_sp;