DBA Data[Home] [Help]

APPS.OE_VERIFY_PAYMENT_PUB dependencies on OE_DROP_SHIP_SOURCES

Line 1891: FROM OE_ORDER_LINES OOL, OE_DROP_SHIP_SOURCES ODSS

1887: WHERE OOH.PAYMENT_TYPE_CODE = 'CREDIT_CARD'
1888: AND OOH.HEADER_ID = p_header_id
1889: AND EXISTS
1890: (SELECT 'Purchase Released'
1891: FROM OE_ORDER_LINES OOL, OE_DROP_SHIP_SOURCES ODSS
1892: WHERE OOL.HEADER_ID = OOH.HEADER_ID
1893: AND ODSS.LINE_ID = OOL.LINE_ID
1894: AND ODSS.HEADER_id = OOL.HEADER_ID);
1895: EXCEPTION