APPS.PO_RELGEN_PKG dependencies on PO_APPROVED_SUPPLIER_LIS_VAL_V

Line 3146: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES ASR

3142: AND nvl(PLL.cancel_flag,'N') = 'N'
3143: AND nvl(MSI.must_use_approved_vendor_flag,'N') = 'Y'
3144: AND not exists
3145: (SELECT sum(decode(ASR.allow_action_flag, 'Y', 1, -100))
3146: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES ASR
3147: WHERE ASL.using_organization_id in (PLL.ship_to_organization_id, -1)
3148: AND ASL.vendor_id = POH.vendor_id
3149: AND nvl(ASL.vendor_site_id, POH.vendor_site_id) = POH.vendor_site_id
3150: AND ASL.item_id = POL.item_id

Line 3156: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES ASR

3152: AND ASR.business_rule = '1_PO_APPROVAL'
3153: HAVING sum(decode(ASR.allow_action_flag, 'Y', 1, -100)) > 0
3154: UNION ALL
3155: SELECT sum(decode(ASR.allow_action_flag, 'Y', 1, -100))
3156: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES ASR
3157: WHERE ASL.using_organization_id in (PLL.ship_to_organization_id , -1)
3158: AND ASL.vendor_id = POH.vendor_id
3159: AND nvl(ASL.vendor_site_id, POH.vendor_site_id) = POH.vendor_site_id
3160: AND ASL.item_id is NULL

Line 3163: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL1

3159: AND nvl(ASL.vendor_site_id, POH.vendor_site_id) = POH.vendor_site_id
3160: AND ASL.item_id is NULL
3161: AND not exists
3162: (SELECT ASL1.ASL_ID
3163: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL1
3164: WHERE ASL1.ITEM_ID = POL.item_id
3165: AND ASL1.using_organization_id in (PLL.ship_to_organization_id, -1))
3166: AND ASL.category_id in
3167: (SELECT MIC.category_id

Line 3220: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES ASR

3216: AND nvl(PLL.cancel_flag,'N') = 'N'
3217: AND nvl(MSI.must_use_approved_vendor_flag,'N') = 'Y'
3218: AND exists
3219: (SELECT sum(decode(ASR.allow_action_flag, 'Y', 1, -100))
3220: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES ASR
3221: WHERE ASL.using_organization_id in (PLL.ship_to_organization_id, -1)
3222: AND ASL.vendor_id = POH.vendor_id
3223: AND nvl(ASL.vendor_site_id, POH.vendor_site_id) = POH.vendor_site_id
3224: AND ASL.item_id = POL.item_id

Line 3230: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES ASR

3226: AND ASR.business_rule = '1_PO_APPROVAL'
3227: HAVING sum(decode(ASR.allow_action_flag, 'Y', 1, -100)) < 0
3228: UNION ALL
3229: SELECT sum(decode(ASR.allow_action_flag, 'Y', 1, -100))
3230: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES ASR
3231: WHERE ASL.using_organization_id in (PLL.ship_to_organization_id , -1)
3232: AND ASL.vendor_id = POH.vendor_id
3233: AND nvl(ASL.vendor_site_id, POH.vendor_site_id) = POH.vendor_site_id
3234: AND ASL.item_id is NULL