DBA Data[Home] [Help]

APPS.OE_VERSION_HISTORY_UTIL dependencies on OE_SALES_CREDITS

Line 1605: FROM oe_sales_credits a

1601: l_version_number, --VERSION_NUMBER,
1602: 'N', --AUDIT_FLAG,
1603: l_version_flag, --VERSION_FLAG,
1604: p_phase_change_flag --PHASE_CHANGE_FLAG,
1605: FROM oe_sales_credits a
1606: WHERE a.header_id = p_header_id
1607: AND NOT EXISTS ( SELECT b.SALES_CREDIT_ID
1608: FROM OE_SALES_CREDIT_HISTORY b
1609: WHERE b.SALES_CREDIT_ID = a.SALES_CREDIT_ID

Line 1662: FROM OE_ORDER_HEADERS_ALL h, OE_SALES_CREDITS s

1658: ELSIF p_sales_credit_id <> FND_API.G_MISS_NUM THEN
1659:
1660: BEGIN
1661: SELECT h.version_number INTO l_current_version_number
1662: FROM OE_ORDER_HEADERS_ALL h, OE_SALES_CREDITS s
1663: WHERE h.header_id = s.header_id
1664: AND s.sales_credit_id = p_sales_credit_id;
1665: EXCEPTION WHEN NO_DATA_FOUND THEN
1666: SELECT h.version_number INTO l_current_version_number