DBA Data[Home] [Help]

APPS.PO_CHANGEORDERWF_PVT dependencies on PO_ALL_DOC_STYLE_LINES

Line 5219: PO_ALL_DOC_STYLE_LINES PDSL

5215: l_display_name
5216: from
5217: po_headers_all pha,
5218: po_vendors pv,
5219: PO_ALL_DOC_STYLE_LINES PDSL
5220: where pha.po_header_id = l_header_id
5221: and pha.vendor_id = pv.vendor_id
5222: AND NVL(PHA.STYLE_ID, 0) = PDSL.STYLE_ID (+)
5223: AND PHA.TYPE_LOOKUP_CODE = PDSL.DOCUMENT_SUBTYPE (+)

Line 5423: PO_ALL_DOC_STYLE_LINES PDSL

5419: l_global_agreement_flag,
5420: l_display_name
5421: from po_headers_all pha,
5422: hr_all_organization_units_tl hou,
5423: PO_ALL_DOC_STYLE_LINES PDSL
5424: where pha.po_header_id = l_header_id
5425: and pha.org_id = hou.organization_id(+)
5426: and hou.language(+) = userenv('LANG')
5427: AND NVL(PHA.STYLE_ID, 0) = PDSL.STYLE_ID (+)

Line 5591: PO_ALL_DOC_STYLE_LINES PDSL

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

Line 5747: PO_ALL_DOC_STYLE_LINES PDSL

5743: l_global_agreement_flag,
5744: l_display_name
5745: from po_headers_all pha,
5746: po_vendors pv,
5747: PO_ALL_DOC_STYLE_LINES PDSL
5748: where pha.po_header_id = l_header_id
5749: and pv.vendor_id = pha.vendor_id
5750: AND NVL(PHA.STYLE_ID, 0) = PDSL.STYLE_ID (+)
5751: AND PHA.TYPE_LOOKUP_CODE = PDSL.DOCUMENT_SUBTYPE (+)