eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.POR_RCV_ORD_SV dependencies on RCV_SHIPMENT_HEADERS

Line 45: from rcv_shipment_lines rsl, rcv_shipment_headers rsh

41:
42:
43: cursor rcv_header(p_lineLocationId number) is
44: select rsl.shipment_line_id, rsl.quantity_shipped, nvl(rsl.quantity_received,0), rsl.unit_of_measure
45: from rcv_shipment_lines rsl, rcv_shipment_headers rsh
46: where rsl.po_line_location_id = p_lineLocationId
47: and nvl(rsl.quantity_shipped, 0) > nvl(rsl.quantity_received, 0)
48: and rsl.shipment_header_id = rsh.shipment_header_id
49: and rsh.asn_type in ('ASN','ASBN');

Line 777: FROM RCV_SHIPMENT_HEADERS RSH,

773: x_req_line_id,
774: X_Comments,
775: X_WayBillNum,
776: NULL
777: FROM RCV_SHIPMENT_HEADERS RSH,
778: RCV_SHIPMENT_LINES RSL,
779: MTL_SYSTEM_ITEMS MSI
780: WHERE RSH.RECEIPT_SOURCE_CODE <> 'VENDOR' AND
781: RSH.SHIPMENT_HEADER_ID = RSL.SHIPMENT_HEADER_ID AND

Line 1278: X_return_code := create_rcv_shipment_headers(X_group_Id, X_caller,X_Comments, X_PackingSlip ,X_WayBillNum);

1274:
1275: if (X_rows_succeeded > 0) then
1276:
1277:
1278: X_return_code := create_rcv_shipment_headers(X_group_Id, X_caller,X_Comments, X_PackingSlip ,X_WayBillNum);
1279:
1280:
1281: if (X_return_code) then
1282: /** Bug# 7030461 -- As part of bug 3560995, commit was commented out. It gives

Line 1359: function create_rcv_shipment_headers (X_group_id IN NUMBER,

1355: ** for those txns that have the same vendor
1356: ** and to_org_id.
1357: *****************************************************/
1358:
1359: function create_rcv_shipment_headers (X_group_id IN NUMBER,
1360: X_caller IN varchar2,
1361: X_Comments IN varchar2 default null,
1362: X_PackingSlip IN varchar2 default null,
1363: X_WayBillNum IN varchar2 default null)

Line 1403: X_receipt_num rcv_shipment_headers.receipt_num%type;

1399: X_userid number := 0;
1400: X_vendor_id rcv_transactions_interface.vendor_id%type;
1401: X_org_id PO_DISTRIBUTIONS_ALL.ORG_ID%type;
1402: X_to_org_id rcv_transactions_interface.to_organization_id%type;
1403: X_receipt_num rcv_shipment_headers.receipt_num%type;
1404: X_created_by rcv_shipment_headers.created_by%type;
1405: X_last_update_login rcv_shipment_headers.last_update_login%type;
1406: X_count number := 0;
1407: X_shipment_header_id rcv_shipment_headers.shipment_header_id%type;

Line 1404: X_created_by rcv_shipment_headers.created_by%type;

1400: X_vendor_id rcv_transactions_interface.vendor_id%type;
1401: X_org_id PO_DISTRIBUTIONS_ALL.ORG_ID%type;
1402: X_to_org_id rcv_transactions_interface.to_organization_id%type;
1403: X_receipt_num rcv_shipment_headers.receipt_num%type;
1404: X_created_by rcv_shipment_headers.created_by%type;
1405: X_last_update_login rcv_shipment_headers.last_update_login%type;
1406: X_count number := 0;
1407: X_shipment_header_id rcv_shipment_headers.shipment_header_id%type;
1408: X_employee_id rcv_shipment_headers.employee_id%type := 0;

Line 1405: X_last_update_login rcv_shipment_headers.last_update_login%type;

1401: X_org_id PO_DISTRIBUTIONS_ALL.ORG_ID%type;
1402: X_to_org_id rcv_transactions_interface.to_organization_id%type;
1403: X_receipt_num rcv_shipment_headers.receipt_num%type;
1404: X_created_by rcv_shipment_headers.created_by%type;
1405: X_last_update_login rcv_shipment_headers.last_update_login%type;
1406: X_count number := 0;
1407: X_shipment_header_id rcv_shipment_headers.shipment_header_id%type;
1408: X_employee_id rcv_shipment_headers.employee_id%type := 0;
1409: X_request_id rcv_shipment_headers.request_id%type := 0;

Line 1407: X_shipment_header_id rcv_shipment_headers.shipment_header_id%type;

1403: X_receipt_num rcv_shipment_headers.receipt_num%type;
1404: X_created_by rcv_shipment_headers.created_by%type;
1405: X_last_update_login rcv_shipment_headers.last_update_login%type;
1406: X_count number := 0;
1407: X_shipment_header_id rcv_shipment_headers.shipment_header_id%type;
1408: X_employee_id rcv_shipment_headers.employee_id%type := 0;
1409: X_request_id rcv_shipment_headers.request_id%type := 0;
1410:
1411: X_pgm_app_id rcv_shipment_headers.program_application_id%type := 0;

Line 1408: X_employee_id rcv_shipment_headers.employee_id%type := 0;

1404: X_created_by rcv_shipment_headers.created_by%type;
1405: X_last_update_login rcv_shipment_headers.last_update_login%type;
1406: X_count number := 0;
1407: X_shipment_header_id rcv_shipment_headers.shipment_header_id%type;
1408: X_employee_id rcv_shipment_headers.employee_id%type := 0;
1409: X_request_id rcv_shipment_headers.request_id%type := 0;
1410:
1411: X_pgm_app_id rcv_shipment_headers.program_application_id%type := 0;
1412: X_pgm_id rcv_shipment_headers.program_id%type := 0;

Line 1409: X_request_id rcv_shipment_headers.request_id%type := 0;

1405: X_last_update_login rcv_shipment_headers.last_update_login%type;
1406: X_count number := 0;
1407: X_shipment_header_id rcv_shipment_headers.shipment_header_id%type;
1408: X_employee_id rcv_shipment_headers.employee_id%type := 0;
1409: X_request_id rcv_shipment_headers.request_id%type := 0;
1410:
1411: X_pgm_app_id rcv_shipment_headers.program_application_id%type := 0;
1412: X_pgm_id rcv_shipment_headers.program_id%type := 0;
1413: l_err_message varchar2(240) := null;

Line 1411: X_pgm_app_id rcv_shipment_headers.program_application_id%type := 0;

1407: X_shipment_header_id rcv_shipment_headers.shipment_header_id%type;
1408: X_employee_id rcv_shipment_headers.employee_id%type := 0;
1409: X_request_id rcv_shipment_headers.request_id%type := 0;
1410:
1411: X_pgm_app_id rcv_shipment_headers.program_application_id%type := 0;
1412: X_pgm_id rcv_shipment_headers.program_id%type := 0;
1413: l_err_message varchar2(240) := null;
1414: x_rcpt_count NUMBER := 1;
1415: x_organization_name VARCHAR2(60);

Line 1412: X_pgm_id rcv_shipment_headers.program_id%type := 0;

1408: X_employee_id rcv_shipment_headers.employee_id%type := 0;
1409: X_request_id rcv_shipment_headers.request_id%type := 0;
1410:
1411: X_pgm_app_id rcv_shipment_headers.program_application_id%type := 0;
1412: X_pgm_id rcv_shipment_headers.program_id%type := 0;
1413: l_err_message varchar2(240) := null;
1414: x_rcpt_count NUMBER := 1;
1415: x_organization_name VARCHAR2(60);
1416: x_supplier_name PO_VENDORS.VENDOR_NAME%TYPE;

Line 1464: FROM rcv_shipment_headers

1460: LOOP
1461:
1462: SELECT count(*)
1463: INTO X_count
1464: FROM rcv_shipment_headers
1465: WHERE receipt_num = X_receipt_num and
1466: ship_to_org_id = X_to_org_id;
1467:
1468: IF (X_count = 0) THEN

Line 1482: SELECT rcv_shipment_headers_s.nextval

1478: END LOOP;
1479:
1480: /* Get the shipment Header id */
1481:
1482: SELECT rcv_shipment_headers_s.nextval
1483: INTO X_shipment_header_id
1484: FROM sys.dual;
1485:
1486:

Line 1490: INSERT INTO RCV_SHIPMENT_HEADERS (

1486:
1487: /* For every unique Org_id, Vendor_id combination,
1488: ** create a header */
1489:
1490: INSERT INTO RCV_SHIPMENT_HEADERS (
1491: SHIPMENT_HEADER_ID,
1492: LAST_UPDATE_DATE,
1493: LAST_UPDATED_BY,
1494: CREATION_DATE,

Line 1567: update rcv_shipment_headers

1563: X_vendor_site_id := null;
1564: END;
1565:
1566: if(X_vendor_site_id is not null) then
1567: update rcv_shipment_headers
1568: set vendor_site_id = X_vendor_site_id
1569: where shipment_header_id = x_shipment_header_id;
1570: end if;
1571:

Line 1590: from rcv_shipment_headers

1586:
1587: begin
1588: select receipt_num
1589: into X_receipt_num
1590: from rcv_shipment_headers
1591: where shipment_header_id = X_shipment_header_id and
1592: receipt_num is not null;
1593: exception
1594: when no_data_found then

Line 1606: FROM rcv_shipment_headers

1602: LOOP
1603:
1604: SELECT count(*)
1605: INTO X_count
1606: FROM rcv_shipment_headers
1607: WHERE receipt_num = X_receipt_num and
1608: ship_to_org_id = X_to_org_id;
1609:
1610: IF (X_count = 0) THEN

Line 1622: update rcv_shipment_headers

1618: END IF;
1619:
1620: END LOOP;
1621:
1622: update rcv_shipment_headers
1623: set receipt_num=X_receipt_num
1624: where shipment_header_id = X_shipment_header_id;
1625:
1626: end; -- no receipt number

Line 1643: end create_rcv_shipment_headers;

1639: APP_EXCEPTION.RAISE_EXCEPTION;
1640: end if;
1641: return FALSE;
1642:
1643: end create_rcv_shipment_headers;
1644:
1645:
1646: /*************************************************************
1647: ** Function : Call_Txn_Processor