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 2189: * be stored in rcv_lots_supply. We must match the lot number passed with that

2185: g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).inspection_status_code := p_inspection_status_code;
2186:
2187: /* FP-J Lot/Serial Support Enhancement
2188: * If INV and PO J are installed, then the lots for the parent transaction will
2189: * be stored in rcv_lots_supply. We must match the lot number passed with that
2190: * of the parent transaction and also the parent_txn_id
2191: */
2192: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
2193: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN

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

2890: g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).inspection_status_code := p_inspection_status_code;
2891:
2892: /* FP-J Lot/Serial Support Enhancement
2893: * If INV and PO J are installed, then the lots for the parent transaction will
2894: * be stored in rcv_lots_supply. We must match the lot number passed with that
2895: * of the parent transaction and also the parent_txn_id
2896: */
2897: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
2898: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN

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

3522: g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).inspection_status_code := p_inspection_status_code;
3523:
3524: /* FP-J Lot/Serial Support Enhancement
3525: * If INV and PO J are installed, then the lots for the parent transaction will
3526: * be stored in rcv_lots_supply. We must match the lot number passed with that
3527: * of the parent transaction and also the parent_txn_id
3528: */
3529: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
3530: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN

Line 5408: rcv_lots_supply rls,

5404: ,rsl.asn_line_flag asn_line_flag
5405: FROM rcv_supply rs,
5406: rcv_transactions rt,
5407: rcv_shipment_lines rsl,
5408: rcv_lots_supply rls,
5409: rcv_shipment_headers rsh
5410: WHERE rs.item_id = p_item_id
5411: --Bug 5250046: Removed the nvl and Modified the condition on item_revision.
5412: AND (p_revision is null or rs.item_revision = p_revision)