DBA Data[Home] [Help]

APPS.PAAPIMP_PKG dependencies on PA_NL_INSTALLED

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

692: AND rcv_txn.PO_DISTRIBUTION_ID=po_dist.po_distribution_id
693: AND po_head.org_id=G_ORG_ID
694: AND po_head.vendor_id=VEND.Vendor_Id
695: AND po_dist.expenditure_type = type.expenditure_type
696: AND (pa_nl_installed.is_nl_installed = 'N'
697: OR ( pa_nl_installed.is_nl_installed = 'Y'
698: AND NOT EXISTS (SELECT 'X'
699: FROM mtl_system_items si,
700: po_lines_all pol

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

693: AND po_head.org_id=G_ORG_ID
694: AND po_head.vendor_id=VEND.Vendor_Id
695: AND po_dist.expenditure_type = type.expenditure_type
696: AND (pa_nl_installed.is_nl_installed = 'N'
697: OR ( pa_nl_installed.is_nl_installed = 'Y'
698: AND NOT EXISTS (SELECT 'X'
699: FROM mtl_system_items si,
700: po_lines_all pol
701: WHERE po_line.po_line_id = pol.po_line_id