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.RCV_QUANTITIES_S dependencies on RCV_TRANSACTIONS_INTERFACE

Line 780: FROM rcv_transactions_interface rti

776: SELECT nvl(sum(decode(nvl(order_transaction_id,-999),-999,primary_quantity,nvl(interface_transaction_qty,0))),0),
777: decode(min(item_id),null,min(unit_of_measure),min(primary_unit_of_measure))
778: INTO x_interface_quantity,
779: x_primary_uom
780: FROM rcv_transactions_interface rti
781: WHERE (transaction_status_code = 'PENDING'
782: and processing_status_code <> 'ERROR')
783: AND transaction_type IN ('RECEIVE', 'MATCH','CORRECT','SHIP') -- bug 657347 should include 'SHIP'
784: -- when calculating total quantity

Line 796: FROM rcv_transactions_interface

792: SELECT nvl(sum(primary_quantity),0),
793: decode(min(item_id),null,min(unit_of_measure),min(primary_unit_of_measure))
794: INTO x_interface_quantity,
795: x_primary_uom
796: FROM rcv_transactions_interface
797: WHERE (transaction_status_code = 'PENDING'
798: and processing_status_code <> 'ERROR')
799: */
800: /*

Line 841: FROM rcv_transactions_interface

837: SELECT nvl(sum(secondary_quantity),0),
838: min(secondary_unit_of_measure)
839: INTO x_secondary_interface_qty,
840: x_secondary_uom
841: FROM rcv_transactions_interface
842: WHERE (transaction_status_code = 'PENDING'
843: and processing_status_code <> 'ERROR')
844: AND transaction_type IN ('RECEIVE', 'MATCH','CORRECT','SHIP')
845: AND po_line_location_id = p_line_location_id;

Line 1064: FROM rcv_transactions_interface

1060: x_progress := '010';
1061:
1062: SELECT nvl(sum(decode(nvl(order_transaction_id,-999),-999,amount,nvl(interface_transaction_amt,0))),0)
1063: INTO x_interface_amount
1064: FROM rcv_transactions_interface
1065: WHERE (transaction_status_code = 'PENDING'
1066: and processing_status_code <> 'ERROR')
1067: AND transaction_type IN ('RECEIVE', 'MATCH','CORRECT')
1068: AND po_line_location_id = p_line_location_id;

Line 1229: FROM rcv_transactions_interface

1225: SELECT NVL(quantity, interface_transaction_qty) quantity,
1226: unit_of_measure,
1227: secondary_quantity,
1228: secondary_unit_of_measure
1229: FROM rcv_transactions_interface
1230: WHERE ( transaction_status_code = 'PENDING'
1231: AND processing_status_code <> 'ERROR')
1232: AND transaction_type IN('RECEIVE', 'MATCH', 'CORRECT', 'SHIP')
1233: AND oe_order_line_id = p_oe_order_line_id;

Line 1403: FROM rcv_transactions_interface

1399: SELECT nvl(sum(decode(nvl(order_transaction_id,-999),-999,primary_quantity,nvl(interface_transaction_qty,0))),0),
1400: min(primary_unit_of_measure)
1401: INTO x_interface_quantity,
1402: x_primary_uom
1403: FROM rcv_transactions_interface
1404: WHERE (transaction_status_code = 'PENDING'
1405: and processing_status_code <> 'ERROR')
1406: AND transaction_type = 'RECEIVE'
1407: AND shipment_line_id = p_shipment_line_id;

Line 1463: FROM rcv_transactions_interface

1459: SELECT nvl(sum(secondary_quantity),0),
1460: min(secondary_unit_of_measure)
1461: INTO x_secondary_interface_qty,
1462: x_secondary_uom
1463: FROM rcv_transactions_interface
1464: WHERE (transaction_status_code = 'PENDING'
1465: and processing_status_code <> 'ERROR')
1466: AND transaction_type = 'RECEIVE'
1467: AND shipment_line_id = p_shipment_line_id;

Line 1646: FROM rcv_transactions_interface

1642:
1643:
1644: INTO x_interface_quantity,
1645: x_secondary_interface_qty
1646: FROM rcv_transactions_interface
1647: WHERE (transaction_status_code = 'PENDING'
1648: and processing_status_code <> 'ERROR')
1649: AND parent_transaction_id = p_transaction_id;
1650:

Line 1709: FROM rcv_transactions_interface

1705: secondary_quantity)),0),
1706: min(secondary_unit_of_measure)
1707: INTO x_secondary_interface_qty,
1708: x_secondary_uom
1709: FROM rcv_transactions_interface
1710: WHERE (transaction_status_code = 'PENDING'
1711: and processing_status_code <> 'ERROR')
1712: AND parent_transaction_id = p_transaction_id; */
1713:

Line 1816: FROM rcv_transactions_interface

1812: 'CORRECT', -1 * (decode(nvl(order_transaction_id,-999),-999,amount,nvl(interface_transaction_amt,0))),
1813: decode(nvl(order_transaction_id,-999),-999,amount,nvl(interface_transaction_amt,0))
1814: )),0)
1815: INTO x_interface_amount
1816: FROM rcv_transactions_interface
1817: WHERE (transaction_status_code = 'PENDING'
1818: and processing_status_code <> 'ERROR')
1819: AND parent_transaction_id = p_transaction_id;
1820:

Line 1831: FROM rcv_transactions_interface

1827: 'CORRECT', -1 * (decode(nvl(order_transaction_id,-999),-999,amount,nvl(interface_transaction_amt,0))),
1828: decode(nvl(order_transaction_id,-999),-999,amount,nvl(interface_transaction_amt,0))
1829: )),0)
1830: INTO x_interface_deliver_amount
1831: FROM rcv_transactions_interface
1832: WHERE (transaction_status_code = 'PENDING'
1833: and processing_status_code <> 'ERROR')
1834: AND parent_transaction_id = l_deliver_id;
1835:

Line 2625: FROM rcv_transactions_interface

2621: )),0),
2622: min(primary_unit_of_measure)
2623: INTO x_interface_quantity,
2624: x_primary_uom
2625: FROM rcv_transactions_interface
2626: WHERE (transaction_status_code = 'PENDING'
2627: and processing_status_code <> 'ERROR')
2628: AND parent_transaction_id = p_transaction_id;
2629:

Line 2638: FROM rcv_transactions_interface rti

2634:
2635: -- rtv project : start
2636: SELECT nvl( sum(primary_quantity),0)
2637: INTO x_rtv_running_qty
2638: FROM rcv_transactions_interface rti
2639: WHERE parent_transaction_id = p_transaction_id
2640: AND processing_status_code = 'RUNNING'
2641: AND transaction_type IN ('RETURN TO VENDOR', 'RETURN TO RECEIVING')
2642: AND exists ( select 1 from wsh_delivery_details wdd

Line 2682: FROM rcv_transactions_interface

2678: SELECT nvl(sum(decode(transaction_type,
2679: 'CORRECT', -1 * secondary_quantity,
2680: secondary_quantity)),0)
2681: INTO x_secondary_interface_qty
2682: FROM rcv_transactions_interface
2683: WHERE (transaction_status_code = 'PENDING'
2684: and processing_status_code <> 'ERROR')
2685: AND parent_transaction_id = p_transaction_id;
2686:

Line 2694: FROM rcv_transactions_interface rti

2690:
2691: -- rtv project : start
2692: SELECT nvl(sum(secondary_quantity),0)
2693: INTO x_rtv_running_sec_qty
2694: FROM rcv_transactions_interface rti
2695: WHERE parent_transaction_id = p_transaction_id
2696: AND processing_status_code = 'RUNNING'
2697: AND transaction_type IN ('RETURN TO VENDOR', 'RETURN TO RECEIVING')
2698: AND exists ( select 1 from wsh_delivery_details wdd

Line 2852: from rcv_transactions_interface

2848: select FROM_SUBINVENTORY,
2849: FROM_LOCATOR_ID
2850: into l_subinventory,
2851: l_locator_id
2852: from rcv_transactions_interface
2853: where interface_transaction_id = p_interface_transaction_id;
2854: END IF;
2855:
2856: /* Call inventory API to get quantity available in consigned inventory.

Line 3017: FROM rcv_transactions_interface

3013: 'CORRECT', -1 * (decode(nvl(order_transaction_id,-999),-999,amount,nvl(interface_transaction_amt,0))),
3014: decode(nvl(order_transaction_id,-999),-999,amount,nvl(interface_transaction_amt,0))
3015: )),0)
3016: INTO x_interface_amount
3017: FROM rcv_transactions_interface
3018: WHERE (transaction_status_code = 'PENDING'
3019: and processing_status_code <> 'ERROR')
3020: AND parent_transaction_id = p_transaction_id;
3021:

Line 3293: FROM rcv_transactions_interface

3289: )),0),
3290: decode(min(item_id),null,min(unit_of_measure),min(primary_unit_of_measure))
3291: INTO x_interface_quantity,
3292: x_primary_uom
3293: FROM rcv_transactions_interface
3294: WHERE (transaction_status_code = 'PENDING'
3295: and processing_status_code <> 'ERROR')
3296: AND po_distribution_id = p_po_distribution_id;
3297: */

Line 3308: FROM rcv_transactions_interface

3304: ,decode(min(primary_unit_of_measure),null,min(unit_of_measure),min(primary_unit_of_measure))
3305: ,min(primary_unit_of_measure))
3306: INTO x_interface_quantity,
3307: x_primary_uom
3308: FROM rcv_transactions_interface
3309: WHERE (transaction_status_code = 'PENDING'
3310: and processing_status_code <> 'ERROR')
3311: AND po_distribution_id = p_po_distribution_id
3312: AND NOT EXISTS (SELECT 1 FROM rcv_transactions rt

Line 3314: AND rt.transaction_id = rcv_transactions_interface.parent_transaction_id)

3310: and processing_status_code <> 'ERROR')
3311: AND po_distribution_id = p_po_distribution_id
3312: AND NOT EXISTS (SELECT 1 FROM rcv_transactions rt
3313: WHERE rt.transaction_type = 'DELIVER'
3314: AND rt.transaction_id = rcv_transactions_interface.parent_transaction_id)
3315: AND transaction_type NOT IN ('DELIVER','RETURN TO RECEIVING');
3316:
3317: /* End Bug 10384588 */
3318:

Line 3552: FROM rcv_transactions_interface

3548: 'CORRECT', -1 * (decode(nvl(order_transaction_id,-999),-999,amount,nvl(interface_transaction_amt,0))),
3549: decode(nvl(order_transaction_id,-999),-999,amount,nvl(interface_transaction_amt,0))
3550: )),0)
3551: INTO x_interface_amount
3552: FROM rcv_transactions_interface
3553: WHERE (transaction_status_code = 'PENDING'
3554: and processing_status_code <> 'ERROR')
3555: AND po_distribution_id = p_po_distribution_id;
3556:

Line 3766: FROM rcv_transactions_interface

3762: min(item_id) -- Bug 11833312
3763: INTO x_interface_quantity,
3764: x_primary_uom,
3765: x_item_id
3766: FROM rcv_transactions_interface
3767: WHERE (transaction_status_code = 'PENDING'
3768: and processing_status_code <> 'ERROR')
3769: AND parent_transaction_id = p_transaction_id
3770: AND po_distribution_id = p_po_distribution_id;

Line 3955: FROM RCV_TRANSACTIONS_INTERFACE

3951: SELECT nvl(sum(decode(nvl(order_transaction_id,-999),-999,primary_quantity,nvl(interface_transaction_qty,0))),0),
3952: MIN(PRIMARY_UNIT_OF_MEASURE)
3953: INTO x_interface_quantity,
3954: x_primary_uom
3955: FROM RCV_TRANSACTIONS_INTERFACE
3956: WHERE (TRANSACTION_STATUS_CODE = 'PENDING'
3957: and processing_status_code <> 'ERROR') AND
3958: TRANSACTION_TYPE IN ('RECEIVE','MATCH','CORRECT') AND
3959: PO_LINE_LOCATION_ID = p_line_location_id;

Line 4031: FROM rcv_transactions_interface

4027: SELECT nvl(sum(decode(nvl(order_transaction_id,-999),-999,primary_quantity,nvl(interface_transaction_qty,0))),0),
4028: min(primary_unit_of_measure)
4029: INTO x_interface_quantity,
4030: x_primary_uom
4031: FROM rcv_transactions_interface
4032: WHERE (transaction_status_code = 'PENDING'
4033: and processing_status_code <> 'ERROR')
4034: AND transaction_type = 'RECEIVE'
4035: AND shipment_line_id = p_shipment_line_id

Line 4240: FROM rcv_transactions_interface

4236: min(item_id) -- Bug 12336493
4237: INTO l_interface_quantity,
4238: l_primary_uom,
4239: l_item_id
4240: FROM rcv_transactions_interface
4241: WHERE (transaction_status_code = 'PENDING'
4242: AND processing_status_code <> 'ERROR')
4243: AND transaction_type = 'RECEIVE'
4244: AND shipment_line_id = p_shipment_line_id