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_APPROVED_SUPPLIER_LIS_VAL_V

Line 5162: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES ASR

5158: AND nvl(PLL.cancel_flag,'N') = 'N'
5159: AND nvl(MSI.must_use_approved_vendor_flag,'N') = 'Y'
5160: AND not exists
5161: (SELECT 1
5162: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES ASR
5163: WHERE ASL.using_organization_id in (PLL.ship_to_organization_id, -1)
5164: AND ASL.vendor_id = POH.vendor_id
5165: AND nvl(ASL.vendor_site_id, POH.vendor_site_id) = POH.vendor_site_id
5166: AND ASL.item_id = POL.item_id

Line 5172: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES ASR

5168: AND ASR.business_rule = '1_PO_APPROVAL'
5169: AND ASR.allow_action_flag = 'Y' --Bug5597639
5170: UNION ALL
5171: SELECT 1
5172: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES ASR
5173: WHERE ASL.using_organization_id in (PLL.ship_to_organization_id , -1)
5174: AND ASL.vendor_id = POH.vendor_id
5175: AND nvl(ASL.vendor_site_id, POH.vendor_site_id) = POH.vendor_site_id
5176: AND ASL.item_id is NULL

Line 5179: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL1

5175: AND nvl(ASL.vendor_site_id, POH.vendor_site_id) = POH.vendor_site_id
5176: AND ASL.item_id is NULL
5177: AND not exists
5178: (SELECT ASL1.ASL_ID
5179: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL1
5180: WHERE ASL1.ITEM_ID = POL.item_id
5181: AND ASL1.using_organization_id in (PLL.ship_to_organization_id, -1))
5182: AND ASL.category_id in
5183: (SELECT MIC.category_id

Line 5260: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES ASR,

5256: AND nvl(POL.cancel_flag,'N') = 'N'
5257: AND nvl(PLL.cancel_flag,'N') = 'N'
5258: AND exists
5259: (SELECT 1
5260: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES ASR,
5261: MTL_SYSTEM_ITEMS MSI --Bug5597639
5262: WHERE ASL.using_organization_id in (PLL.ship_to_organization_id, -1)
5263: /*Bug5553138 Adding the below three conditions */
5264: AND MSI.organization_id = FSP.inventory_organization_id

Line 5275: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES ASR

5271: AND ASR.business_rule = '1_PO_APPROVAL'
5272: AND ASR.allow_action_flag <> 'Y' --Bug5597639
5273: UNION ALL
5274: SELECT 1
5275: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES ASR
5276: WHERE ASL.using_organization_id in (PLL.ship_to_organization_id , -1)
5277: AND ASL.vendor_id = POH.vendor_id
5278: AND nvl(ASL.vendor_site_id, POH.vendor_site_id) = POH.vendor_site_id
5279: AND ASL.item_id is NULL

Line 8980: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES ASR

8976: AND nvl(PLL.cancel_flag,'N') = 'N'
8977: AND nvl(MSI.must_use_approved_vendor_flag,'N') = 'Y'
8978: AND NOT exists
8979: (SELECT 1
8980: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES ASR
8981: WHERE ASL.using_organization_id in (PLL.ship_to_organization_id, -1)
8982: AND ASL.vendor_id = POH.vendor_id
8983: --Bug 16573818: Added the 'OR' clause below to match the vendor site code
8984: --for cases in which the vendor site IDs are different, but code is same.

Line 8997: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES ASR

8993: AND ASR.business_rule = '1_PO_APPROVAL'
8994: AND ASR.allow_action_flag = 'Y' --Bug5597639
8995: UNION ALL
8996: SELECT 1
8997: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES ASR
8998: WHERE ASL.using_organization_id in (PLL.ship_to_organization_id, -1)
8999: AND ASL.vendor_id = POH.vendor_id
9000: AND nvl(ASL.vendor_site_id, POH.vendor_site_id) = POH.vendor_site_id
9001: AND ASL.item_id is NULL

Line 9004: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL1

9000: AND nvl(ASL.vendor_site_id, POH.vendor_site_id) = POH.vendor_site_id
9001: AND ASL.item_id is NULL
9002: AND not exists
9003: (SELECT ASL1.ASL_ID
9004: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL1
9005: WHERE ASL1.ITEM_ID = POL.item_id
9006: AND ASL1.using_organization_id in
9007: (PLL.ship_to_organization_id, -1))
9008: AND ASL.category_id in

Line 9080: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES ASR,

9076: AND nvl(POL.cancel_flag,'N') = 'N'
9077: AND nvl(PLL.cancel_flag,'N') = 'N'
9078: AND exists
9079: (SELECT 1
9080: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES ASR,
9081: MTL_SYSTEM_ITEMS MSI --Bug5597639
9082: WHERE ASL.using_organization_id in (PLL.ship_to_organization_id, -1)
9083: /*Bug5597639 Adding the below three conditions */
9084: AND MSI.organization_id = FSP.inventory_organization_id

Line 9095: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES ASR

9091: AND ASR.business_rule = '1_PO_APPROVAL'
9092: AND ASR.allow_action_flag <> 'Y' -- Bug 5724696
9093: UNION ALL
9094: SELECT 1
9095: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES ASR
9096: WHERE ASL.using_organization_id in (PLL.ship_to_organization_id, -1)
9097: AND ASL.vendor_id = POH.vendor_id
9098: AND nvl(ASL.vendor_site_id, POH.vendor_site_id) = POH.vendor_site_id
9099: AND ASL.item_id is NULL

Line 9698: PO_APPROVED_SUPPLIER_LIS_VAL_V PASL,

9694: 'W'
9695: FROM PO_LINES_GT POL,
9696: PO_HEADERS_GT POH,
9697: PO_LINE_LOCATIONS_GT PLL,
9698: PO_APPROVED_SUPPLIER_LIS_VAL_V PASL,
9699: PO_ASL_ATTRIBUTES PAA,
9700: PO_ASL_STATUS_RULES_V PASR
9701:
9702: WHERE POH.po_header_id = p_document_id

Line 11154: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES ASR,

11150: AND nvl(POL.cancel_flag,'N') = 'N'
11151: AND nvl(PLL.cancel_flag,'N') = 'N'
11152: AND exists
11153: (SELECT 1
11154: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES ASR,
11155: MTL_SYSTEM_ITEMS MSI --Bug5597639
11156: WHERE ASL.using_organization_id in (PLL.ship_to_organization_id, -1)
11157: /*Bug5597639 Adding the below three conditions */
11158: AND MSI.organization_id = FSP.inventory_organization_id

Line 11169: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES ASR

11165: AND ASR.business_rule = '1_PO_APPROVAL'
11166: AND ASR.allow_action_flag <> 'Y' -- Bug 5724696
11167: UNION ALL
11168: SELECT 1
11169: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES ASR
11170: WHERE ASL.using_organization_id in (PLL.ship_to_organization_id, -1)
11171: AND ASL.vendor_id = POH.vendor_id
11172: AND nvl(ASL.vendor_site_id, POH.vendor_site_id) = POH.vendor_site_id
11173: AND ASL.item_id is NULL