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 754: FROM rcv_transactions_interface

750: SELECT nvl(sum(decode(nvl(order_transaction_id,-999),-999,primary_quantity,nvl(interface_transaction_qty,0))),0),
751: decode(min(item_id),null,min(unit_of_measure),min(primary_unit_of_measure))
752: INTO x_interface_quantity,
753: x_primary_uom
754: FROM rcv_transactions_interface
755: WHERE (transaction_status_code = 'PENDING'
756: and processing_status_code <> 'ERROR')
757: AND transaction_type IN ('RECEIVE', 'MATCH','CORRECT','SHIP') -- bug 657347 should include 'SHIP'
758: -- when calculating total quantity

Line 766: FROM rcv_transactions_interface

762: SELECT nvl(sum(primary_quantity),0),
763: decode(min(item_id),null,min(unit_of_measure),min(primary_unit_of_measure))
764: INTO x_interface_quantity,
765: x_primary_uom
766: FROM rcv_transactions_interface
767: WHERE (transaction_status_code = 'PENDING'
768: and processing_status_code <> 'ERROR')
769: */
770: /*

Line 811: FROM rcv_transactions_interface

807: SELECT nvl(sum(secondary_quantity),0),
808: min(secondary_unit_of_measure)
809: INTO x_secondary_interface_qty,
810: x_secondary_uom
811: FROM rcv_transactions_interface
812: WHERE (transaction_status_code = 'PENDING'
813: and processing_status_code <> 'ERROR')
814: AND transaction_type IN ('RECEIVE', 'MATCH','CORRECT','SHIP')
815: AND po_line_location_id = p_line_location_id;

Line 931: FROM rcv_transactions_interface

927: x_progress := '010';
928:
929: SELECT nvl(sum(decode(nvl(order_transaction_id,-999),-999,amount,nvl(interface_transaction_amt,0))),0)
930: INTO x_interface_amount
931: FROM rcv_transactions_interface
932: WHERE (transaction_status_code = 'PENDING'
933: and processing_status_code <> 'ERROR')
934: AND transaction_type IN ('RECEIVE', 'MATCH','CORRECT')
935: AND po_line_location_id = p_line_location_id;

Line 1017: FROM rcv_transactions_interface

1013: SELECT NVL(quantity, interface_transaction_qty) quantity,
1014: unit_of_measure,
1015: secondary_quantity,
1016: secondary_unit_of_measure
1017: FROM rcv_transactions_interface
1018: WHERE ( transaction_status_code = 'PENDING'
1019: AND processing_status_code <> 'ERROR')
1020: AND transaction_type IN('RECEIVE', 'MATCH', 'CORRECT', 'SHIP')
1021: AND oe_order_line_id = p_oe_order_line_id;

Line 1191: FROM rcv_transactions_interface

1187: SELECT nvl(sum(decode(nvl(order_transaction_id,-999),-999,primary_quantity,nvl(interface_transaction_qty,0))),0),
1188: min(primary_unit_of_measure)
1189: INTO x_interface_quantity,
1190: x_primary_uom
1191: FROM rcv_transactions_interface
1192: WHERE (transaction_status_code = 'PENDING'
1193: and processing_status_code <> 'ERROR')
1194: AND transaction_type = 'RECEIVE'
1195: AND shipment_line_id = p_shipment_line_id;

Line 1251: FROM rcv_transactions_interface

1247: SELECT nvl(sum(secondary_quantity),0),
1248: min(secondary_unit_of_measure)
1249: INTO x_secondary_interface_qty,
1250: x_secondary_uom
1251: FROM rcv_transactions_interface
1252: WHERE (transaction_status_code = 'PENDING'
1253: and processing_status_code <> 'ERROR')
1254: AND transaction_type = 'RECEIVE'
1255: AND shipment_line_id = p_shipment_line_id;

Line 1425: FROM rcv_transactions_interface

1421: 'CORRECT', -1 * (decode(nvl(order_transaction_id,-999),-999,primary_quantity,nvl(interface_transaction_qty,0))),
1422: decode(nvl(order_transaction_id,-999),-999,primary_quantity,nvl(interface_transaction_qty,0))
1423: )),0)
1424: INTO x_interface_quantity
1425: FROM rcv_transactions_interface
1426: WHERE (transaction_status_code = 'PENDING'
1427: and processing_status_code <> 'ERROR')
1428: AND parent_transaction_id = p_transaction_id;
1429:

Line 1488: FROM rcv_transactions_interface

1484: secondary_quantity)),0),
1485: min(secondary_unit_of_measure)
1486: INTO x_secondary_interface_qty,
1487: x_secondary_uom
1488: FROM rcv_transactions_interface
1489: WHERE (transaction_status_code = 'PENDING'
1490: and processing_status_code <> 'ERROR')
1491: AND parent_transaction_id = p_transaction_id;
1492:

Line 1595: FROM rcv_transactions_interface

1591: 'CORRECT', -1 * (decode(nvl(order_transaction_id,-999),-999,amount,nvl(interface_transaction_amt,0))),
1592: decode(nvl(order_transaction_id,-999),-999,amount,nvl(interface_transaction_amt,0))
1593: )),0)
1594: INTO x_interface_amount
1595: FROM rcv_transactions_interface
1596: WHERE (transaction_status_code = 'PENDING'
1597: and processing_status_code <> 'ERROR')
1598: AND parent_transaction_id = p_transaction_id;
1599:

Line 1610: FROM rcv_transactions_interface

1606: 'CORRECT', -1 * (decode(nvl(order_transaction_id,-999),-999,amount,nvl(interface_transaction_amt,0))),
1607: decode(nvl(order_transaction_id,-999),-999,amount,nvl(interface_transaction_amt,0))
1608: )),0)
1609: INTO x_interface_deliver_amount
1610: FROM rcv_transactions_interface
1611: WHERE (transaction_status_code = 'PENDING'
1612: and processing_status_code <> 'ERROR')
1613: AND parent_transaction_id = l_deliver_id;
1614:

Line 2171: FROM rcv_transactions_interface

2167: )),0),
2168: min(primary_unit_of_measure)
2169: INTO x_interface_quantity,
2170: x_primary_uom
2171: FROM rcv_transactions_interface
2172: WHERE (transaction_status_code = 'PENDING'
2173: and processing_status_code <> 'ERROR')
2174: AND parent_transaction_id = p_transaction_id;
2175:

Line 2203: FROM rcv_transactions_interface

2199: SELECT nvl(sum(decode(transaction_type,
2200: 'CORRECT', -1 * secondary_quantity,
2201: secondary_quantity)),0)
2202: INTO x_secondary_interface_qty
2203: FROM rcv_transactions_interface
2204: WHERE (transaction_status_code = 'PENDING'
2205: and processing_status_code <> 'ERROR')
2206: AND parent_transaction_id = p_transaction_id;
2207:

Line 2468: FROM rcv_transactions_interface

2464: 'CORRECT', -1 * (decode(nvl(order_transaction_id,-999),-999,amount,nvl(interface_transaction_amt,0))),
2465: decode(nvl(order_transaction_id,-999),-999,amount,nvl(interface_transaction_amt,0))
2466: )),0)
2467: INTO x_interface_amount
2468: FROM rcv_transactions_interface
2469: WHERE (transaction_status_code = 'PENDING'
2470: and processing_status_code <> 'ERROR')
2471: AND parent_transaction_id = p_transaction_id;
2472:

Line 2646: FROM rcv_transactions_interface

2642: )),0),
2643: decode(min(item_id),null,min(unit_of_measure),min(primary_unit_of_measure))
2644: INTO x_interface_quantity,
2645: x_primary_uom
2646: FROM rcv_transactions_interface
2647: WHERE (transaction_status_code = 'PENDING'
2648: and processing_status_code <> 'ERROR')
2649: AND po_distribution_id = p_po_distribution_id;
2650:

Line 2781: FROM rcv_transactions_interface

2777: 'CORRECT', -1 * (decode(nvl(order_transaction_id,-999),-999,amount,nvl(interface_transaction_amt,0))),
2778: decode(nvl(order_transaction_id,-999),-999,amount,nvl(interface_transaction_amt,0))
2779: )),0)
2780: INTO x_interface_amount
2781: FROM rcv_transactions_interface
2782: WHERE (transaction_status_code = 'PENDING'
2783: and processing_status_code <> 'ERROR')
2784: AND po_distribution_id = p_po_distribution_id;
2785:

Line 2882: FROM rcv_transactions_interface

2878: )),0),
2879: min(primary_unit_of_measure)
2880: INTO x_interface_quantity,
2881: x_primary_uom
2882: FROM rcv_transactions_interface
2883: WHERE (transaction_status_code = 'PENDING'
2884: and processing_status_code <> 'ERROR')
2885: AND parent_transaction_id = p_transaction_id
2886: AND po_distribution_id = p_po_distribution_id;

Line 3071: FROM RCV_TRANSACTIONS_INTERFACE

3067: SELECT nvl(sum(decode(nvl(order_transaction_id,-999),-999,primary_quantity,nvl(interface_transaction_qty,0))),0),
3068: MIN(PRIMARY_UNIT_OF_MEASURE)
3069: INTO x_interface_quantity,
3070: x_primary_uom
3071: FROM RCV_TRANSACTIONS_INTERFACE
3072: WHERE (TRANSACTION_STATUS_CODE = 'PENDING'
3073: and processing_status_code <> 'ERROR') AND
3074: TRANSACTION_TYPE IN ('RECEIVE','MATCH','CORRECT') AND
3075: PO_LINE_LOCATION_ID = p_line_location_id;

Line 3147: FROM rcv_transactions_interface

3143: SELECT nvl(sum(decode(nvl(order_transaction_id,-999),-999,primary_quantity,nvl(interface_transaction_qty,0))),0),
3144: min(primary_unit_of_measure)
3145: INTO x_interface_quantity,
3146: x_primary_uom
3147: FROM rcv_transactions_interface
3148: WHERE (transaction_status_code = 'PENDING'
3149: and processing_status_code <> 'ERROR')
3150: AND transaction_type = 'RECEIVE'
3151: AND shipment_line_id = p_shipment_line_id

Line 3388: FROM rcv_transactions_interface

3384: select nvl(sum( decode(nvl(order_transaction_id,-999),-999,primary_quantity,nvl(interface_transaction_qty,0))),0),
3385: min(primary_unit_of_measure)
3386: INTO l_interface_quantity,
3387: l_primary_uom
3388: FROM rcv_transactions_interface
3389: WHERE (transaction_status_code = 'PENDING'
3390: and processing_status_code <> 'ERROR')
3391: AND transaction_type = 'RECEIVE'
3392: AND shipment_line_id = p_shipment_line_id