DBA Data[Home] [Help]

APPS.PO_CONTRACTS_S dependencies on DUAL

Line 84: -- an individual column expression.

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

Line 106: from dual

102: Begin
103:
104: SELECT 'Y'
105: INTO x_diff_curr
106: from dual
107: where exists (
108: SELECT 'Exists'
109: FROM po_lines_all pol,
110: po_line_locations_all pll,

Line 184: --an individual column expression.

180: since you better have records that you're trying to approve */
181:
182: --
183: --SELECT list cannot include both the group function SUM and
184: --an individual column expression.
185:
186: -- bug3673292
187: -- Removd poh from the FROM clause
188: