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.POS_WC_CREATE_UPDATE_PVT dependencies on RCV_TRANSACTIONS

Line 76: RCV_TRANSACTIONS_INTERFACE RTI

72: l_draft_exists := 'N';
73:
74: SELECT 'Y' INTO l_draft_exists
75: FROM RCV_HEADERS_INTERFACE RHI,
76: RCV_TRANSACTIONS_INTERFACE RTI
77: WHERE RHI.HEADER_INTERFACE_ID = RTI.HEADER_INTERFACE_ID AND
78: RTI.PO_HEADER_ID = p_po_header_id AND
79: RHI.processing_status_code = 'DRAFT' AND
80: RHI.transaction_type = 'DRAFT' AND

Line 314: FROM RCV_TRANSACTIONS_INTERFACE RTI,

310: IF(p_wc_stage = 'INTERFACE') THEN
311:
312: SELECT SUM(NVL(RTI.AMOUNT, Round(RTI.QUANTITY*POLL.PRICE_OVERRIDE,POS_WC_VIEW_CANCEL_PVT.get_currency_precision(poll.po_header_id))))
313: INTO l_intf_request
314: FROM RCV_TRANSACTIONS_INTERFACE RTI,
315: RCV_HEADERS_INTERFACE RHI,
316: PO_LINE_LOCATIONS_ALL POLL
317: WHERE RHI.HEADER_INTERFACE_ID = RTI.HEADER_INTERFACE_ID and
318: RTI.PO_LINE_LOCATION_ID = POLL.LINE_LOCATION_ID AND

Line 359: -- SHIPMENT_LINE_ID in the table RCV_TRANSACTIONS_INTERFACE-- or RCV_SHIPMENT_LINES respectively, depending on the

355: --Function : Retrieve the progress on a pay item
356: --Parameter :
357: --IN : p_wc_pay_item_id IN NUMBER Required
358: -- corresponds to the column TRANSACTION_INTERFACE_ID or
359: -- SHIPMENT_LINE_ID in the table RCV_TRANSACTIONS_INTERFACE-- or RCV_SHIPMENT_LINES respectively, depending on the
360: -- p_wc_stage variable. The API is only implemented for
361: -- pay items in 'SHIPMENT' stage at the moment.
362: -- p_wc_stage IN VARCHAR2 Required
363: -- 'INTERFACE' or 'SHIPMENT. Indicates the pay item stage

Line 491: RCV_TRANSACTIONS_INTERFACE RTI

487:
488: SELECT RHI.request_date, RHI.processing_status_code, RHI.transaction_type
489: INTO l_request_date, l_header_processing_status, l_header_transaction_type
490: FROM RCV_HEADERS_INTERFACE RHI,
491: RCV_TRANSACTIONS_INTERFACE RTI
492: WHERE RHI.HEADER_INTERFACE_ID = RTI.HEADER_INTERFACE_ID AND
493: RTI.INTERFACE_TRANSACTION_ID = p_wc_pay_item_id;
494:
495: IF(l_header_processing_status = 'DRAFT' and

Line 527: RCV_TRANSACTIONS_INTERFACE RTI,

523: BEGIN
524: SELECT sum(NVL(RTI.AMOUNT,RTI.QUANTITY))
525: INTO l_wc_prev_submitted_intf
526: FROM PO_LINE_LOCATIONS_ALL POLL,
527: RCV_TRANSACTIONS_INTERFACE RTI,
528: RCV_HEADERS_INTERFACE RHI
529: WHERE RHI.HEADER_INTERFACE_ID = RTI.HEADER_INTERFACE_ID AND
530: RTI.PO_LINE_LOCATION_ID = POLL.LINE_LOCATION_ID AND
531: RTI.PROCESSING_STATUS_CODE = 'PENDING' AND

Line 1007: from rcv_transactions

1003: /* l_transacted_amount = amount which was transacted earlier than the submission of
1004: current work confirmation for this payitem / distribution */
1005: select nvl(sum(amount),0)
1006: into l_transacted_amount
1007: from rcv_transactions
1008: where po_distribution_id= wcr_line_info.po_distribution_id
1009: and destination_type_code = 'RECEIVING';
1010:
1011: /* l_interface_amount = amount which is in the interface tables /pending to be approved / rejected before the submission of

Line 1015: from rcv_transactions_interface

1011: /* l_interface_amount = amount which is in the interface tables /pending to be approved / rejected before the submission of
1012: current work confirmation for this payitem / distribution */
1013: select nvl(sum(amount),0)
1014: into l_interface_amount
1015: from rcv_transactions_interface
1016: where po_distribution_id= wcr_line_info.po_distribution_id
1017: and processing_status_code='PENDING'
1018: and transaction_status_code = 'PENDING'
1019: and transaction_type = 'RECEIVE';

Line 1115: from rcv_transactions

1111: /* l_transacted_quantity = quantity which was transacted earlier than the submission of
1112: current work confirmation for this payitem / distribution */
1113: select nvl(sum(quantity),0)
1114: into l_transacted_quantity
1115: from rcv_transactions
1116: where po_distribution_id= wcr_line_info.po_distribution_id
1117: and destination_type_code = 'RECEIVING';
1118:
1119: /* l_interface_quantity = quantity which is in the interface tables /pending to be approved / rejected before the submission of

Line 1123: from rcv_transactions_interface

1119: /* l_interface_quantity = quantity which is in the interface tables /pending to be approved / rejected before the submission of
1120: current work confirmation for this payitem / distribution */
1121: select nvl(sum(quantity),0)
1122: into l_interface_quantity
1123: from rcv_transactions_interface
1124: where po_distribution_id= wcr_line_info.po_distribution_id
1125: and processing_status_code='PENDING'
1126: and transaction_status_code = 'PENDING'
1127: and transaction_type = 'RECEIVE';

Line 1188: select rcv_transactions_interface_s.nextval

1184: If (l_insert_into_rti) then --{
1185:
1186: FOR i IN 1..2 LOOP
1187:
1188: select rcv_transactions_interface_s.nextval
1189: into l_interface_id
1190: from dual;
1191:
1192: IF (i = 1) THEN

Line 1206: from rcv_transactions

1202: END IF;
1203:
1204: select transaction_id
1205: INTO l_parent_transaction_id
1206: from rcv_transactions
1207: where shipment_header_id = l_shipment_header_id
1208: AND po_line_location_id = l_line_location_id
1209: AND transaction_type = l_transaction_type
1210: AND po_distribution_id = wcr_line_info.po_distribution_id;

Line 1621: FROM rcv_transactions rt

1617: l_correction_history_tab correction_history_tab := correction_history_tab();
1618:
1619: CURSOR c1 IS
1620: SELECT DISTINCT po_line_location_id
1621: FROM rcv_transactions rt
1622: WHERE shipment_header_id = l_shipment_header_id
1623: AND transaction_type = 'CORRECT'
1624: ORDER BY po_line_location_id;
1625:

Line 1628: FROM rcv_transactions rt

1624: ORDER BY po_line_location_id;
1625:
1626: CURSOR c2(l_line_location_id NUMBER) IS
1627: SELECT distinct group_id
1628: FROM rcv_transactions rt
1629: WHERE shipment_header_id = l_shipment_header_id
1630: AND transaction_type = 'CORRECT'
1631: AND EXISTS (SELECT '1'
1632: FROM rcv_transactions rt2

Line 1632: FROM rcv_transactions rt2

1628: FROM rcv_transactions rt
1629: WHERE shipment_header_id = l_shipment_header_id
1630: AND transaction_type = 'CORRECT'
1631: AND EXISTS (SELECT '1'
1632: FROM rcv_transactions rt2
1633: WHERE rt2.transaction_type = 'DELIVER'
1634: AND rt2.transaction_id = rt.parent_transaction_id)
1635: AND po_line_location_id = l_line_location_id
1636: ORDER BY group_id ASC;

Line 1669: FROM rcv_transactions rt

1665: l_old_requestedAmount1,
1666: l_old_matstoredamount1,
1667: l_po_header_id,
1668: l_po_line_location_id
1669: FROM rcv_transactions rt
1670: WHERE shipment_header_id = l_shipment_header_id
1671: AND po_line_location_id = l_line_location_id
1672: AND transaction_type = 'DELIVER'
1673: GROUP BY po_header_id,

Line 1732: FROM rcv_transactions rt,

1728: l_line_num,
1729: l_description,
1730: l_matching_basis,
1731: l_shipment_num
1732: FROM rcv_transactions rt,
1733: po_lines_all pl,
1734: po_line_locations_all pll
1735: WHERE rt.shipment_header_id = l_shipment_header_id
1736: AND rt.transaction_type = 'CORRECT'

Line 1738: FROM rcv_transactions rt2

1734: po_line_locations_all pll
1735: WHERE rt.shipment_header_id = l_shipment_header_id
1736: AND rt.transaction_type = 'CORRECT'
1737: AND EXISTS (SELECT '1'
1738: FROM rcv_transactions rt2
1739: WHERE rt2.transaction_type = 'DELIVER'
1740: AND rt2.transaction_id = rt.parent_transaction_id
1741: )
1742: AND rt.po_line_location_id = l_line_location_id