APPS.POA_DBI_PO_DIST_F_C dependencies on PO_GA_ORG_ASSIGNMENTS

Line 1300: from po_ga_org_assignments pgoa

1296: and nvl(pl.cancel_flag, 'N') = 'N'
1297: ) v1,
1298: ( select /*+ no_merge parallel(pgoa) */
1299: distinct po_header_id, purchasing_org_id
1300: from po_ga_org_assignments pgoa
1301: where enabled_flag = 'Y'
1302: ) pgoa
1303: WHERE plc.po_line_id = psc.po_line_id
1304: and psc.line_location_id = pod.line_location_id

Line 1385: from po_ga_org_assignments pgoa

1381: where bl.price_break_lookup_code is not null
1382: and nvl(bl.cancel_flag, 'N') = 'N'
1383: ) l,
1384: (select /*+ PARALLEL(pgoa) no_merge */ distinct po_header_id, purchasing_org_id
1385: from po_ga_org_assignments pgoa
1386: where enabled_flag = 'Y') pgoa,
1387: financials_system_params_all fsp, -- to get the functional currency of the blanket agreement
1388: gl_sets_of_books poa_gl
1389: where l.po_header_id = b.po_header_id

Line 2207: from po_ga_org_assignments pgoa

2203: and nvl(ph.cancel_flag, 'N') = 'N'
2204: and nvl(pl.cancel_flag, 'N') = 'N'
2205: ) v1,
2206: ( select distinct po_header_id, purchasing_org_id
2207: from po_ga_org_assignments pgoa
2208: where enabled_flag = 'Y'
2209: ) pgoa
2210: WHERE plc.po_line_id = psc.po_line_id
2211: and psc.line_location_id = pod.line_location_id