DBA Data[Home] [Help]

APPS.PO_CHANGEORDERWF_PVT dependencies on PO_ALL_DOC_STYLE_LINES

Line 5067: PO_ALL_DOC_STYLE_LINES PDSL

5063: l_display_name
5064: from
5065: po_headers_all pha,
5066: po_vendors pv,
5067: PO_ALL_DOC_STYLE_LINES PDSL
5068: where pha.po_header_id = l_header_id
5069: and pha.vendor_id = pv.vendor_id
5070: AND NVL(PHA.STYLE_ID, 0) = PDSL.STYLE_ID (+)
5071: AND PHA.TYPE_LOOKUP_CODE = PDSL.DOCUMENT_SUBTYPE (+)

Line 5269: PO_ALL_DOC_STYLE_LINES PDSL

5265: l_global_agreement_flag,
5266: l_display_name
5267: from po_headers_all pha,
5268: hr_all_organization_units_tl hou,
5269: PO_ALL_DOC_STYLE_LINES PDSL
5270: where pha.po_header_id = l_header_id
5271: and pha.org_id = hou.organization_id(+)
5272: and hou.language(+) = userenv('LANG')
5273: AND NVL(PHA.STYLE_ID, 0) = PDSL.STYLE_ID (+)

Line 5437: PO_ALL_DOC_STYLE_LINES PDSL

5433: l_global_agreement_flag,
5434: l_display_name
5435: from po_headers_all pha,
5436: po_vendors pv,
5437: PO_ALL_DOC_STYLE_LINES PDSL
5438: where pha.po_header_id = l_header_id
5439: and pv.vendor_id = pha.vendor_id
5440: AND NVL(PHA.STYLE_ID, 0) = PDSL.STYLE_ID (+)
5441: AND PHA.TYPE_LOOKUP_CODE = PDSL.DOCUMENT_SUBTYPE (+)

Line 5593: PO_ALL_DOC_STYLE_LINES PDSL

5589: l_global_agreement_flag,
5590: l_display_name
5591: from po_headers_all pha,
5592: po_vendors pv,
5593: PO_ALL_DOC_STYLE_LINES PDSL
5594: where pha.po_header_id = l_header_id
5595: and pv.vendor_id = pha.vendor_id
5596: AND NVL(PHA.STYLE_ID, 0) = PDSL.STYLE_ID (+)
5597: AND PHA.TYPE_LOOKUP_CODE = PDSL.DOCUMENT_SUBTYPE (+)