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_RELGEN_PKG dependencies on PO_ASL_STATUS_RULES

Line 3092: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES ASR

3088: AND nvl(PLL.cancel_flag,'N') = 'N'
3089: AND nvl(MSI.must_use_approved_vendor_flag,'N') = 'Y'
3090: AND not exists
3091: (SELECT sum(decode(ASR.allow_action_flag, 'Y', 1, -100))
3092: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES ASR
3093: WHERE ASL.using_organization_id in (PLL.ship_to_organization_id, -1)
3094: AND ASL.vendor_id = POH.vendor_id
3095: AND nvl(ASL.vendor_site_id, POH.vendor_site_id) = POH.vendor_site_id
3096: AND ASL.item_id = POL.item_id

Line 3102: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES ASR

3098: AND ASR.business_rule = '1_PO_APPROVAL'
3099: HAVING sum(decode(ASR.allow_action_flag, 'Y', 1, -100)) > 0
3100: UNION ALL
3101: SELECT sum(decode(ASR.allow_action_flag, 'Y', 1, -100))
3102: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES ASR
3103: WHERE ASL.using_organization_id in (PLL.ship_to_organization_id , -1)
3104: AND ASL.vendor_id = POH.vendor_id
3105: AND nvl(ASL.vendor_site_id, POH.vendor_site_id) = POH.vendor_site_id
3106: AND ASL.item_id is NULL

Line 3166: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES ASR

3162: AND nvl(PLL.cancel_flag,'N') = 'N'
3163: AND nvl(MSI.must_use_approved_vendor_flag,'N') = 'Y'
3164: AND exists
3165: (SELECT sum(decode(ASR.allow_action_flag, 'Y', 1, -100))
3166: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES ASR
3167: WHERE ASL.using_organization_id in (PLL.ship_to_organization_id, -1)
3168: AND ASL.vendor_id = POH.vendor_id
3169: AND nvl(ASL.vendor_site_id, POH.vendor_site_id) = POH.vendor_site_id
3170: AND ASL.item_id = POL.item_id

Line 3176: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES ASR

3172: AND ASR.business_rule = '1_PO_APPROVAL'
3173: HAVING sum(decode(ASR.allow_action_flag, 'Y', 1, -100)) < 0
3174: UNION ALL
3175: SELECT sum(decode(ASR.allow_action_flag, 'Y', 1, -100))
3176: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES ASR
3177: WHERE ASL.using_organization_id in (PLL.ship_to_organization_id , -1)
3178: AND ASL.vendor_id = POH.vendor_id
3179: AND nvl(ASL.vendor_site_id, POH.vendor_site_id) = POH.vendor_site_id
3180: AND ASL.item_id is NULL