APPS.POA_DBI_CUD_PKG dependencies on FND_GLOBAL

Line 109: l_query := l_query || fnd_global.newline||

105: ' || l_where_clause || '
106: and fact.consigned_code <> 1
107: and fact.contract_type is not null ';
108: if (l_sec_context = 'OU/COM') then
109: l_query := l_query || fnd_global.newline||
110: 'and fact.commodity_id <> -1 ';
111: elsif (l_sec_context = 'COMP') then
112: l_query := l_query ||
113: 'and fact.company_id = com.child_company_id

Line 114: and fact.cost_center_id = cc.child_cc_id'||fnd_global.newline;

110: 'and fact.commodity_id <> -1 ';
111: elsif (l_sec_context = 'COMP') then
112: l_query := l_query ||
113: 'and fact.company_id = com.child_company_id
114: and fact.cost_center_id = cc.child_cc_id'||fnd_global.newline;
115: end if;
116: l_query := l_query ||
117: 'group by fact.po_header_id,
118: fact.po_item_id,

Line 231: l_query := l_query || fnd_global.newline||

227: ' || l_where_clause || '
228: and fact.consigned_code <> 1
229: and fact.contract_type is null ';
230: if (l_sec_context = 'OU/COM') then
231: l_query := l_query || fnd_global.newline||
232: 'and fact.commodity_id <> -1 ';
233: elsif (l_sec_context = 'COMP') then
234: l_query := l_query ||
235: 'and fact.company_id = com.child_company_id

Line 236: and fact.cost_center_id = cc.child_cc_id'||fnd_global.newline;

232: 'and fact.commodity_id <> -1 ';
233: elsif (l_sec_context = 'COMP') then
234: l_query := l_query ||
235: 'and fact.company_id = com.child_company_id
236: and fact.cost_center_id = cc.child_cc_id'||fnd_global.newline;
237: end if;
238: l_query := l_query ||
239: 'group by fact.po_header_id, fact.po_release_id,fact.po_item_id, fact.base_uom, fact.org_id
240: )

Line 360: l_query := l_query || fnd_global.newline||

356: and fact.consigned_code <> 1
357: and fact.contract_type is null
358: and ((fact.p_contract_amt_b is not null and fact.p_contract_amt_b != 0) or (fact.p_savings_amt_b is not null and fact.p_savings_amt_b != 0)) ';
359: if (l_sec_context = 'OU/COM') then
360: l_query := l_query || fnd_global.newline||
361: 'and fact.commodity_id <> -1 ';
362: elsif (l_sec_context = 'COMP') then
363: l_query := l_query ||
364: 'and fact.company_id = com.child_company_id

Line 365: and fact.cost_center_id = cc.child_cc_id'||fnd_global.newline;

361: 'and fact.commodity_id <> -1 ';
362: elsif (l_sec_context = 'COMP') then
363: l_query := l_query ||
364: 'and fact.company_id = com.child_company_id
365: and fact.cost_center_id = cc.child_cc_id'||fnd_global.newline;
366: end if;
367: l_query := l_query ||
368: 'group by fact.po_header_id,
369: fact.po_item_id,