DBA Data[Home] [Help]

APPS.OE_VERIFY_PAYMENT_PUB dependencies on OE_DROP_SHIP_SOURCES

Line 1818: FROM OE_ORDER_LINES OOL, OE_DROP_SHIP_SOURCES ODSS

1814: WHERE OOH.PAYMENT_TYPE_CODE = 'CREDIT_CARD'
1815: AND OOH.HEADER_ID = p_header_id
1816: AND EXISTS
1817: (SELECT 'Purchase Released'
1818: FROM OE_ORDER_LINES OOL, OE_DROP_SHIP_SOURCES ODSS
1819: WHERE OOL.HEADER_ID = OOH.HEADER_ID
1820: AND ODSS.LINE_ID = OOL.LINE_ID
1821: AND ODSS.HEADER_id = OOL.HEADER_ID);
1822: EXCEPTION