DBA Data[Home] [Help]

APPS.OE_VERSION_HISTORY_UTIL dependencies on OE_SALES_CREDITS

Line 1542: FROM oe_sales_credits a

1538: l_version_number, --VERSION_NUMBER,
1539: 'N', --AUDIT_FLAG,
1540: l_version_flag, --VERSION_FLAG,
1541: p_phase_change_flag --PHASE_CHANGE_FLAG,
1542: FROM oe_sales_credits a
1543: WHERE a.header_id = p_header_id
1544: AND NOT EXISTS ( SELECT b.SALES_CREDIT_ID
1545: FROM OE_SALES_CREDIT_HISTORY b
1546: WHERE b.SALES_CREDIT_ID = a.SALES_CREDIT_ID

Line 1599: FROM OE_ORDER_HEADERS_ALL h, OE_SALES_CREDITS s

1595: ELSIF p_sales_credit_id <> FND_API.G_MISS_NUM THEN
1596:
1597: BEGIN
1598: SELECT h.version_number INTO l_current_version_number
1599: FROM OE_ORDER_HEADERS_ALL h, OE_SALES_CREDITS s
1600: WHERE h.header_id = s.header_id
1601: AND s.sales_credit_id = p_sales_credit_id;
1602: EXCEPTION WHEN NO_DATA_FOUND THEN
1603: SELECT h.version_number INTO l_current_version_number