DBA Data[Home] [Help]

APPS.POA_DBI_PO_DIST_F_C dependencies on PO_DOC_STYLE_HEADERS

Line 1262: po_doc_style_headers style,

1258: po_distributions_all pod,
1259: po_line_locations_all pll,
1260: po_lines_all pol,
1261: po_headers_all poh,
1262: po_doc_style_headers style,
1263: ( SELECT /*+ PARALLEL(pod) PARALLEL(psc) PARALLEL(plc) PARALLEL(inc)
1264: PARALLEL(ga) no_merge use_hash(pod) use_hash(psc)
1265: use_hash(plc) use_hash(v1) use_hash(ga) use_hash(pgoa)
1266: use_hash(hro) */

Line 1876: po_doc_style_headers style,

1872: FROM
1873: poa_dbi_pod_inc inc,
1874: poa_dbi_neg_details negd,
1875: poa_dbi_pod_rates rat,
1876: po_doc_style_headers style,
1877: gl_sets_of_books poa_gl,
1878: ( select /*+ PARALLEL(a) PARALLEL(pod) NO_MERGE */
1879: pod.po_distribution_id,
1880: pod.creation_date,

Line 2172: po_doc_style_headers doc_style,

2168: po_headers_all ref,
2169: po_requisition_headers_all prh,
2170: mtl_parameters par,
2171: fii_gl_ccid_dimensions ccid,
2172: po_doc_style_headers doc_style,
2173: pon_auction_headers_all ponh,
2174: ( SELECT /*+ cardinality(inc,1) */
2175: distinct pod.po_distribution_id, hro.ship_to_ou_id
2176: FROM

Line 2185: po_doc_style_headers style,

2181: po_headers_all ga,
2182: (select /*+ no_merge */ to_number(hro.org_information3) ship_to_ou_id,organization_id
2183: from hr_organization_information hro where
2184: hro.org_information_context='Accounting Information') hro,
2185: po_doc_style_headers style,
2186: po_headers_all phc,
2187: ( SELECT
2188: pl.item_id,
2189: ph.start_date,