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.

[Home] [Help]

APPS.RCV_QUANTITIES_S dependencies on RCV_TRANSACTIONS

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 1335: Bug#5369121 - Fetching the primary uom from rcv_supply or rcv_transactions

1331:
1332: BEGIN
1333:
1334: /*
1335: Bug#5369121 - Fetching the primary uom from rcv_supply or rcv_transactions
1336: rather than RTI since it could be null in RTI
1337: */
1338:
1339: SELECT quantity,

Line 1367: from rcv_transactions

1363: 'UNORDERED', Secondary_Quantity,
1364: 'MATCH',Secondary_Quantity,
1365: 'TRANSFER',Secondary_quantity,0))
1366: into x_secondary_transaction_qty
1367: from rcv_transactions
1368: start with transaction_id = p_transaction_id
1369: connect by parent_transaction_id = prior transaction_id;
1370: -- Bug# 1548597
1371:

Line 1385: FROM rcv_transactions rt,

1381: rt.primary_unit_of_measure
1382: INTO x_transaction_uom,
1383: x_item_id,
1384: x_primary_uom
1385: FROM rcv_transactions rt,
1386: rcv_shipment_lines rsl
1387: WHERE rsl.shipment_line_id = rt.shipment_line_id
1388: AND rt.transaction_id = p_transaction_id;
1389: -- bug 4873207

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 1546: from rcv_transactions

1542: BEGIN
1543:
1544: SELECT nvl(sum(amount),0)
1545: into l_receive_correct
1546: from rcv_transactions
1547: where parent_transaction_id = p_transaction_id
1548: and transaction_type = 'CORRECT';
1549:
1550: IF (g_asn_debug = 'Y') THEN

Line 1555: from rcv_transactions

1551: asn_debug.put_line('l_receive_correct '||l_receive_correct);
1552: end if;
1553: select transaction_id
1554: into l_deliver_id
1555: from rcv_transactions
1556: where parent_transaction_id= p_transaction_id
1557: and transaction_type='DELIVER';
1558:
1559: IF (g_asn_debug = 'Y') THEN

Line 1564: from rcv_transactions

1560: asn_debug.put_line('l_deliver_id '||l_deliver_id);
1561: end if;
1562: SELECT nvl(sum(amount),0)
1563: into l_deliver_correct
1564: from rcv_transactions
1565: where parent_transaction_id = l_deliver_id
1566: and transaction_type = 'CORRECT';
1567:
1568: IF (g_asn_debug = 'Y') THEN

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 1667: l_quantity_in_parent_uom RCV_TRANSACTIONS.quantity%TYPE; -- Bug 2737257

1663: x_trx_quantity NUMBER := 0;
1664: X_interface_quantity NUMBER := 0;
1665: invalid_parent_trx_type EXCEPTION;
1666: x_interface_qty_in_trx_uom NUMBER := 0;
1667: l_quantity_in_parent_uom RCV_TRANSACTIONS.quantity%TYPE; -- Bug 2737257
1668: BEGIN
1669:
1670: IF (g_asn_debug = 'Y') THEN
1671: asn_debug.put_line(' in get_correction_quantity');

Line 1820: from rcv_transactions rt,

1816: select rt.unit_of_measure,
1817: rsl.item_id
1818: into x_parent_uom,
1819: x_item_id
1820: from rcv_transactions rt,
1821: rcv_shipment_lines rsl
1822: where rt.transaction_id = p_parent_id
1823: and rt.shipment_line_id = rsl.shipment_line_id;
1824:

Line 2081: l_consigned_flag rcv_transactions.consigned_flag%TYPE;

2077: x_secondary_trx_quantity NUMBER := 0;
2078: -- end bug 1548597
2079:
2080: /* Bug 3735987 Start declarations*/
2081: l_consigned_flag rcv_transactions.consigned_flag%TYPE;
2082: l_org_id rcv_transactions.organization_id%TYPE;
2083: l_consigned_quantity NUMBER;
2084: l_opm_installed BOOLEAN;
2085: l_opm_process_org VARCHAR2(1);

Line 2082: l_org_id rcv_transactions.organization_id%TYPE;

2078: -- end bug 1548597
2079:
2080: /* Bug 3735987 Start declarations*/
2081: l_consigned_flag rcv_transactions.consigned_flag%TYPE;
2082: l_org_id rcv_transactions.organization_id%TYPE;
2083: l_consigned_quantity NUMBER;
2084: l_opm_installed BOOLEAN;
2085: l_opm_process_org VARCHAR2(1);
2086: l_vendor_site_id rcv_transactions.vendor_site_id%TYPE;

Line 2086: l_vendor_site_id rcv_transactions.vendor_site_id%TYPE;

2082: l_org_id rcv_transactions.organization_id%TYPE;
2083: l_consigned_quantity NUMBER;
2084: l_opm_installed BOOLEAN;
2085: l_opm_process_org VARCHAR2(1);
2086: l_vendor_site_id rcv_transactions.vendor_site_id%TYPE;
2087: l_subinventory rcv_transactions.subinventory%TYPE;
2088: l_locator_id rcv_transactions.locator_id%TYPE;
2089: l_po_header_id rcv_transactions.po_header_id%TYPE;
2090: l_po_line_id rcv_transactions.po_line_id%TYPE;

Line 2087: l_subinventory rcv_transactions.subinventory%TYPE;

2083: l_consigned_quantity NUMBER;
2084: l_opm_installed BOOLEAN;
2085: l_opm_process_org VARCHAR2(1);
2086: l_vendor_site_id rcv_transactions.vendor_site_id%TYPE;
2087: l_subinventory rcv_transactions.subinventory%TYPE;
2088: l_locator_id rcv_transactions.locator_id%TYPE;
2089: l_po_header_id rcv_transactions.po_header_id%TYPE;
2090: l_po_line_id rcv_transactions.po_line_id%TYPE;
2091: l_item_revision rcv_shipment_lines.item_revision%TYPE;

Line 2088: l_locator_id rcv_transactions.locator_id%TYPE;

2084: l_opm_installed BOOLEAN;
2085: l_opm_process_org VARCHAR2(1);
2086: l_vendor_site_id rcv_transactions.vendor_site_id%TYPE;
2087: l_subinventory rcv_transactions.subinventory%TYPE;
2088: l_locator_id rcv_transactions.locator_id%TYPE;
2089: l_po_header_id rcv_transactions.po_header_id%TYPE;
2090: l_po_line_id rcv_transactions.po_line_id%TYPE;
2091: l_item_revision rcv_shipment_lines.item_revision%TYPE;
2092: l_primary_rt_uom rcv_transactions.primary_unit_of_measure%TYPE;

Line 2089: l_po_header_id rcv_transactions.po_header_id%TYPE;

2085: l_opm_process_org VARCHAR2(1);
2086: l_vendor_site_id rcv_transactions.vendor_site_id%TYPE;
2087: l_subinventory rcv_transactions.subinventory%TYPE;
2088: l_locator_id rcv_transactions.locator_id%TYPE;
2089: l_po_header_id rcv_transactions.po_header_id%TYPE;
2090: l_po_line_id rcv_transactions.po_line_id%TYPE;
2091: l_item_revision rcv_shipment_lines.item_revision%TYPE;
2092: l_primary_rt_uom rcv_transactions.primary_unit_of_measure%TYPE;
2093:

Line 2090: l_po_line_id rcv_transactions.po_line_id%TYPE;

2086: l_vendor_site_id rcv_transactions.vendor_site_id%TYPE;
2087: l_subinventory rcv_transactions.subinventory%TYPE;
2088: l_locator_id rcv_transactions.locator_id%TYPE;
2089: l_po_header_id rcv_transactions.po_header_id%TYPE;
2090: l_po_line_id rcv_transactions.po_line_id%TYPE;
2091: l_item_revision rcv_shipment_lines.item_revision%TYPE;
2092: l_primary_rt_uom rcv_transactions.primary_unit_of_measure%TYPE;
2093:
2094: l_return_status VARCHAR2(1);

Line 2092: l_primary_rt_uom rcv_transactions.primary_unit_of_measure%TYPE;

2088: l_locator_id rcv_transactions.locator_id%TYPE;
2089: l_po_header_id rcv_transactions.po_header_id%TYPE;
2090: l_po_line_id rcv_transactions.po_line_id%TYPE;
2091: l_item_revision rcv_shipment_lines.item_revision%TYPE;
2092: l_primary_rt_uom rcv_transactions.primary_unit_of_measure%TYPE;
2093:
2094: l_return_status VARCHAR2(1);
2095: l_msg_count NUMBER;
2096: l_msg_data VARCHAR2(2000);

Line 2146: from rcv_transactions rt,

2142: l_po_header_id,
2143: l_po_line_id,
2144: l_item_revision,
2145: l_primary_rt_uom
2146: from rcv_transactions rt,
2147: rcv_shipment_lines rsl
2148: where rt.transaction_id = p_transaction_id
2149: and rt.shipment_line_id = rsl.shipment_line_id;
2150:

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 2242: FROM rcv_transactions

2238: primary_quantity)),0),
2239: min(primary_unit_of_measure)
2240: INTO x_trx_quantity,
2241: x_primary_uom
2242: FROM rcv_transactions
2243: WHERE parent_transaction_id = p_transaction_id
2244: AND transaction_type in ('CORRECT','RETURN TO RECEIVING');
2245:
2246: IF (x_primary_uom IS NOT NULL) THEN

Line 2257: FROM rcv_transactions

2253: SELECT nvl(sum(decode(transaction_type,
2254: 'CORRECT', -1 * secondary_quantity,
2255: secondary_quantity)),0)
2256: INTO x_secondary_trx_quantity
2257: FROM rcv_transactions
2258: WHERE parent_transaction_id = p_transaction_id
2259: AND transaction_type in ('CORRECT','RETURN TO RECEIVING');
2260: --end Bug# 1548597
2261:

Line 2450: from rcv_transactions rt

2446: */
2447:
2448: select rt.amount
2449: into x_deliver_amount
2450: from rcv_transactions rt
2451: where rt.transaction_id = p_transaction_id;
2452:
2453: IF (g_asn_debug = 'Y') THEN
2454: asn_debug.put_line('x_deliver_amount '||x_deliver_amount );

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 2498: FROM rcv_transactions

2494: */
2495:
2496: SELECT nvl(sum(amount),0)
2497: INTO x_transaction_amount
2498: FROM rcv_transactions
2499: WHERE parent_transaction_id = p_transaction_id
2500: AND transaction_type = 'CORRECT';
2501:
2502: IF (g_asn_debug = 'Y') THEN

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 3317: from rcv_transactions

3313: l_progress := '040';
3314:
3315: select sum(nvl(quantity,0))
3316: into l_quantity_returned
3317: from rcv_transactions
3318: where shipment_line_id = p_shipment_line_id and
3319: transaction_type = 'RETURN TO VENDOR';
3320:
3321:

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