DBA Data[Home] [Help]

APPS.PO_CONTRACTS_S dependencies on DUAL

Line 80: -- an individual column expression.

76:
77: --
78: --1) Need an NVL since sum can return NULL.
79: --2) SELECT list cannot include both the group function SUM and
80: -- an individual column expression.
81:
82: -- bug3673292
83: -- Removed table poh from the FROM clause.
84:

Line 99: from dual

95: Begin
96:
97: SELECT 'Y'
98: INTO x_diff_curr
99: from dual
100: where exists (
101: SELECT 'Exists'
102: FROM po_lines pol,
103: po_line_locations pll,

Line 176: --an individual column expression.

172: since you better have records that you're trying to approve */
173:
174: --
175: --SELECT list cannot include both the group function SUM and
176: --an individual column expression.
177:
178: -- bug3673292
179: -- Removd poh from the FROM clause
180: