DBA Data[Home] [Help]

APPS.PAAPIMP_PKG dependencies on PA_NL_INSTALLED

Line 703: AND (pa_nl_installed.is_nl_installed = 'N'

699: AND rcv_txn.PO_DISTRIBUTION_ID=po_dist.po_distribution_id
700: AND po_head.org_id=G_ORG_ID
701: AND po_head.vendor_id=VEND.Vendor_Id
702: AND po_dist.expenditure_type = type.expenditure_type
703: AND (pa_nl_installed.is_nl_installed = 'N'
704: OR ( pa_nl_installed.is_nl_installed = 'Y'
705: AND NOT EXISTS (SELECT 'X'
706: FROM mtl_system_items si,
707: po_lines_all pol

Line 704: OR ( pa_nl_installed.is_nl_installed = 'Y'

700: AND po_head.org_id=G_ORG_ID
701: AND po_head.vendor_id=VEND.Vendor_Id
702: AND po_dist.expenditure_type = type.expenditure_type
703: AND (pa_nl_installed.is_nl_installed = 'N'
704: OR ( pa_nl_installed.is_nl_installed = 'Y'
705: AND NOT EXISTS (SELECT 'X'
706: FROM mtl_system_items si,
707: po_lines_all pol
708: WHERE po_line.po_line_id = pol.po_line_id