DBA Data[Home] [Help]

APPS.WSH_PO_CMG_PVT dependencies on WSH_INBOUND_TXN_HISTORY

Line 4152: -- present in WSH_INBOUND_TXN_HISTORY table.

4148: p_release_id IN NUMBER
4149: ) RETURN NUMBER IS
4150:
4151: -- Cursor to find out if there are any unmatched transactions
4152: -- present in WSH_INBOUND_TXN_HISTORY table.
4153:
4154: cursor c_pending_txns(p_header_id NUMBER,p_line_id NUMBER,
4155: p_line_location_id NUMBER,p_release_id NUMBER) IS
4156: SELECT '1'

Line 4159: WSH_INBOUND_TXN_HISTORY WTH

4155: p_line_location_id NUMBER,p_release_id NUMBER) IS
4156: SELECT '1'
4157: FROM
4158: RCV_FTE_LINES_V RFLV,
4159: WSH_INBOUND_TXN_HISTORY WTH
4160: WHERE RFLV.PO_HEADER_ID = p_header_id AND
4161: RFLV.SHIPMENT_HEADER_ID = WTH.SHIPMENT_HEADER_ID AND
4162: RFLV.PO_LINE_ID = NVL(p_line_id,RFLV.PO_LINE_ID) AND
4163: RFLV.PO_LINE_LOCATION_ID= NVL(p_line_location_id,RFLV.PO_LINE_LOCATION_ID) AND