APPS.ICX_POR_EXT_DIAG dependencies on PO_APPROVED_SUPPLIER_LIST

Line 869: FROM po_approved_supplier_list pasl,

865: xSupplier,
866: xItemNum,
867: xCategoryId,
868: xOrgName
869: FROM po_approved_supplier_list pasl,
870: po_vendors pv,
871: financials_system_params_all fsp,
872: mtl_system_items_kfv mi,
873: mtl_item_categories mic,

Line 1767: * Bug#3738786: owning_organization_id in po_approved_supplier_list

1763: END;
1764:
1765: /* Bug#3464695: Validating the Inventory Item's Purchasable Mode.
1766: * after validating the ASL.
1767: * Bug#3738786: owning_organization_id in po_approved_supplier_list
1768: * is the inventory_organization_id and not org_id in financial_system_params_all
1769: * Since the following query is only to find the validity of item in the ASL
1770: * AND ASLs are inventory org based and not OU based(which means to create
1771: * an ASL in an inventory org-INV1 the master item to be attached should be

Line 1784: 'ipo_approved_supplier_list pasl, ' ||

1780: ' ' || VALID_FOR_EXTRACT || ')) ' ||
1781: 'FROM ';
1782: IF p_test_mode = 'Y' THEN
1783: xString := xString ||
1784: 'ipo_approved_supplier_list pasl, ' ||
1785: 'imtl_system_items_kfv mi ';
1786: ELSE
1787: xString := xString ||
1788: 'po_approved_supplier_list pasl, ' ||

Line 1788: 'po_approved_supplier_list pasl, ' ||

1784: 'ipo_approved_supplier_list pasl, ' ||
1785: 'imtl_system_items_kfv mi ';
1786: ELSE
1787: xString := xString ||
1788: 'po_approved_supplier_list pasl, ' ||
1789: 'mtl_system_items_kfv mi ';
1790: END IF;
1791: xString := xString ||
1792: 'WHERE pasl.asl_id = :asl_id ' ||

Line 1993: 'ipo_approved_supplier_list pasl, '||

1989: 'mi.list_price_per_unit '||
1990: 'FROM icx_cat_item_prices p, ';
1991: IF p_test_mode = 'Y' THEN
1992: xString := xString ||
1993: 'ipo_approved_supplier_list pasl, '||
1994: 'imtl_system_items_kfv mi, '||
1995: 'ifinancials_system_params_all fsp ';
1996: ELSE
1997: xString := xString ||

Line 1998: 'po_approved_supplier_list pasl, '||

1994: 'imtl_system_items_kfv mi, '||
1995: 'ifinancials_system_params_all fsp ';
1996: ELSE
1997: xString := xString ||
1998: 'po_approved_supplier_list pasl, '||
1999: 'mtl_system_items_kfv mi, '||
2000: 'financials_system_params_all fsp ';
2001: END IF;
2002: xString := xString ||