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 1271: X_return_code := create_rcv_shipment_headers(X_group_Id, X_caller,X_Comments, X_PackingSlip ,X_WayBillNum);

1267:
1268: if (X_rows_succeeded > 0) then
1269:
1270:
1271: X_return_code := create_rcv_shipment_headers(X_group_Id, X_caller,X_Comments, X_PackingSlip ,X_WayBillNum);
1272:
1273:
1274: if (X_return_code) then
1275: /** Bug# 7030461 -- As part of bug 3560995, commit was commented out. It gives

Line 1352: function create_rcv_shipment_headers (X_group_id IN NUMBER,

1348: ** for those txns that have the same vendor
1349: ** and to_org_id.
1350: *****************************************************/
1351:
1352: function create_rcv_shipment_headers (X_group_id IN NUMBER,
1353: X_caller IN varchar2,
1354: X_Comments IN varchar2 default null,
1355: X_PackingSlip IN varchar2 default null,
1356: X_WayBillNum IN varchar2 default null)

Line 1396: X_receipt_num rcv_shipment_headers.receipt_num%type;

1392: X_userid number := 0;
1393: X_vendor_id rcv_transactions_interface.vendor_id%type;
1394: X_org_id PO_DISTRIBUTIONS_ALL.ORG_ID%type;
1395: X_to_org_id rcv_transactions_interface.to_organization_id%type;
1396: X_receipt_num rcv_shipment_headers.receipt_num%type;
1397: X_created_by rcv_shipment_headers.created_by%type;
1398: X_last_update_login rcv_shipment_headers.last_update_login%type;
1399: X_count number := 0;
1400: X_shipment_header_id rcv_shipment_headers.shipment_header_id%type;

Line 1397: X_created_by rcv_shipment_headers.created_by%type;

1393: X_vendor_id rcv_transactions_interface.vendor_id%type;
1394: X_org_id PO_DISTRIBUTIONS_ALL.ORG_ID%type;
1395: X_to_org_id rcv_transactions_interface.to_organization_id%type;
1396: X_receipt_num rcv_shipment_headers.receipt_num%type;
1397: X_created_by rcv_shipment_headers.created_by%type;
1398: X_last_update_login rcv_shipment_headers.last_update_login%type;
1399: X_count number := 0;
1400: X_shipment_header_id rcv_shipment_headers.shipment_header_id%type;
1401: X_employee_id rcv_shipment_headers.employee_id%type := 0;

Line 1398: X_last_update_login rcv_shipment_headers.last_update_login%type;

1394: X_org_id PO_DISTRIBUTIONS_ALL.ORG_ID%type;
1395: X_to_org_id rcv_transactions_interface.to_organization_id%type;
1396: X_receipt_num rcv_shipment_headers.receipt_num%type;
1397: X_created_by rcv_shipment_headers.created_by%type;
1398: X_last_update_login rcv_shipment_headers.last_update_login%type;
1399: X_count number := 0;
1400: X_shipment_header_id rcv_shipment_headers.shipment_header_id%type;
1401: X_employee_id rcv_shipment_headers.employee_id%type := 0;
1402: X_request_id rcv_shipment_headers.request_id%type := 0;

Line 1400: X_shipment_header_id rcv_shipment_headers.shipment_header_id%type;

1396: X_receipt_num rcv_shipment_headers.receipt_num%type;
1397: X_created_by rcv_shipment_headers.created_by%type;
1398: X_last_update_login rcv_shipment_headers.last_update_login%type;
1399: X_count number := 0;
1400: X_shipment_header_id rcv_shipment_headers.shipment_header_id%type;
1401: X_employee_id rcv_shipment_headers.employee_id%type := 0;
1402: X_request_id rcv_shipment_headers.request_id%type := 0;
1403:
1404: X_pgm_app_id rcv_shipment_headers.program_application_id%type := 0;

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

1397: X_created_by rcv_shipment_headers.created_by%type;
1398: X_last_update_login rcv_shipment_headers.last_update_login%type;
1399: X_count number := 0;
1400: X_shipment_header_id rcv_shipment_headers.shipment_header_id%type;
1401: X_employee_id rcv_shipment_headers.employee_id%type := 0;
1402: X_request_id rcv_shipment_headers.request_id%type := 0;
1403:
1404: X_pgm_app_id rcv_shipment_headers.program_application_id%type := 0;
1405: X_pgm_id rcv_shipment_headers.program_id%type := 0;

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

1398: X_last_update_login rcv_shipment_headers.last_update_login%type;
1399: X_count number := 0;
1400: X_shipment_header_id rcv_shipment_headers.shipment_header_id%type;
1401: X_employee_id rcv_shipment_headers.employee_id%type := 0;
1402: X_request_id rcv_shipment_headers.request_id%type := 0;
1403:
1404: X_pgm_app_id rcv_shipment_headers.program_application_id%type := 0;
1405: X_pgm_id rcv_shipment_headers.program_id%type := 0;
1406: l_err_message varchar2(240) := null;

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

1400: X_shipment_header_id rcv_shipment_headers.shipment_header_id%type;
1401: X_employee_id rcv_shipment_headers.employee_id%type := 0;
1402: X_request_id rcv_shipment_headers.request_id%type := 0;
1403:
1404: X_pgm_app_id rcv_shipment_headers.program_application_id%type := 0;
1405: X_pgm_id rcv_shipment_headers.program_id%type := 0;
1406: l_err_message varchar2(240) := null;
1407: x_rcpt_count NUMBER := 1;
1408: x_organization_name VARCHAR2(60);

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

1401: X_employee_id rcv_shipment_headers.employee_id%type := 0;
1402: X_request_id rcv_shipment_headers.request_id%type := 0;
1403:
1404: X_pgm_app_id rcv_shipment_headers.program_application_id%type := 0;
1405: X_pgm_id rcv_shipment_headers.program_id%type := 0;
1406: l_err_message varchar2(240) := null;
1407: x_rcpt_count NUMBER := 1;
1408: x_organization_name VARCHAR2(60);
1409: x_supplier_name PO_VENDORS.VENDOR_NAME%TYPE;

Line 1457: FROM rcv_shipment_headers

1453: LOOP
1454:
1455: SELECT count(*)
1456: INTO X_count
1457: FROM rcv_shipment_headers
1458: WHERE receipt_num = X_receipt_num and
1459: ship_to_org_id = X_to_org_id;
1460:
1461: IF (X_count = 0) THEN

Line 1475: SELECT rcv_shipment_headers_s.nextval

1471: END LOOP;
1472:
1473: /* Get the shipment Header id */
1474:
1475: SELECT rcv_shipment_headers_s.nextval
1476: INTO X_shipment_header_id
1477: FROM sys.dual;
1478:
1479:

Line 1483: INSERT INTO RCV_SHIPMENT_HEADERS (

1479:
1480: /* For every unique Org_id, Vendor_id combination,
1481: ** create a header */
1482:
1483: INSERT INTO RCV_SHIPMENT_HEADERS (
1484: SHIPMENT_HEADER_ID,
1485: LAST_UPDATE_DATE,
1486: LAST_UPDATED_BY,
1487: CREATION_DATE,

Line 1560: update rcv_shipment_headers

1556: X_vendor_site_id := null;
1557: END;
1558:
1559: if(X_vendor_site_id is not null) then
1560: update rcv_shipment_headers
1561: set vendor_site_id = X_vendor_site_id
1562: where shipment_header_id = x_shipment_header_id;
1563: end if;
1564:

Line 1583: from rcv_shipment_headers

1579:
1580: begin
1581: select receipt_num
1582: into X_receipt_num
1583: from rcv_shipment_headers
1584: where shipment_header_id = X_shipment_header_id and
1585: receipt_num is not null;
1586: exception
1587: when no_data_found then

Line 1599: FROM rcv_shipment_headers

1595: LOOP
1596:
1597: SELECT count(*)
1598: INTO X_count
1599: FROM rcv_shipment_headers
1600: WHERE receipt_num = X_receipt_num and
1601: ship_to_org_id = X_to_org_id;
1602:
1603: IF (X_count = 0) THEN

Line 1615: update rcv_shipment_headers

1611: END IF;
1612:
1613: END LOOP;
1614:
1615: update rcv_shipment_headers
1616: set receipt_num=X_receipt_num
1617: where shipment_header_id = X_shipment_header_id;
1618:
1619: end; -- no receipt number

Line 1636: end create_rcv_shipment_headers;

1632: APP_EXCEPTION.RAISE_EXCEPTION;
1633: end if;
1634: return FALSE;
1635:
1636: end create_rcv_shipment_headers;
1637:
1638:
1639: /*************************************************************
1640: ** Function : Call_Txn_Processor