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.INV_RCV_STD_DELIVER_APIS dependencies on RCV_LOTS_SUPPLY

Line 2223: * be stored in rcv_lots_supply. We must match the lot number passed with that

2219: g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).inspection_status_code := p_inspection_status_code;
2220:
2221: /* FP-J Lot/Serial Support Enhancement
2222: * If INV and PO J are installed, then the lots for the parent transaction will
2223: * be stored in rcv_lots_supply. We must match the lot number passed with that
2224: * of the parent transaction and also the parent_txn_id
2225: */
2226: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
2227: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN

Line 2955: * be stored in rcv_lots_supply. We must match the lot number passed with that

2951: g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).inspection_status_code := p_inspection_status_code;
2952:
2953: /* FP-J Lot/Serial Support Enhancement
2954: * If INV and PO J are installed, then the lots for the parent transaction will
2955: * be stored in rcv_lots_supply. We must match the lot number passed with that
2956: * of the parent transaction and also the parent_txn_id
2957: */
2958: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
2959: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN

Line 3622: * be stored in rcv_lots_supply. We must match the lot number passed with that

3618: g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).inspection_status_code := p_inspection_status_code;
3619:
3620: /* FP-J Lot/Serial Support Enhancement
3621: * If INV and PO J are installed, then the lots for the parent transaction will
3622: * be stored in rcv_lots_supply. We must match the lot number passed with that
3623: * of the parent transaction and also the parent_txn_id
3624: */
3625: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
3626: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN

Line 5530: rcv_lots_supply rls,

5526: ,rsl.asn_line_flag asn_line_flag
5527: FROM rcv_supply rs,
5528: rcv_transactions rt,
5529: rcv_shipment_lines rsl,
5530: rcv_lots_supply rls,
5531: rcv_shipment_headers rsh
5532: WHERE rs.item_id = p_item_id
5533: --Bug 5250046: Removed the nvl and Modified the condition on item_revision.
5534: AND (p_revision is null or rs.item_revision = p_revision)