eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_DOCUMENT_CHECKS_PVT dependencies on PO_ASL_STATUS_RULES

Line 3325: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES ASR

3321: AND nvl(PLL.cancel_flag,'N') = 'N'
3322: AND nvl(MSI.must_use_approved_vendor_flag,'N') = 'Y'
3323: AND not exists
3324: (SELECT 1
3325: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES ASR
3326: WHERE ASL.using_organization_id in (PLL.ship_to_organization_id, -1)
3327: AND ASL.vendor_id = POH.vendor_id
3328: AND nvl(ASL.vendor_site_id, POH.vendor_site_id) = POH.vendor_site_id
3329: AND ASL.item_id = POL.item_id

Line 3335: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES ASR

3331: AND ASR.business_rule = '1_PO_APPROVAL'
3332: AND ASR.allow_action_flag = 'Y' --Bug5597639
3333: UNION ALL
3334: SELECT 1
3335: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES ASR
3336: WHERE ASL.using_organization_id in (PLL.ship_to_organization_id , -1)
3337: AND ASL.vendor_id = POH.vendor_id
3338: AND nvl(ASL.vendor_site_id, POH.vendor_site_id) = POH.vendor_site_id
3339: AND ASL.item_id is NULL

Line 3423: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES ASR,

3419: AND nvl(POL.cancel_flag,'N') = 'N'
3420: AND nvl(PLL.cancel_flag,'N') = 'N'
3421: AND exists
3422: (SELECT 1
3423: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES ASR,
3424: MTL_SYSTEM_ITEMS MSI --Bug5597639
3425: WHERE ASL.using_organization_id in (PLL.ship_to_organization_id, -1)
3426: /*Bug5553138 Adding the below three conditions */
3427: AND MSI.organization_id = FSP.inventory_organization_id

Line 3438: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES ASR

3434: AND ASR.business_rule = '1_PO_APPROVAL'
3435: AND ASR.allow_action_flag <> 'Y' --Bug5597639
3436: UNION ALL
3437: SELECT 1
3438: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES ASR
3439: WHERE ASL.using_organization_id in (PLL.ship_to_organization_id , -1)
3440: AND ASL.vendor_id = POH.vendor_id
3441: AND nvl(ASL.vendor_site_id, POH.vendor_site_id) = POH.vendor_site_id
3442: AND ASL.item_id is NULL

Line 6333: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES ASR

6329: AND nvl(PLL.cancel_flag,'N') = 'N'
6330: AND nvl(MSI.must_use_approved_vendor_flag,'N') = 'Y'
6331: AND NOT exists
6332: (SELECT 1
6333: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES ASR
6334: WHERE ASL.using_organization_id in (PLL.ship_to_organization_id, -1)
6335: AND ASL.vendor_id = POH.vendor_id
6336: AND nvl(ASL.vendor_site_id, POH.vendor_site_id) = POH.vendor_site_id
6337: AND ASL.item_id = POL.item_id

Line 6343: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES ASR

6339: AND ASR.business_rule = '1_PO_APPROVAL'
6340: AND ASR.allow_action_flag = 'Y' --Bug5597639
6341: UNION ALL
6342: SELECT 1
6343: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES ASR
6344: WHERE ASL.using_organization_id in (PLL.ship_to_organization_id, -1)
6345: AND ASL.vendor_id = POH.vendor_id
6346: AND nvl(ASL.vendor_site_id, POH.vendor_site_id) = POH.vendor_site_id
6347: AND ASL.item_id is NULL

Line 6426: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES ASR,

6422: AND nvl(POL.cancel_flag,'N') = 'N'
6423: AND nvl(PLL.cancel_flag,'N') = 'N'
6424: AND exists
6425: (SELECT 1
6426: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES ASR,
6427: MTL_SYSTEM_ITEMS MSI --Bug5597639
6428: WHERE ASL.using_organization_id in (PLL.ship_to_organization_id, -1)
6429: /*Bug5597639 Adding the below three conditions */
6430: AND MSI.organization_id = FSP.inventory_organization_id

Line 6441: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES ASR

6437: AND ASR.business_rule = '1_PO_APPROVAL'
6438: AND ASR.allow_action_flag <> 'Y' -- Bug 5724696
6439: UNION ALL
6440: SELECT 1
6441: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES ASR
6442: WHERE ASL.using_organization_id in (PLL.ship_to_organization_id, -1)
6443: AND ASL.vendor_id = POH.vendor_id
6444: AND nvl(ASL.vendor_site_id, POH.vendor_site_id) = POH.vendor_site_id
6445: AND ASL.item_id is NULL

Line 7033: PO_ASL_STATUS_RULES_V PASR

7029: PO_HEADERS_GT POH,
7030: PO_LINE_LOCATIONS_GT PLL,
7031: PO_APPROVED_SUPPLIER_LIS_VAL_V PASL,
7032: PO_ASL_ATTRIBUTES PAA,
7033: PO_ASL_STATUS_RULES_V PASR
7034:
7035: WHERE POH.po_header_id = p_document_id
7036: AND POL.po_header_id = POH.po_header_id
7037: AND PLL.po_header_id = POH.po_header_id