DBA Data[Home] [Help]

APPS.RCV_QUANTITIES_S dependencies on RCV_SUPPLY

Line 1547: Bug#5369121 - Fetching the primary uom from rcv_supply or rcv_transactions

1543:
1544: BEGIN
1545:
1546: /*
1547: Bug#5369121 - Fetching the primary uom from rcv_supply or rcv_transactions
1548: rather than RTI since it could be null in RTI
1549: */
1550:
1551: SELECT quantity,

Line 1552: secondary_quantity, /*Bug#9159988 selecting the secondary quantity from rcv_supply*/

1548: rather than RTI since it could be null in RTI
1549: */
1550:
1551: SELECT quantity,
1552: secondary_quantity, /*Bug#9159988 selecting the secondary quantity from rcv_supply*/
1553: unit_of_measure,
1554: item_id,
1555: to_org_primary_uom
1556: INTO x_transaction_quantity,

Line 1561: FROM rcv_supply

1557: x_secondary_transaction_qty,
1558: x_transaction_uom,
1559: x_item_id,
1560: x_primary_uom
1561: FROM rcv_supply
1562: WHERE supply_type_code = 'RECEIVING'
1563: AND supply_source_id = p_transaction_id;
1564:
1565: /* Bug# 1548597 */

Line 1930: ** All of the above transactions supply is stored in RCV_SUPPLY.

1926: IF (p_parent_transaction_type IN ('UNORDERED', 'RECEIVE', 'MATCH',
1927: 'TRANSFER', 'ACCEPT', 'REJECT')) THEN
1928:
1929: /*
1930: ** All of the above transactions supply is stored in RCV_SUPPLY.
1931: ** Use get_transaction_quantity logic to get the available quantity
1932: ** and uom.
1933: */
1934:

Line 2279: ** All of the above transactions supply is stored in RCV_SUPPLY.

2275:
2276: IF p_parent_transaction_type = 'RECEIVE' THEN
2277:
2278: /*
2279: ** All of the above transactions supply is stored in RCV_SUPPLY.
2280: ** Use get_transaction_quantity logic to get the available quantity
2281: ** and uom.
2282: */
2283: